Page 153 - IT_V1.0_Class10
P. 153

To use the Multiple Operations tool, you need two arrays of cells:
                   The first array contains the original or default values and the formulas applied to them. The formulas must
                   be in a range.
                   The second array is the formula array. It is created by entering variables which are alternative values for one
                   or two original values.

                 For example, ‘ABC’ Publisher publishes a book whose selling price is ` 100 (cell B1), manufacturing cost of
                 each book is ` 35 (cell B2), in addition to the fixed cost of ` 50,000 per year (cell B3).
                 We can calculate profit made by the publisher in a year if they sell 2000 books and profit for different sales
                 of quantities that are 1500, 2000, 2500, 3000, 3500 using Multiple Operations.
                 Step 1:  To calculate the profit, enter the formula =B4*(B1-B2)-B3 in cell B5.

                 Step 2:  In column D, enter expected Annual Sale Figure.








                                                                                                             2
                            1


                 Step 3:  Select the range D2:E6. This will select the values in column D and empty cells of column E.
                 Step 4:  Click on Data menu and select Multiple Operations option.

                         The Multiple operations dialog box appears on the screen.
                         Following options are there in the Multiple operations dialog box:
                              Formulas field is used to enter the cell reference to the formula that is applied to the data range.

                            Row input cell is used to enter the reference to the first cell of the range arranged in rows that is
                            part of the formula.
                            Column input cell is used to enter the reference to the first cell of the range arranged in columns
                            that is part of the formula.











                                                                                 3







                                                                                 4






                 Step 5:  Click on the Formulas field of the Multiple Operations dialog box.
                 Step 6:  Select cell B5, as it contains the formula for calculation of profit.


                                                                        Analyse Data using Scenarios and Goal Seek   151
   148   149   150   151   152   153   154   155   156   157   158