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

Lab Assignment ‘n Activity                        S ub j e ct  E nr ich me nt




              Complete the following activities and tick on the circle.
               t the end of the course  a student participates in   exams.  he passing score is  5 .  ll
              the exams have the same weightage  so the overall score is calculated by average of their
              scores.  he student has already given   out of   exams and secured    .  pply   oal Seek

              method to find what score does the student re uire in the third exam to pass the entire
              course.




           SOLVER

        Solver is a more descriptive form of  oal Seek. Solver can deal with e uations having multiple unknown
        variables.  oal Seek is used to manipulate one input cell after the outcome or target is fixed. In Solver  we can
        manipulate a set of cells after knowing the output and can estimate the minimum or maximum value that can
        be entered into those cells. It is specifically designed to minimise or maximise the result according to a set of
        limiting rules defined by the user.  ach of these rules sets up whether an argument in the formula should be
        greater than  lesser than  or e ual to the entered value. If the argument need not to be changed  set the rule
        so that the argument in the cell is e ual to its current entry.

         et us take an example  suppose a student wants to achieve      .  e can change the values of two sub ects
        to achieve the target.  ere  we need to set the limiting condition as marks of  omputer sub ect must be
        greater than the Science sub ect.
        Step 1:   lace the cursor in the formula cell  i.e.      .

        Step 2:  Click on ‘Tools’ menu.

        Step 3:  Select  Solver  option.   Solver  dialog box appears on the screen.


                                                                        2
                                                                                   3















                          1




        Step 4:  Set the result to 80.
        Step 5:  Select the cells whose value can be changed.   ere     and    .





         172       Touchpad Information Technology-X
   169   170   171   172   173   174   175   176   177   178   179