Correct Answer:
C. AVERAGE
Spreadsheet programs offer a wide array of built-in functions to perform various calculations efficiently. To determine the average of a set of numbers, a specific function is used that sums the values and then divides by the count of those values.
- C: AVERAGE is the correct function. This function is specifically designed to calculate the arithmetic mean of a range of numbers, providing the sum of the values divided by the number of values.
- A: SUM is incorrect because it calculates the total sum of a range of numbers, not their average.
- B: COUNT is incorrect as it counts the number of cells in a range that contain numbers, but does not perform any arithmetic calculation like averaging.
- D: TOTAL is not a standard Excel function for calculating an average; it's a general term that might imply a sum, but not an average.