Page 175 - IT 402 v2.0 class 10
P. 175

5


                                                                                              6








                                                                                              7



            Step 6:   Set desired  imiting  ondition.  ere  we have set the rule that the marks of  omputer sub ect must
                    be greater than marks of Science sub ect.
            Step 7:    lick on  Solve  button.  Solving  esult  dialog box appears.

            Step 8:   lick on   eep  esult  button to keep the updated values in the cell.
















                                       8



              Sneak Peek




                   To use ‘Solver’ in Microsoft Excel:
                    .   lick on the  File  tab and then click on  Options .
                    .   nder  dd-ins  select  Solver  dd-in .
                    .  Select   xcel  dd-ins  and click on the   o  button.

                    .   lick on  O   button.
                   5.  Now  find the Solver on the   ata  tab in the   nalysis  command group.
                    .   lick on  Solver  command.
                    .   lick on  Solve  button.







                                                                       Advanced Features of Spreadsheet        173
   170   171   172   173   174   175   176   177   178   179   180