Page 171 - IT 402 v2.0 class 10
P. 171

Step 5:   Multiple operations  dialog box appears on the screen.  lick on the  Formulas  field of the  Multiple
                    operations  dialog box  then click the cell   5 .  his means that cell  5 contains the result  i.e.  the
                    formula for calculation of result.

            Step 6:   lace the cursor in the   olumn input cell  field and click cell     .  his means that content of cell
                    is variable in the formula.

            Step 7:   lick on ok button.




                                                                                                  7









             he profits for the different  uantities are now visible in column    .
























                                              Lab Assignment ‘n Activity                             I nte r - D is cip l inar y




                 Complete the following activities and tick on the circle.
                     reate a student s plan to score greater than     aggregate marks  in five different sub ects
                   if he has secured  5             in four different sub ects  Sub ect    Sub ect    Sub ect
                   Sub ect    respectively .
                     alculate  using   Scenario    how  much  he  needs  to  secure  marks  in  Sub ect     to  get
                   above-mentioned aggregate marks.

                      sing multiple operations  find the profit obtained by the seller in a month     days  if he
                   daily sells 5   masks whose selling price is ` 100.
                   Note:
                       Manufacturing Cost of each Mask is ` 35.
                       Fixed cost for a year is ` 12000.







                                                                       Advanced Features of Spreadsheet        169
   166   167   168   169   170   171   172   173   174   175   176