Page 211 - TP_IT_V1.0_C10_flipbpookl
P. 211

The steps to consolidate data are as follows:
                 Step 1:  Create Sheet1 for Unit Test, Sheet2 for Term 1 Exam and Sheet3 for Term 2 Exam in the spreadsheet.













                 Step 2:  Select the range B4:B9 in the Unit Test sheet.
                 Step 3:  Select the Data   Define Range option from the Menu bar.




























                         The Define Database Range dialog box opens.
                 Step 4:  Specify the range name in the Name text box and click on the OK button.
























                   This will give a name to the range you wish to use in the data consolidation.
                 Step 5:  Repeat step 2 to 4 to give a range name for Term 1 Exam and Term 2 Exam sheets.
                 Step 6:   Create Sheet4 and rename it as Final Result for consolidated marks of all three added up to generate the final
                         result.
                 Step 7:  Click on cell B4.


                                                                      Electronic Spreadsheet (Advanced) using LibreOffice Calc  209
   206   207   208   209   210   211   212   213   214   215   216