Scribd
Upload
100 views4 pages

Oct 4 - Formula Review

This document provides a series of practice problems for common Excel formulas including addition, subtraction, multiplication, division, sum, average, min, max, currency formatting, and count. The problems are presented in a table with numbers in yellow cells for the user to enter the appropriate formula. Upon completion, the user is instructed to save the document and share it in their Google folder.

Uploaded by

api-442905635
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
100 views4 pages

Oct 4 - Formula Review

This document provides a series of practice problems for common Excel formulas including addition, subtraction, multiplication, division, sum, average, min, max, currency formatting, and count. The problems are presented in a table with numbers in yellow cells for the user to enter the appropriate formula. Upon completion, the user is instructed to save the document and share it in their Google folder.

Uploaded by

api-442905635
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 4

Formula Practice in Microsoft Excel

Download this document and complete the formulas for each question in the yellow bo
If you need to review how to do formulas, visit this website: http://www.gcflearnfree.org/excelformu

Addition of Two Cells Using Sum Function


Number 1Number 2 Answer Num1 Num2 Num3 Num4 Total
45 16 61 12 12 12 12 48
Use the data in
32 64 92 13 100 121 326 560 the following 4
17 122 139 1000.23 17.3 16.4 18.2 1052.13

Subtraction of Two Cells Using Sum Function (Format for Currency)


Number 1Number 2 Answer Num1 Num2 Num3 Num4 Total
54 36 18 17 15 21 121 $174.00
17 12 5 16 99 210.1 16.4 $341.50
-3 -12 9 1000.23 17.3 13.44 8.4 ###

Multiplication of Two Cells Using Max Function Average:


Number 1Number 2 Answer Num1 Num2 Num3 Num4 Max
21 18 378 64 72 17 31 72
54 36 1944 21 18 900 903 903
65 41 2665 21.56 21.65 21.54 21.55 21.65

Division of Two Cells Use Min Function


Answer (Format to 2
Number 1Number 2 Decimal Places) Num1 Num2 Num3 Num4 Min
13 5 2.6 54 64 17 31 17
65 7 9.29 45 45.55 45.001 32.005 32.005
81 9 9 12.65 21.54 21.566 12.64 12.64

Use the Average Function


Num1 Num2 Num3 Num4 Average
54 64 17 31 41.5
45 45.55 45.001 32.005 41.889
12.65 21.54 21.566 12.64 17.099

Use the Count Function


Num1 Num2 Num3 Num4 Count
54 31 2
45 45.55 45.001 32.005 4
12.65 21.566 12.64 3

...When you are finished, remember to save and put the completed document in your Goog
el
n the yellow boxes…
ree.org/excelformulas/2/print

Use the data in this chart for


the following 4 formulas…

Sales
May $ 235
June $ 544
July $ 829
August $ 610

Sum: $ 2,218
Average: $ 555
Min: $ 235
Max: $ 829
nt in your Google folder!

You might also like