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

