EDUCATOR-LEVEL-1 practice question 20 of 30

Which of the following Google Sheets functions can be used to calculate the average value in a range?

Full set: 210 questions
Answer options
A: MAX
B: COUNT
C: AVERAGE Correct answer
D: MIN
Correct Answer:
C. AVERAGE
Explanation

Google Sheets supplies a dedicated statistical function, AVERAGE(range), which returns the arithmetic mean of all numeric values in the selected range. MAX, MIN, and COUNT perform other single-value or counting operations and therefore cannot calculate an average.

Why Incorrect

A. MAX – Returns the largest value only; no averaging performed.
B. COUNT – Tallies how many cells contain numbers; does not compute their mean.
D. MIN – Returns the smallest value; does not divide by the item count.

References

1. Google Docs Editors Help – “AVERAGE” function, Usage paragraph (support.google.com/docs/answer/3093995).

2. Google Docs Editors Help – “COUNT” function, Definition (support.google.com/docs/answer/3093478).

3. Google Docs Editors Help – “MAX” & “MIN” functions, Function list page (support.google.com/docs/table/25273).

Scroll to Top