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

GOAL SEEK

         oal Seek feature is an important part of  hat-if  nalysis feature of spreadsheet.  oal Seek is basically used
        when our output or target value is fixed and we have to make a change in any one of the input cell values.
         oal Seek option reverses the usual order of a formula.  hile creating a formula or function in spreadsheet
        we use various parts together to calculate a result.  oal Seek works in the reverse way. It starts with the
        desired result and it calculates the input value accordingly.  et s discuss about the various components of the
          oal Seek  window:
        Formula Cell

        In the formula cell  we can enter the reference of the cell which contains the formula. It contains the current cell
        reference.  e can click another cell in the sheet to apply its reference to the text box.

        Target Value
        It specifies the value you want to achieve as a new result.

        Variable Cell

        It specifies the reference for the cell that contains the value you want to ad ust in order to reach the target.

        Shrink/Maximize
         e can click the  Shrink  icon to reduce the dialog box to the si e of the input field. It is then easier to mark
        the re uired reference in the sheet.  he icon is then automatically converted to the  Maximi e  icon.  licking
        it restores the dialog box to its original si e.  he dialog box is automatically minimised when you click on the
        sheet with the mouse.  s soon as you release the mouse button  the dialog box is restored and the reference
        range is highlighted in the document by a blue frame using mouse.

         et s take an example where a student is currently scoring   .5  aggregate and needs at least     to  ualify
        for yearly scholarship. Fortunately  he has a chance to use his  omputer sub ect s score to raise the aggregate.
         ere   oal Seek can be used to estimate at least how much marks are to be scored in  omputer sub ect for
        availing that scholarship.
        Step 1:  Click on ‘Tools’ menu.

        Step 2:  Select   oal Seek  option.  oal Seek  dialog box appears on the screen.





                                                                             1




                                                                          2


                         Place the
                        cursor in the
                        formula cell
                         (i.e. 'B8').









         170       Touchpad Information Technology-X
   167   168   169   170   171   172   173   174   175   176   177