Which function would you use to find the largest number in a range?

A. MIN
B. MAX
C. LARGE
D. COUNT
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, MAX is 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.

Leave a Comment

Scroll to Top