Excel Functions Quiz

Which Excel function is used to count the number of cells in a range that meet a specific condition?

• AVERAGE

• MIN

• COUNTIF

• IFERROR

What does the MAX function in Excel do?

• It calculates the average of a range of numbers.

• It finds the largest value in a range of numbers.

• It counts the number of cells with values greater than a specified value.

• It counts the number of cells in a range.

Which Excel function allows you to perform different actions based on whether a specified condition is met or not?

• AVERAGE

• MIN

• IF

• COUNT

What does the MIN function in Excel do?

• It finds the smallest value in a range of numbers.

• It counts the number of cells with values smaller than a specified value.

• It calculates the sum of a range of numbers.

• It counts the number of cells in a range.

What Excel function is used to find the average of a range of numbers?

• SUM

• COUNT

• AVERAGE

• IF

Which function is used to determine if a cell meets a certain condition and return one value if true and another value if false?

• SUM

• COUNT

• IF

• MAX

What does the COUNT function in Excel do?

• It calculates the sum of a range of numbers.

• It finds the smallest value in a range of numbers.

• It counts the number of cells in a range.

• It counts the number of cells with values.

Which Excel function is used to find the largest value in a range of numbers?

• COUNTIF

• AVERAGE

• MIN

• MAX

What does the IFERROR function in Excel do?

• It calculates the sum of a range of numbers.

• It counts the number of cells with errors in a range.

• It returns a specified value if a formula results in an error.

• It counts the number of cells in a range.

What Excel function is used to find the smallest value in a range of numbers?

• COUNT

• AVERAGE

• MIN

• MAX