Page 235 - Trackpad 402_Class-X_Final
P. 235
Sneak Peek MS Office
I To Consolidate Data in Microsoft Excel:
1. Click on the ‘Data’ tab. Click on ‘Consolidate’ option in the ‘Data’ command group.
‘Consolidate’ dialog box appears on the screen.
2. Choose the desired ‘Function’ and ‘Reference’ for the data.
3. Click on Top row, Left column and Create links to source data check box.
4. Click on ‘OK’ button.
II To Create Subtotal in Microsoft Excel:
1. Sort the worksheet by the data.
2. Click on the ‘Data’ tab and then click the ‘Subtotal’ command in ‘Outline’ command group.
Electronic Spreadsheet (Advanced) 235

