Which of the following functions returns the highest value in a range of cells?

The MAX function returns the largest, or highest, value in a range of cells. MIN returns the smallest value, while SUM adds values; TOTAL is not the function used for this purpose. The correct choice is MAX.

AI-written and checked against the verified answer.