2.5 Part 1: Formulas Review

Add the values in cells A1 and A2.

• =A1+A2
• =1+2

• A1+A2

• =SUM(A1:A2)

To calculate the average score of a class test, with scores listed in cells B1 to B25, which formula is appropriate?

• =SUM(B1:B25

• =MAX(B1:B25)

• =AVERAGE(B1:B25)

• =B1+B25

You need to find the highest temperature recorded over a month, with daily temperatures in cells C1 to C31. What's the correct formula?

• =SUM(C1:C31)

• =AVERAGE(C1:C31)

• =MIN(C1:C31)

• =MAX(C1:C31)

To determine the lowest price among a list of competitors' prices in cells D1 to D10, which formula should you use?

• =MAX(D1:D10)

• =AVERAGE(D1:D10)

• =MIN(D1:D10)

• =SUM(D1:D10)

You want to add up the values in cells A1, B3, and C5. What's the appropriate formula?

• =SUM(A1:C5)

• =SUM(A1,B3,C5)

• =AVERAGE(A1,B3,C5)

• =A1+B3+C5

To calculate the difference between the highest and lowest sales figures in column E (cells E1 to E20), which formula combination should you use?

• =SUM(E1:E20) - AVERAGE(E1:E20)

• =MAX(E1:E20) - MIN(E1:E20)

• =AVERAGE(E1:E20) - MIN(E1:E20)

• =MAXIMUM(E1:E20) + MINIMUM(E1:E20)

You need to find the average of three specific cells: F2, G4, and H6. What's the correct formula?

• =SUM(F2,G4,H6)

• =AVERAGE(F2:H6)

• =AVERAGE(F2,G4,H6)

• =MAX(F2,G4,H6)

To add 10 to the value in cell A1, which formula should you use?

• =SUM(A1,10)

• =A1+10

• =AVERAGE(A1,10)

• =MAX(A1,10)

What formula adds all numbers in column A?

• =SUM(A:A)

• =AVERAGE(A:A)

• =A1+A2+A3

• =MAX(A:A)

How do you multiply the value in B1 by 5?

• =B1x5

• =B1*5

• =MULTIPLY(B1,5)

• =SUM(B1,5)