Excel Functions Quiz

Which function is used to find the total of numbers?

• ADD()

• SUM()

• TOTAL()

• COMBINE()

Which function calculates the average value?

• MEAN()

• COUNT()

• AVERAGE()

• ADD()

Which function gives the smallest number from a list?

• LOWEST()

• MIN()

• AVERAGE()

• SMALL()

Which function gives the highest number from a list?

• MIN()

• MAX()

• HIGH()

• TOP()

What does the COUNT function do?

• Adds numbers

• Finds biggest number

• Finds average

• Counts number of values

Which formula adds 5, 10, and 15 together?

• =ADD(5,10,15)

• =SUM(5,10,15)

• =AVERAGE(5+10+15)

• =TOTAL(5:15)

What will =AVERAGE(10, 20, 30) return?

• 60

• 30

• 20

• 15

What does =COUNT(3, "text", 7) return?

• 3

• 1

• 2

• 0

What will =MIN(8, 4, 12) return?

• 12

• 8

• 4

• 0

Which of the following is used to begin any formula in Excel?

• =

• +

• (

• *