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
   152   153   154   155   156   157   158   159   160   161   162