EDUCATOR-LEVEL-1 practice question 11 of 30

Which function would you use to find the highest value in a range of cells?

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

The MAX function in Google Sheets is a statistical function used to return the highest value from a given set of numeric values or a range of cells. For example, the formula =MAX(A1:A10) would scan cells A1 through A10 and display the largest number found within that range. It is the standard and correct function for this specific purpose.

Why Incorrect

A. The AVERAGE function calculates the arithmetic mean of the numbers in a range, not the highest value.
C. The MIN function finds the lowest (minimum) value in a range, which is the opposite of the required task.
D. The SUM function adds all the numerical values in a range together, rather than identifying the single highest value.

References

1. Google Docs Editors Help. (n.d.). MAX function. Google. Retrieved from https://support.google.com/docs/answer/3094013. The official documentation defines the function as: "Returns the maximum value in a numeric dataset." The page provides the syntax MAX(value1, [value2, ...]) and examples of its use on a range of cells.

Scroll to Top