What function would you use to display the highest value in a range?

The MAX function is specifically designed to find and return the highest value within a specified range of numbers. When you use this function, it evaluates all the numeric entries in the range and identifies the largest number present. This is particularly useful in scenarios where you need to analyze data sets to determine maximum performance, sales figures, or any other values where the highest measurement is significant.

In contrast, the MIN function is used to find the smallest number, the AVERAGE function calculates the mean of a range of values, and the SUM function adds together all the numbers in the range. Each of these functions serves its own specific purpose, but for the task of identifying the highest value, the MAX function is clearly the appropriate choice.