Correct Answer:
C. =MAX()
The correct answer is =MAX(). In Microsoft Excel, the =MAX() function is specifically used to find the largest numerical value within a selected range of cells. It is a fundamental statistical function for analyzing data and identifying peak values.
- =SUM() calculates the total sum of numbers in a range.
- =AVERAGE() calculates the arithmetic mean of numbers in a range.
- =MIN() calculates the smallest numerical value in a range.
Each function serves a distinct purpose, and only =MAX() is designed for finding the maximum value.