Ad
Sponsored by Sir Tauqeer
CLICK HERE TO JOIN SIR TAUQUEER WHATSAPP GROUP
FOR PREPARATION CLASSES AND JOBS UPDATES
Join Now

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

Join Our WhatsApp Channel ×
Scroll to Top