Page 164 - IT 402 v2.0 class 10
P. 164

Lab Assignment ‘n Activity                           I nte r - D is cip l inar y





             Complete the following activities and tick on the circle.
                et  us  consider  a  workbook  which  contains  data  of  expenses  on  stationery  items  for  four
              uarters of a year.  he data is broken down into four  uarters and stored in four different
             worksheets  in  a  workbook.   reate  a    onsolidated  Summary   sheet  which  will  show  total
             expenditure in a year.




           CREATING SUBTOTAL

         he Subtotal command is used to automatically create groups and apply inbuilt functions like S M   O N
                 etc. to summari e data.
        For example  the  Subtotal  command can be used to calculate the number of   erseys  of different si es
        re uired for players.

         o insert Subtotal values into a worksheet:

        Step 1:  Select the range of cells with values for which  subtotal  function needs to be implemented.  nsure
                that the columns must have labels.





















        Step 2:   lick on   ata  menu and then select  Subtotals..  option.  Subtotals  dialog box appears on the screen.



























         162       Touchpad Information Technology-X
   159   160   161   162   163   164   165   166   167   168   169