Page 194 - Trackpad 402_Class-X_Final
P. 194

Step 12:   Click on OK button. You will see the consolidated marks in the Final Result - Final Result Generated in the
                 cells B4:B9. Now you can use this to generate the percentage of each child in the percentage column.























        In the above case if any value is changed in source data (Weekly marks, halfyearly or final marks) then the marks in the
        final result generated will be automatically updated. Try this by changing the marks of Amita in half yearly from 91 to
        95. Did you see any change in the final result generated for Amita?



                                1.  Give the formula for calculating the percentage of Amita in the above worksheet. Also
                                  give the steps to copy the same formula for calculating the percentage of the rest of the
                                  students in the worksheet.
                                2.  Which tool will be used to combine and find the sum/average of marks obtained by the
                                  students. Also give the steps to do so.
                 uiz Bee        3.   In the above case if any value is changed in source data then the marks in the final result
                                  generated will be automatically updated. Try this by changing the marks of Amita in half
                                  yearly from 91 to 95. Did you see any change in the final result generated for Amita?




                CREATING SUBTOTALS

        Groupwise calculation of sum, average, max, min, count, etc. can be done by using the Subtotals option of OpenOffice Calc.
        Let us take an example of counting the strength classwise using subtotal as shown in the given worksheet:






























          194   Trackpad Information Technology-X
   189   190   191   192   193   194   195   196   197   198   199