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

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.

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.

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).