Page 349 - open office
P. 349
. Create a Worksheet with the following data:
(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.
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
10. Create a worksheet to display the yearly attendance report of an Employee. Create 3 columns namely Months ,
umber of days and Employee A is present . Use the Autofill feature to fill the Months i.e. from anuary to December
in separate rows from A2 to A13.
11. Sushmita Furniture has offered discount (SA E) on its products. The percent of discount is different for each item.
Make a price list that shows original price, discount percent and selling price. 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 Basic Basic Pay Basic
Pay Pay 20% of Pay
Basic Pay
• Enter data for 10 persons.
• Align the data item in the center of a Cell.
• Total Pay BASIC PA HRA TA DA
• etPay TotalPay-TA
• Heading ABC CORPORATIO should be in Bold, at the center of the cell and must be underlined.
• Using the ame and Basic Pay, draw a ine, Bar, Pie and Column Chart.
• Add filter to the above data and view the selected rows based on different criteria.
Practical Work 349

