Excel Functions Quiz

What does the SUM function do?

• Counts the number of cells

• Adds up a range of numbers

• Calculates the average

• Returns the smallest number

Which function would you use to find the average of a range?

• AVERAGE

• SUM

• COUNT

• MAX

What is the result of the formula =ROUND(3.567, 2)?

• 3.56

• 3.57

• 4

• 3.5

If you want to count all non-empty cells in a range, which function should you use?

• COUNT

• COUNTA

• COUNTIF

• AVERAGE

Which function returns the smallest value from a range?

• MAX

• MIN

• AVERAGE

• SUM

What does the COUNTIF function do?

• Counts all numbers in a range

• Counts cells based on a specific condition

• Sums a range of numbers

• Finds the average of a range

What will =INT(5.9) return?

• 5

• 6

• 5.9

• 0

Which of the following functions can be used to find the maximum value in a set of numbers?

• MIN

• MAX

• AVERAGE

• COUNT

What is the purpose of the COUNTA function?

• Counts only numeric cells

• Counts all cells regardless of type

• Counts blank cells

• Counts only text cells

Which formula will count how many times the number 10 appears in the range A1?

• =COUNT(A1)

• =COUNTIF(A1, 10)

• =COUNTA(A1)

• =SUM(A1=10)