Page 201 - Trackpad 402_Class-X_Final
P. 201
Let us now study the steps to understand the concept better:
Step 1: Create a worksheet with the given data:
In the above worksheet we want the overall percentage to reach 95%. To get this desired percentage what
changes in the marks should be done in English, Hindi and Maths.
Step 2: Click on Tools menu and select Solver option. The Solver dialog box will be displayed:
Step 3: Change the values in the solver dialog box as given below:
• Target cell: $C$9
• Optimize result to: Value - 95
• By changing cells: $C$3:$C$5
• Cell reference: $C$3 <= 95
$C$4 <= 95
$C$5 <= 98
Step 4: Click on Solve button. The Solving Result dialog box will be displayed:
Electronic Spreadsheet (Advanced) 201

