Question

Consider the following worksheet that shows the number of students in different courses in different years. (See
What will be the result of the following formulas? = SUM (B4:B8) = MIN (C3:C7) = AVERAGE (C6:C8) = MAX (B7:B8)

Answer 1

Click on the Auto Sum Tab after preparing the excel sheet and found following results

   SUM (B4:B8) = 821

   MIN (C3:C7) =    45

   AVERAGE (C6:C8) = 53.66667

   MAX (B7:B8) = 211