Excel Functions Quiz

What does the SUM function do?

• Returns the smallest number

• Counts the number of cells

• Calculates the average

• Adds up a range of numbers

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

• MAX

• SUM

• AVERAGE

• COUNT

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

• 3.56

• 3.57

• 3.5

• 4

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

• COUNT

• COUNTA

• AVERAGE

• COUNTIF

Which function returns the smallest value from a range?

• AVERAGE

• MAX

• MIN

• 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?

• 6

• 0

• 5.9

• 5

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

• COUNT

• MIN

• AVERAGE

• MAX

What is the purpose of the COUNTA function?

• Counts only numeric cells

• Counts only text cells

• Counts blank cells

• Counts all cells regardless of type

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

• =COUNTA(A1)

• =COUNTIF(A1, 10)

• =COUNT(A1)

• =SUM(A1=10)