Page 324 - IT_Play_V1.0 Class9
P. 324

Calculate the following:
                  •    Total Marks obtained by each student.           •  Maximum Marks obtained in Maths.
                  •  Average Marks scored in Hindi.                    •  Insert the current date and time in the A7 cell.
                  •  Save the workbook by the name ‘Report Card’.

               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
                  Now, perform the following steps:

                  •  Find the Absolute value of data present in cell D1.
                  •  Find the Square root of data present in cell B2.
                  •  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 Auto Fill 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 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.
                 Hint: 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 Pay Basic Pay Basic Pay Basic Pay

                 Hint: Total Pay = BASIC PAY+HRA+TA+DA
                  NetPay = TotalPay-TAX

                  Now, perform the following tasks:
                  •  Enter data for 10 persons.
                  •  Align the data item in the center of a cell.

                  •  Calculate the total salary and net payable salary.
                  •  Using the Name and Basic Pay, draw a Line, Bar, Pie and Column chart.
                  •  Add filter to the above data and view the selected rows based on different criteria.



                322     Information Technology Play (Ver 1.0)-IX
   319   320   321   322   323   324   325   326   327   328   329