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
   344   345   346   347   348   349   350   351   352   353   354