Page 238 - Trackpad 402_Class-X_Final
P. 238

5.  Now, find the Solver on the ‘Data’ tab in the ‘Analysis’ command group.
                 6.  Click on ‘Solver’ command.
                 7.  Click on ‘Solve’ button.





































            V   Creating Cell Reference to Other Worksheet in Microsoft Excel:
                 1.  Reference to an Individual Cell:
                    Syntax:      Sheet_name!Cell_address

                    Example:     To refer to cell A1 in Sheet2, type ‘Sheet2!A1’























                 2.  Reference to a Range of Cells:

                    Syntax:   Sheet_name!First_cell:Last_cell
                    Example:  To refer to cells ‘A1:A10’ in Sheet2, type ‘Sheet2!A1:A10’





          238   Trackpad Information Technology-X
   233   234   235   236   237   238   239   240   241   242   243