Quiz › Formulas & Functions › SUM and AVERAGE

SUM and AVERAGE: Excel Quiz

5 quick questions. Pick an answer to see if you are right.

A1 = 10, A2 = 20, A3 = 30. What will this formula return?
=SUM(A1:A3)
- A. 60
- B. 3
- C. 30
- D. 20
Show the answer
A — 60. 10+20+30 is 60.
A1 = 10, A2 = 20, A3 = 30. What will this formula return?
=AVERAGE(A1:A3)
- A. 20
- B. 30
- C. 60
- D. 10
Show the answer
A — 20. 60 divided by 3 cells is 20.
A1 = 10, A2 is empty, A3 = 30. What will this formula return?
=AVERAGE(A1:A3)
- A. 20
- B. 40
- C. An error
- D. 13.33
Show the answer
A — 20. AVERAGE skips empty cells: 40 divided by 2 is 20.
A1 = 5, A2 has the word Apple, A3 = 15. What will this formula return?
=SUM(A1:A3)
- A. 15
- B. 0
- C. 20
- D. An error
Show the answer
C — 20. SUM skips text inside a range. 5+15 is 20.
A1 = 10 and B1 = 5. What will this formula return?
=SUM(A1,B1)*2
- A. 15
- B. 25
- C. 20
- D. 30
Show the answer
D — 30. SUM gives 15 first, then 15*2 is 30.