Page 192 - Trackpad 402_Class-X_Final
P. 192

Step 3:  Click on Data tab and select Define Range option. The Define Database Range dialog box opens.



















        Step 4:   Specify the range name and click on OK button. This will give a name to the range you wish to use in the data
                consolidation.





















                Repeat the above steps to give a range name for half yearly and finals marks.
        Step 5:   Create Sheet4 and rename it as Final Result for consolidated marks of all three added up to generate the final
                result. Click on cell B4.


















        Step 6:  Click on Data tab and select Consolidate option. The Consolidate dialog box appears.


















          192   Trackpad Information Technology-X
   187   188   189   190   191   192   193   194   195   196   197