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

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

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

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 – Creating cell referencing in Spreadsheet

Assignment 3

Objective:

Link data and Spreadsheet

Task:

Prepare a worksheets as following:

1. Enter the data such as Roll no, GR NO, First Name, Last Name, Date of Birth, Father Name, Mother Name. Enter records for at least 10 students.
2. Rename this worksheet as “Student Profile”.
3. Insert 3 new worksheets and rename as “PT2“, “PT2” and “PT3” respectively.
4. In the PT1 worksheet create a reference for Roll No, First Name, and Last Name columns from Student Profile by using the keyboard.
5. In the PT2 worksheet create a reference for Roll No, First Name, and Last Name columns from Student Profile by using the mouse.
6. In the PT3 worksheet create a reference for Roll No, First Name, and Last Name columns from Student Profile as you wish.

Solution:

1. Open Excel and create a new workbook.
2. In the first worksheet, enter the data.
3. Right-click on the sheet tab (usually named “Sheet1”).
4. Select “Rename” and change the name to “Student Profile”.
5. Insert three new worksheets by clicking the “+” icon at the bottom.
6. Rename them to “PT1”, “PT2”, and “PT3” respectively.
7. Go to the “PT1” worksheet.
8. In cell A1, type =Student Profile!A1 to reference the Roll No from the “Student Profile” sheet.
9. Drag the fill handle to copy the formula down for all 10 students.
10. Repeat the process for First Name and Last Name columns.
11. Go to the “PT2” worksheet.
12. Click on cell A1, type =, then navigate to the “Student Profile” sheet and click on cell A1.
13. Press Enter to create the reference.
14. Drag the fill handle to copy the formula down for all 10 students.
15. Repeat the process for First Name and Last Name columns.
16. Go to the “PT3” worksheet.
17. You can use either the keyboard or mouse method to create references for Roll No, First Name, and Last Name columns from the “Student Profile” sheet.

Output:

Thanks to Beloved Readers.