Excel Formulas Quiz

Which formula adds values in cells A1 to A5?

• =TOTAL(A1:A5)

• =ADD(A1:A5)

• =SUM(A1:A5)

• =PLUS(A1:A5)

What does the formula =ROUND(12.786, 2) return?

• 12.78

• 12.79

• 12.7

• 13

What does =TODAY() display in Excel?

• Today's date

• Day name

• Current time

• Tomorrow’s date

Which function gives the average of values?

• =SUM()

• =AVERAGE()

• =ROUND()

• =MID()

What does =MAX(5, 9, 2) return?

• 2

• 9

• 5

• 0

What does =MIN(15, 8, 21) return?

• 21

• 8

• 15

• 0

Which formula counts only numeric values in a range?

• =COUNTA(A1:A5)

• =COUNT(A1:A5)

• =SUM(A1:A5)

• =ROUND(A1:A5)

Which function counts both numbers and text entries in a range?

• =COUNT()

• =SUM()

• =COUNTA()

• =MAX()

Which of the following shows the correct use of the AVERAGE function?

• =AVG(A1:A10)

• =AVERAGE(A1:A10)

• =TOTAL(A1:A10)

• =MEAN(A1:A10)

What is the result of =SUM(4, 5, 6)?

• 11

• 15

• 9

• 10