Unit 2: Electronic Spreadsheet (Advanced)
Assignment 1
Objective: Applying Data Consolidation in OO Calc
Task:
1. Create a new file in spreadsheet software and enter marks data of Test-1 on sheet1.
2. On the Sheet2, enter the marks data of Test-2 .
3. Rename all worksheets like sheet1 as Test-1, sheet2 as Test-2.
4. Now sheet3, rename as consolidated sheet.
Solution:
1. Create a new spreadsheet in OpenOffice Calc.
2. Enter the data for Sheet 1 and rename sheet as Test-1. To rename the worksheet right click on sheet tab then type the desired name. Press enter key to accept the name.
3. Follow step 2 for enter Test-2 data.
4. To display the consolidation result, rename sheet3 as Consolidated.
5. Select the cell ranges where results needs to appear.
6. Click on Data ⇢ Consolidate option. A consolidate dialog box will appear.
7. Select your desired function (Sum here) and add references to the cells by selecting ranges.
8. Move the cursor Test1 worksheet and select the range. Click on Add button.
9. Repeat the same for Test-2 worksheets.
10. In copy result to box, select a range on consolidated sheet.
11.Click on OK button.
Output
