Page 154 - IT_V1.0_Class10
P. 154

Step 7:  Click on the Column input cell field of the Multiple Operations dialog box,
              Step 8:  Select cell B4, as it contains the variable value in the formula, here it is Quantity Sold in a Year.
              Step 9:  Click on OK button.







                                                                                                   8

                                 6



                                                                                                   5


                                                                                                   7
                                                                                                   9


                     The profits for the different quantities are now visible in column ‘E’.













                      If you change the values in column D, i.e., Annual Sales Figure, then the Profit in column E will be
                     automatically updated.















                                                                                                  21 st
                                                Lab Assignment ‘n Activity                     Century   #Technology Literacy
                                                                                                 Skills


                   Complete the following activities and tick the circle.
                      Mr. Laksh is preparing a list of  class with 30 students. He enters marks for five different
                      subjects. Group the students by subject and calculate the subtotals for each subject.
                      Analyse different scenarios of monthly expenses for a household. Consider three scenarios:
                      Minimum Expense, Average Expense, and Maximum Expense for categories such as Rent,
                      Groceries, Utilities, and Miscellaneous.

                      A store sells three different products (Product X, Product Y, Product Z) with different selling prices and
                      costs. Calculate the monthly profit using multiple operations, considering different sales volumes.




                152     Information Technology Play (Ver 1.0)-X
   149   150   151   152   153   154   155   156   157   158   159