Correct Answer:
B. MAX
To find the largest number in a range of cells in Excel, you would use the MAX function. The MAX function is specifically designed to return the largest numerical value from a set of values or a specified range of cells. For instance, =MAX(A1:A10) will identify the highest number within that particular range.
- MIN (A) is incorrect; this function is used to find the smallest number in a range.
- LARGE (C) is incorrect; while
LARGE(range, 1)would yield the same result,MAXis the direct and most common function for finding the absolute largest value. - COUNT (D) is incorrect; this function counts the number of cells that contain numbers in a range, not their maximum value.