PREMIUM
Join our WhatsApp Channel
Daily MCQs, Past Papers & Jobs for PPSC, FPSC, CSS
Daily MCQs • Past Papers • Jobs for PPSC, FPSC, CSS
Join Channel

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.
0 comments

Leave a Reply

Join Our WhatsApp Channel ×