Page 315 - IT_V1.0_Class10
P. 315
10. You and your classmates are working on a group project using a shared spreadsheet.
• Set up a shared spreadsheet for collaborative editing among classmates.
• Practice adding, editing, and formatting comments to enhance communication and clarity within the
spreadsheet.
• Learn to manage changes effectively by reviewing and either accepting or rejecting them.
11. Create a table Product in Design View:
ProductID ProductName Category Price
1 Laptop Electronics 80000
2 Tablet Electronics 30000
3 Chair Furniture 15000
4 Desk Furniture 25000
5 Smartphone Electronics 50000
Tasks:
• Sort the Product table by Price in descending order.
• Use a wildcard to create a query that retrieves all products where the ProductName starts with the
letter T.
• Generate a report based on the Product table.
• Format the report to show products in ascending order of ProductID.
• Add the page number in the footer of the report.
12. You are tasked with organising student marks data in a spreadsheet and automating the calculation of
total marks using a macro named “TotalMarks”.
• Set up a spreadsheet with three columns: “Student Name” in column A, “Subject” in column B, and
“Marks Obtained” in column C. Ensure data starts from row 2.
• Develop a macro named “TotalMarks” that iterates through each row of the spreadsheet (starting from
row 2) to calculate the total marks obtained by each student.
• For each student, sum up the marks obtained from all subjects listed.
• Display the total marks for each student in column D, starting from row 2.
• Execute the macro to automatically calculate and populate the total marks for each student based on
the data provided in the spreadsheet.
13. You have received two versions of a financial report from different teams. You need to identify
discrepancies and reconcile the differences between the two sheets. How would you do this task in
LibreOffice Calc?
14. Create the following table using the ‘Design View’.
Date of Marks
Reg No. Name Grade
Submission Obtained
T/121/15 Anshu Verma 11/07/15 18 A
T/137/15 Anjali Kumari 12/07/15 20 A+
T/145/15 Deepak Kohli 14/07/15 17 B+
• Name the table as ‘Marks Distribution’.
• Enter atleast 3 records.
• Sort the data on the basis of grades.
Practical Work 313

