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

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

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

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 – Goal Seek

Assignment 5

Objective:

Goal seek Application

Task:

Enter data to obtain marks of Rohan and set the goal to achieve total average 71.5  by changing the marks obtained by Vedant.

Sample Data:

Solution:

1. Enter data and prepare the spreadsheet along with formula.
2. Place the cursor in C7 cell.
3. Click on Tools > Goal Seek option. The Goal Seek dialog box will appear.
4. Move the cursor in Target Value box and enter the value –71.5.
5. Now select the cell as a variable cell.
6. Click on OK.
7. It will display the value obtained by Goal seek. If you wish to insert it in the spreadsheet click on Yes, otherwise No.

Output:

Thanks to Beloved Readers.