Page 324 - IT_Play_V1.0 Class9
P. 324
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 the A7 cell.
• Save the workbook by the name ‘Report Card’.
9. Create a Worksheet with the following data:
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
Now, perform the following steps:
• Find the Absolute value of data present in cell D1.
• Find the Square root of data present in cell B2.
• Find the Rounded value of data present in cell D2 without any decimal digit.
10. Create a worksheet to display the yearly attendance report of an Employee. Create 3 columns namely
‘Months’, ‘Number of days’ and ‘Employee A is present’. Use the Auto Fill feature to fill the Months i.e.
from January to December in separate rows from A2 to A13.
11. Sushmita Furniture has offered a discount on its products. The percent of discount is different for each
item. Make a price list that shows the original price, discount percent and selling price.
Hint: Selling Price=Original Price-Discount Price
ITEM NAME ORIGINAL PRICE DISCOUNT% SELLING PRICE
Table (4) 2900 10
Chair (6) 2500 8
Chair Fibre 1000 9
Bed (Single) 4000 12
Bed (Single) 7000 15
Sofa 6000 12
Table Round 8000 12
12. Create a worksheet in ‘Calc’ for the following data:
ABC CORPORATION
NAME DESIGNATION BASIC PAY HRA TA DA TAX TOTAL NET PAY
Samar Manager 10000 30% of 5% of 40% of 20% of
Basic Pay Basic Pay Basic Pay Basic Pay
Hint: Total Pay = BASIC PAY+HRA+TA+DA
NetPay = TotalPay-TAX
Now, perform the following tasks:
• Enter data for 10 persons.
• Align the data item in the center of a cell.
• Calculate the total salary and net payable salary.
• Using the Name and Basic Pay, draw a Line, Bar, Pie and Column chart.
• Add filter to the above data and view the selected rows based on different criteria.
322 Information Technology Play (Ver 1.0)-IX

