Question

Hich formula would you enter to return the number 2?

=MAX(A2:B5)
=AVERAGE(A2:B5)
=SUM(A2:B5)
=MIN(A2:B5)

Answer 1

=MIN(A2:B5)

Step-by-step explanation:

The values are:

A B

10 13.5

2 6.08

3 7.53

5 45.1

MAX(A2:B5) will return 45.1

Average(A2:B5) will return average of all numbers.

And SUM(A2:B5) will return sum of all the number.

And MIN (A2:B5) will return 2.

Hence, the correct answer is MIN(A2:B5) OR fourth option.