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
   230   231   232   233   234   235   236   237   238   239   240