Page 277 - Trackpad IT-402_Class-IX
P. 277

•  Max(): It returns the maximum value out of the given values.  Let us find the maximum quantity purchased in the
              given worksheet.
              =Max(C7:C11)
              OR
              =Max(C7;C8;C9;C10;C11)
              OR
              =Max(C7:C9;C10:C11)

              OR
              =Max(C7:C10;C11)
            •  Count(): It returns the count of the number of cells that contain numeric values. Let us count the number of articles
              in the given worksheet.
              =Count(C7;C8;C9;C10;C11)

              OR
              =Count(C7:C9;C10:C11)
              OR
              =Count(C7:C10;C11)
              OR
              =Count(C7:C11)
            •  Average(): It returns the average of the given values. Let us find the average price of an article in the given worksheet.
              =Average(D7:D11)
              OR
              =Average(D7;D8;D9;D10;D11)

              OR
              =Average(D7:D9;D10:D11)
              OR
              =Average(D7:D10;D11)
            Let us practice the formula and functions learnt so far using the following spreadsheet.








                                                                                              To open the
                                                                                              Function Wizard:
                                                                                          Short key  Ctrl  +  F2






















                                                                                          Electronic Spreadsheet  277
   272   273   274   275   276   277   278   279   280   281   282