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
   376   377   378   379   380   381   382   383   384   385   386