Mahavir Senior Model School
Practical File Questions
Session : 2024-25
Unit 2: Electronic Spreadsheet
6. Consolidating Data
Prepare worksheet as given below and do as directed:
1. Add two worksheets in the file and modify the data for all 4 quarters.
2. Rename all worksheets like sheet1 – 2018, sheet2 – 2019 and sheet3 – 2020.
3. Now add one more worksheet at the end and rename it as a consolidated sheet.
4. Now type the serial no and names as displayed, and use the sum function to add data for
2018, 2019 and 2020 in respective cells using consolidation.
Data Consolidation and Hyperlink
1. Insert a new worksheet and rename as “Student Report“.
2. Create different references from the Student Profile and Marks to consolidate the result.
3. Move the worksheet to the end of the workbook sheet tab.
4. Insert a new worksheet at the beginning.
5. Create a hyperlink to move to a particular worksheet from the newly inserted worksheet.
6. Delete hyperlink for the consolidated worksheet.
7. Subtotal
Prepare the following worksheet and display the sum of items according to items and then regions.
Data for Subtotal
Your output should be like this:
Subtotals output
10. Goal Seek
Nitika is planning her goals about the marks she should attain in the forthcoming Semester 4
examinations in order to achieve a distinction (75%). Assuming that the examination of each subject
is for 100 marks, her marks of the previous semesters are given as under. (Use GOAL SEEK in
OpenOffice Calc)
Find out how many marks should she obtain in 4th semester to secure distinction.
