Page 223 - TP_IT_V1.0_C10_flipbpookl
P. 223
To conduct an analysis with one input variable, perform the following steps:
Step 1: Enter data in a sheet that is used to calculate the monthly profit or loss be affected by the number of
sandwiches sold.
Step 2: Click on the cell B6 and type the =B7*(B4-B5)-B6 formula to calculate the profit or loss.
Step 3: Press the Enter key. The output of the formula is displayed in cell B6.
Step 4: Enter input values for rows and columns on the basis of which the output is to be generated using the formula.
Step 5: Select the cell range for input values and output values.
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 Row input cell text box and select the cell in the sheet which is a variable for row inputs 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 in the Column input cell text box and select the cell in the sheet which is a variable for column inputs
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 10: Click on the OK button.
Now, the profit or loss value for the output array range automatically fills according to the input values.
Electronic Spreadsheet (Advanced) using LibreOffice Calc 221

