Page 375 - Trackpad IT-402_Class-IX
P. 375
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
After creating the above worksheet, perform the following actions.
(a) Find the Absolute value of data present in cell D1.
(b) Find the Square root of data present in cell B2.
(c) 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 Autofill 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 (SALE) 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.
Create a worksheet in ‘Calc’ for the following data and find the selling price with the help of the formula
(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
Dining Table 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 Basic Pay Basic Pay
Pay 20% of
Basic Pay
After creating the above worksheet, perform the following actions:
• Enter data for 10 persons.
• Align the data item in the center of a Cell.
• Total Pay = BASIC PAY+HRA+TA+DA
• NetPay = TotalPay-TAX
• Heading ABC CORPORATION should be in Bold, at the center of the cell and must be underlined.
• Using the Name and Basic Pay, draw a Line, Bar, Pie and Column Chart.
• Add a filter to the above data and view the selected rows based on different criteria.
Practical Work 375

