Page 381 - TP_IT_V1.0_C9_flipbpookl
P. 381
9. Create a Sheet 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 sheet, 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 sheet to display the yearly attendance report of an Employee. Create 3 columns namely ‘Months’, ‘Number of days’
and ‘Employee 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 sheet in ‘Calc’ for the following data and find the selling price with the help of the formula
(Selling Price = Original Price – Discount).
ITEM NAME ORIGINAL PRICE DISCOUNT% SELLING PRICE
Table 2900 10
Chair 2500 8
Chair Fibre 1000 9
Bed 4000 12
Dining Table 7000 15
Sofa 6000 12
Table Round 8000 12
12. Create a sheet 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 sheet, perform the following actions:
• Enter data for 10 people.
• Align the data item in the center of the Cell.
• Total Pay = BASIC PAY+HRA+TA+DA
• NetPay = TotalPay-TAX
• Heading ABC CORPORATION should be in Bold, in 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 379

