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 questionsGoogle 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).
Keep practicing
Take the free EDUCATOR-LEVEL-1 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other EDUCATOR-LEVEL-1 practice questions
- Question 1Which function would you use to find the lowest value in a range of cells?
- Question 2What is the shortcut key to wrap text within a cell?
- Question 3What is the Google feature that allows you to limit your search results to pages that hav…
- Question 4What is the process for integrating Meet with Google Classroom?
- Question 5What is the shortcut to undo an action in your Google Sheets document?
- Question 6Which type of external content can you easily insert into a Google Doc using smart chips?
