What function would you use to find the maximum value in a range?

The function used to find the maximum value in a given range of numbers is MAX(). This function evaluates all the numeric values within the specified range and returns the highest one. For instance, if you have a range of sales figures and want to identify the best-performing month, you would use MAX() to determine which month's sales were the highest.

The other options serve different purposes: MIN() is used to find the minimum value, AVERAGE() calculates the mean of the numbers in a range, and SUM() totals all the values. These functions are useful for different analytical needs, but they do not perform the task of identifying the maximum value like MAX() does.