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

