Excel Functions Quiz

Which function is used to find the total of a range?

• TOTAL()

• SUM()

• ADD()

• MAX()

Which function gives the average of numbers?

• COUNT()

• AVERAGE()

• SUM()

• MIN()

What does =MIN(10, 5, 8) return?

• 10

• 5

• 8

• 0

Which of these is used to find the highest value?

• MIN()

• MAX()

• COUNT()

• SUM()

What does =COUNT(4, "Book", 8) return?

• 3

• 2

• 1

• 0

Which formula correctly calculates total from A1 to A10?

• =ADD(A1:A10)

• =TOTAL(A1:A10)

• =SUM(A1:A10)

• =A1+A10

Which of these is a function in Excel?

• =A1 + A2

• =10 + 15

• =SUM(A1:A5)

• A1 + A2

Which formula calculates average marks from B1 to B5?

• =AVG(B1:B5)

• =AVERAGE(B1:B5)

• =SUM(B1:B5)/B5

• =ADD(B1:B5)

Which function counts only numeric entries?

• AVERAGE()

• COUNT()

• SUM()

• MAX()

What symbol does a formula always begin with?

• =

• +

• :

• *