Page 150 - IT_V1.0_Class10
P. 150

We can see the grouping of the whole sheet in small segments using (1, 2, 3, 4,..) or [ ] given on the left panel.
              To view complete grouping, it is on 7 as shown in above sheet.

              To see only the function applied in groups select numbers on the left panel.

              If we select 6, it will show the function applied to first, second and third group.


























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







              Subtotal Outline

              When you use the Subtotals tool, Calc inserts an outline to the left of the row number column. This outline
              represents the hierarchical structure of your subtotals, and can be used to hide or show data at different
              levels in the hierarchy using the numbered column indicators at the top of the outline or the group indicators,
              denoted by plus (+) and minus (-) signs.
              To remove the outline feature from the sheet at any time, go to Data to select Group and Outline and
              choose the Remove Outline option. To apply again, go to Data to select Group and Outline and choose the
              AutoOutline option.






                148     Information Technology Play (Ver 1.0)-X
   145   146   147   148   149   150   151   152   153   154   155