Which function calculates the average of cells that meet specified criteria?

• A. Average
• B. Bar Chart
• C. AverageIf
• D. Cell

Answer: (C)

Calculating the average of values that meet certain conditions uses a function designed for conditional averaging. This function takes the range to check against a criterion, the criterion itself, and optionally a separate range to average. If you don’t specify a separate average range, it averages the values in the same range that meet the criterion. This is exactly what you need when you want the mean only for rows that satisfy a given condition.

The simple average would include all values in a range, ignoring any criteria. A bar chart is a visual representation, not a calculation. A cell is just a single data reference, not a calculation across multiple values.