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

e can see the grouping of the whole worksheet in small segments using             ..  or     given on the left
        panel.  o view complete grouping  it is on     as shown in above worksheet.

         o see only the function applied in groups select numbers on the left panel. It shows count of each si e
        available with its grand total along with cost of each colour and its grand total.





















        If we select      it will show the function applied to first group. In this example  it shows only the count of each
        si e and its grand total.















        If we select      it shows only the grand total of the first group.










          Sneak Peek




                To Create Subtotal in Microsoft Excel:

                 .  Sort the worksheet by the data.
                 .   lick on the   ata  tab and then click the  Subtotal  command in  Outline  command group.

                 .   he  Subtotal  dialog box will appear on the screen.  lick the drop-down arrow for the   t
                   each change in  and select the desired field.
                 .   lick the drop-down arrow for the   se function  field to select the desired function.
                5.  In the   dd subtotal to  field  select the desired column and then click on  O   button.








         164       Touchpad Information Technology-X
   161   162   163   164   165   166   167   168   169   170   171