Page 384 - Computer Software Application TP - Volume 1
P. 384

COMPUTER SOFTWARE APPLICATION - CITS



           Step 2:
              •  Select cell E8 as the objective cell / Set Target Cell of the Solver Parameter box.
              •  Besides the To: options select Max as we are trying the maximize the value of the cell.





















           Step 3:
              •  In the By Changing Variable Cells, select the cell values we are mainly focusing on changing. Here, they
                 belong to the range C5:C7.




















           Step 4:
              •  Now add the constraints by clicking on the Add button on the right of the box.

































                                                           369
 CITS : IT & ITES - Computer Software Application - Exercise 65  CITS : IT & ITES - Computer Software Application - Exercise 65
   379   380   381   382   383   384   385   386   387   388   389