Page 239 - CA_165_V2.0_C9_Flipbook
P. 239
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 it.
Open the document Maths Model Paper and 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 the current date and time in cell A7
Save the workbook as Report Card
6. Create a worksheet with the following data:
i. Find the absolute value of data present in cell D1
ii. Find the 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 three 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 237

