Correct Answer:
C. =MAX()
In Excel, functions are used to perform calculations on data. The command used to calculate the maximum value within a specified range is =MAX(). This function efficiently identifies and returns the largest numerical value from the selected cells.
- =SUM() is used to calculate the total sum of all values in a range.
- =AVERAGE() calculates the arithmetic mean of the values in a range.
- =MIN() is used to find the smallest numerical value in a range, which is the opposite of MAX().
Understanding these distinct functions is crucial for effective data analysis in Excel.