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

