Page 222 - TP_IT_V1.0_C10_flipbpookl
P. 222

Step 6:  Select the Data   Multiple Operations option from the Menu bar.

































              The Multiple operations dialog box opens.

              Step 7:   Click in the Formulas text box and select the cell in the sheet that contains the formula.  The address of the
                      cell is displayed in the Formulas text box.
              Step 8:   Click in the Column input cell text box and select the cell in the sheet which is a variable and is used in the
                      formula based on which the output is measures. The address of the cell is displayed in the Column input cell
                      text box.

              Step 9:  Click on the OK button.













              Now, the profit or loss value for the output array range automatically fills according to the input value.

















              Let us take an example to  conduct an analysis with two input variables. Suppose you run a café where you sell
              sandwiches for `8 each. It costs you `3 to make each sandwich. On top of that, you have fixed monthly expenses of
              `2000. How would your monthly profit or loss be affected by the number of sandwiches sold and the cost price?


                220   Trackpad Information Technology (Ver. 1.0)-X
   217   218   219   220   221   222   223   224   225   226   227