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

Step 3:  In the   roup by  box  select the column for which subtotal is re uired. If the contents of the selected
                    column change  the subtotals are automatically recalculated.


            Step 4:  In the   alculate subtotals for  box  select the columns containing the values to obtain a subtotal.

            Step 5:  In   se function  box  select the desired function to calculate the subtotals.   ere  we have used
                    ‘Count’ function.)

            Step 6:   lick on the  O   button.



























             e can add another grouping  group   in same worksheet. For example  if we add colour and cost to the
            worksheet  we can make another group showing sum of cost of  erseys colour-wise for each si e.

            First group finds the count of si es available and second group displays cost of each colour for the different
             ersey si es available.







































                                                                       Advanced Features of Spreadsheet        163
   160   161   162   163   164   165   166   167   168   169   170