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

