Class 10 IT Practical File on Electronic Spreadsheet 2024-25 (Assignment 2)

In this article we providing information regarding latest Class 10 IT Practical File on Electronic Spreadsheet 2024-25 (Assignment 2)

Class 10 IT Practical File on Electronic Spreadsheet 2024-25 (Assignment 2)

In your Upcoming CBSE Board Exam – On Internal Marks is 50.

Based On CBSE Curriculum-

So we are discuss one by one Practical’s Be Connected.

Unit 2: Electronic Spreadsheet (Advanced)

Learning Outcome Subtotal

Assignment 2

Objective:

Applying subtotal in LibreOffice Calc

Task:

Prepare a worksheet as following

Apply subtotal and find the sum of days required for project name.

Solution:

1. Open spreadsheet software and enter the data.
2. Select the data.
3. Click on Data → Subtotal. The Subtotal dialog box appears.
4. Select column Project Name in Group By option.
5. Now mark the column to Days Required to count the no. of days required for each project.
6. Select the sum function sum from Use Function option.
7. Click on OK button.

Output:

Thanks to Beloved Readers.