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
   370   371   372   373   374   375   376   377   378   379   380