Question

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

Answer 1

For sum:

It will add the number in the cell which in B4 to B8. You will get the results.

For MIN:

It will shows the smallest number which in

Before C3 to C7.

For Max:

It will shows the maximum number which in before B7 to B8.

For AVG:

IT will shows the percentage of the cell which are between the C6 to C8.

Thanks,