Question

You've been asked to find the largest number in a range of numbers. Which of the following could you use to find the largest number in range E11:E23?

A. =MIN(E11:E23)
B. =AVERAGE(E11:E23)
C. =MAX(E11:E23
D. =SUM(E11:E23)

Answer 1

The answer is (c.) =MAX(E11:E23)

There are different functions in Microsoft excel including Sum(), Average(), Min(), and Max(). To find or return the largest number in a given cell range, Max() is used.The Syntax for this function is MAX(number1,[number2]).