Page 224 - CA 165 ver 1.0 Class 9
P. 224
9. Create a worksheet in ‘Calc’ for the following data:
ABC Corporation
Name Designation Basic Pay HRA TA DA Tax Total Pay Net Pay
Samar Manager 10000 30% 5% of 40% of 20%
of Basic Basic Pay of
Basic Pay 20% of Basic
Pay Basic Pay Pay
Enter data for 10 persons.
Align the data item in the center of a Cell.
Use the formula ‘Total Pay = Basic Pay + HRA + TA + DA’ to calculate the Total Pay.
Use the formula ‘Net Pay = Total Pay - Tax’ to calculate the Net Pay.
Heading ABC Corporation should be Bold, Center of a Cell and must be underlined.
Using the Name and Basic Pay draw a Line, Bar, Pie and Column Chart.
Add filter to the above data and view selected rows based on different criteria.
10. Electricity Consumption Year 2014–15:
Railway Traction Industrial Agricultural Commercial Domestic Others
22.2% 31.4% 24.9% 3.6% 15.6% 2.1%
Draw a Pie Chart and Column Chart for the above data.
11. The table below shows marks obtained by 50 students in Computer Class Test. Draw a Column Chart
(graph) based on the table.
Marks 3 4 5 6 7 8 9 10
No.of Students 1 3 4 8 12 10 9 3
12. For the following data, draw a Pie Chart.
Items Rent Food Cloth Education Misc
Expenses in% 15% 35% 10% 20% 20%
13. Create a presentation titled “Which has greater environmental destructive potential, Mankind or
Nature?” Provide at least one slide for the following:
The Risks Mega Tsunami
Earthquake Hurricanes
Soil Degradation Man-made Global Warming
Nuclear Bomb Conclusion
For each of the above slides, select suitable layout for the slides. Insert Header and Footer and set the
background colour as green.
14. Create an Impress presentation titled “Classical Dance forms of India”. Create atleast any one slide for
the following:
i. Place of origin ii. History
iii. Speciality iv. Costumes
Also provide relevant images for each of the above.
222 Touchpad Computer Applications-IX

