Which term describes the preset formula used to compute the average of a cell range?

• A. AverageIf
• B. AutoFill
• C. Average
• D. Absolute Reference

Answer: (C)

This question tests your knowledge of the function used to calculate the mean of values in a range. In spreadsheet programs, the built-in function for this is the Average function. You’d use it like =AVERAGE(A1:A10) to get the arithmetic mean of all numbers in cells A1 through A10. That’s why the term described here is the Average function—the direct tool for computing the average of a set of numbers. Other options refer to different ideas: AverageIf calculates a mean only for cells that meet a condition, AutoFill fills cells with a pattern or sequence, and Absolute Reference locks a cell reference so it doesn’t change when you copy a formula.