Which function is similar to IF functions and returns the average of cells that meet a condition?

• A. AutoFill
• B. Column
• C. AverageIf
• D. Cell Range

Answer: (C)

Conditional aggregation lets you compute an average only for cells that satisfy a given condition. The function that does this is AverageIf (often written as AVERAGEIF). It tests each value in a range against a criterion and averages only those that pass the test. You can specify the range to test and, optionally, a separate range to average; if the ranges are the same, you test and average the same set of cells. This matches the idea of using an IF-like test to pick which numbers to include in the average. AutoFill, Column, and Cell Range aren’t functions for conditional calculation—AutoFill copies patterns, Column is a reference to a whole column, and Cell Range is just a group of cells—so they don’t compute a conditional average.