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

