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

