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

Step 3:   he cell address containing the formula is already entered in a  Formula cell  field.

            Step 4:   nter the desired result  i.e.      .



                                   3
                                   4

                                   5



            Step 5:    lace the cursor in the   ariable cell  field. In the sheet  click in the cell that contains the value to be
                    changed. In this example       is the cell.
            Step 6:   lick on  O   button.

            Step 7:   lick on   es  button.

            Step 8:   stimated marks of  omputer sub ect is   5  to get       aggregate.



                                                                              6








                                          7



                                                 8




             Sneak Peek




                    Using Goal Seek in Microsoft Excel:

                    1.  Select the cell that contains a formula.
                     .   lick on   ata  tab and then click   hat-If  nalysis  command from   ata  ools  command
                      group. Select   oal Seek  option from the drop-down menu.
                     .    dialog box will appear with three fields:
                          Set cell:  his is the cell that contains the desired result.
                           o value:  his is the desired result.
                           y changing cell:  his is the cell where  oal Seek places its answer.
                     .  Set appropriate values and then click on  O   button.
                    5.    dialog box appears on the screen informing whether   oal Seek  was able to find a solu-
                      tion.  lick on  O   button.
                     .   he result will appear in the specified cell.






                                                                       Advanced Features of Spreadsheet        171
   168   169   170   171   172   173   174   175   176   177   178