Page 157 - IT_V1.0_Class10
P. 157
Assume she has scored the given marks:
Subject Marks
English 75
Maths 30
Science 84
Social Science 75
Hindi 30
Computer 0
Percentage 49.00
Now to score 65% marks, she needs to increase her score in Maths, Hindi and Computer. Lets help her, with
the help of solver following the given steps:
Step 1: Select formula cell. Here it is B8 to calculate the percentage of marks.
Step 2: Click on Tools menu.
Step 3: Select the Solver option. The Solver dialog box appears on the screen.
2
3
1
Step 4: In Optimize result to section, select the Value of radio button and set its value to 70.
Step 5: Select the range of cells whose value can be modified in By changing cells text field. (Here, B2 to B7).
Step 6: Set desired Limiting Condition. Here, we have set the rule that the marks of English subject must be
less than 80 and marks of Maths should be integer.
Step 7: Click on Solve button. The Solving Result dialog box appears.
Step 8: Click on Keep Result button to keep the updated values in the cell.
4
5
6
8
7
Analyse Data using Scenarios and Goal Seek 155

