Page 164 - IT 402 v2.0 class 10
P. 164
Lab Assignment ‘n Activity I nte r - D is cip l inar y
Complete the following activities and tick on the circle.
et us consider a workbook which contains data of expenses on stationery items for four
uarters of a year. he data is broken down into four uarters and stored in four different
worksheets in a workbook. reate a onsolidated Summary sheet which will show total
expenditure in a year.
CREATING SUBTOTAL
he Subtotal command is used to automatically create groups and apply inbuilt functions like S M O N
etc. to summari e data.
For example the Subtotal command can be used to calculate the number of erseys of different si es
re uired for players.
o insert Subtotal values into a worksheet:
Step 1: Select the range of cells with values for which subtotal function needs to be implemented. nsure
that the columns must have labels.
Step 2: lick on ata menu and then select Subtotals.. option. Subtotals dialog box appears on the screen.
162 Touchpad Information Technology-X

