Page 175 - IT 402 v2.0 class 10
P. 175
5
6
7
Step 6: Set desired imiting ondition. ere we have set the rule that the marks of omputer sub ect must
be greater than marks of Science sub ect.
Step 7: lick on Solve button. Solving esult dialog box appears.
Step 8: lick on eep esult button to keep the updated values in the cell.
8
Sneak Peek
To use ‘Solver’ in Microsoft Excel:
. lick on the File tab and then click on Options .
. nder dd-ins select Solver dd-in .
. Select xcel dd-ins and click on the o button.
. lick on O button.
5. Now find the Solver on the ata tab in the nalysis command group.
. lick on Solver command.
. lick on Solve button.
Advanced Features of Spreadsheet 173

