Page 237 - Trackpad 402_Class-X_Final
P. 237

5.   A dialog box appears on the screen informing whether ‘Goal Seek’ was able to find a solution. Click
                        on ‘OK’ button.
                     6.  The result will appear in the specified cell.











                IV   To use ‘Solver’ in Microsoft Excel:

                     1.  Click on the ‘File’ tab and then click on ‘Options’.




























                     2.  Under Add-ins, select ‘Solver Add-in’.
                     3.  Select ‘Excel Add-ins’ and click on the ‘Go’ button.



























                     4.  Click on ‘OK’ button.




                                                                                 Electronic Spreadsheet (Advanced)  237
   232   233   234   235   236   237   238   239   240   241   242