Question

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

Answer 1

sum=+
min=lowest number
average=all no+%the no you have
max=the highest number

Answer 2

The result of the  following would be :

• =SUM(B4:B8) – It will display the sums of values in cells in the range B4: B8

• =MIN (C3:C7) - It will display the minimum value out  of the values in cells in the range C3:C7

• =AVERAGE (C6:C8) - It will display the average of values in cells in the range C6:C8

• =MAX (B7:B8) - It will display the maximum value out of values in cells in the range B7:B8