Question

What does the AVERAGEIF function do in Excel?

A Calculates the average of a range of cells that meet specified criteria Correct Answer Incorrect Answer
B Returns the average of the smallest values in a range of cells Correct Answer Incorrect Answer
C Counts the number of cells in a range that are not empty Correct Answer Incorrect Answer
D Returns the average of the largest values in a range of cells Correct Answer Incorrect Answer
E None of these Correct Answer Incorrect Answer

Solution

The AVERAGEIF function in Excel calculates the average of a range of cells that meet specified criteria.

Practice Next
×
×