Page 223 - CA 165 ver 1.0 Class 9
P. 223

4.   Create a new document and type the Model Question paper of Mathematics from the mathematics
                     textbook. Use some mathematical expressions in the document.

                         Save the document as ‘Maths Model Paper’ and close the document.
                         Open the document ‘Maths Model Paper’ & record the changes.
                 5.  Create a Worksheet with following headings and data:

                                        A                B         C          D            E             G
                      S.No.   Name of the Student     Maths       Sci.       S.St        Eng.          Hindi
                        1         Aniket Kumar          91        95         92           75             84

                        2         Abhijit Kundu         94        87         69           78             81
                        3          Arun Kumar           85        85         79           85             88

                        4           Sanjay Jain         96        91         94           88             72
                        5         Vikash Gupta          78        88         82           65             70

                     Calculate the following:
                         Total Marks obtained by each student
                         Maximum Marks obtained in Maths
                         Average Marks scored in Hindi
                         Insert current date and time in A7 cell
                         Save the workbook by name ‘Report Card’
                 6.  Create a Worksheet with following data:
                     i.   Find Absolute value of data present in cell D1
                     ii.  Find Square root of data present in cell B2

                     iii.  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
                 7.   Create a worksheet to display yearly attendance report of an Employee. Create 3 columns namely
                     ‘Months’, ‘Number of days’ and ‘Employee A is present’. Use Autofill feature to fill the Months i.e. from
                     January to December in separate rows from A2 to A13.
                 8.   Sushmita Furniture has offered discount (SALE) on its products. The percent of discount is different
                     for each item. Make a price list  which shows original price,  discount percent and selling  price.
                     Selling Price=Original Price-Discount Price
                           Item Name             Original Price           Discount%             Selling Price

                      Table                          2900                     10
                      Chair                          2500                      8
                      Chair Fibre                    1000                      9
                      Bed (Single)                   4000                     12
                      Bed (Single)                   7000                     15
                      Sofa                           6000                     12
                      Table Round                    8000                     12


                                                                                               Practical Work    221
   218   219   220   221   222   223   224   225   226   227   228