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
   218   219   220   221   222   223   224   225   226   227   228