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

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.

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.

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.