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

