Page 166 - Computer - 10(A&B)

Step 2: Click on Tools menu.

Step 3: Select the Solver option. The Solver dialog box appears.

Step 4: Under Optimize result to, select Value of option and specify 80.
Step 5: Select the cells whose values can be changed in the By changing cells field.

Step 6: Set the desired limiting conditions.

Step 7: Click the Solve button. The Solving Result dialog box appears.
Step 8: Click the ‘Keep Result’ button to update the solver solution in the cell.

48