Question

What will be the result of the following formulas? = SUM (B4:B8) = MIN (C3:C7) = AVERAGE (C6:C8) = MAX (B7:B8)

Answer 1

The formula ‘SUM’ means addition of all numbers.
Therefore, =SUM(B4:B8)
=B4+B5+B6+B7+B8

The formula ‘MIN’ means finding the smallest value available in the given cells.
Therefore, =MIN(C3:C7)
It will find the lowest number.

The formula ‘AVERAGE’ will find the mean of all the provided data.
Therefore, =AVERAGE(C6:C8)
It will find the mean of the data.
Average or Mean= Sum of all observations/ Number of observations.

The formula ‘MAX’ will find the maximum value in the provided data.
Therefore, =MAX(B7:B8)
It will find the maximum or highest value in the given or provided data.




I hope it helped!