Page 223 - CA 165 ver 1.0 Class 9
P. 223
4. Create a new document and type the Model Question paper of Mathematics from the mathematics
textbook. Use some mathematical expressions in the document.
Save the document as ‘Maths Model Paper’ and close the document.
Open the document ‘Maths Model Paper’ & record the changes.
5. Create a Worksheet with following headings and data:
A B C D E G
S.No. Name of the Student Maths Sci. S.St Eng. Hindi
1 Aniket Kumar 91 95 92 75 84
2 Abhijit Kundu 94 87 69 78 81
3 Arun Kumar 85 85 79 85 88
4 Sanjay Jain 96 91 94 88 72
5 Vikash Gupta 78 88 82 65 70
Calculate the following:
Total Marks obtained by each student
Maximum Marks obtained in Maths
Average Marks scored in Hindi
Insert current date and time in A7 cell
Save the workbook by name ‘Report Card’
6. Create a Worksheet with following data:
i. Find Absolute value of data present in cell D1
ii. Find Square root of data present in cell B2
iii. Find the Rounded value of data present in cell D2 without any decimal digit
A B C D E
1 11.2 22.5 32 14.5 20
2 21 58 46 12.5 31
3 26 54 74 2 56
7. Create a worksheet to display yearly attendance report of an Employee. Create 3 columns namely
‘Months’, ‘Number of days’ and ‘Employee A is present’. Use Autofill feature to fill the Months i.e. from
January to December in separate rows from A2 to A13.
8. Sushmita Furniture has offered discount (SALE) on its products. The percent of discount is different
for each item. Make a price list which shows original price, discount percent and selling price.
Selling Price=Original Price-Discount Price
Item Name Original Price Discount% Selling Price
Table 2900 10
Chair 2500 8
Chair Fibre 1000 9
Bed (Single) 4000 12
Bed (Single) 7000 15
Sofa 6000 12
Table Round 8000 12
Practical Work 221

