Web Analytics

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)

Verified Answer :

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]).