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
   196   197   198   199   200   201   202   203   204   205   206