Page 323 - IT_Play_V1.0 Class9
P. 323

5.  Create a worksheet as shown below:
                                  A                 B                    C                 D                   E
                       1.                                      Quarterly Sales Analysis
                       2.     Salesman             Qtr1                Qtr2               Qtr3               Qtr4

                       3.       A001              80009                1895               8653              20008
                       4.       A002              7894                 1876               5476               5482
                       5.       A003              6573                 5438               6935               6542
                       6.       A004              2098                 9834               9673               9653
                       7.       Total

                     Also, perform the following tasks:
                    •  Find the sum of the range Qtr1 in the cell B7.
                    •  Also, find the sum of the other ranges Qtr2, Qtr3, Qtr4 in cells C7, D7 and E7 respectively.
                  6.  Perform the following tasks using Mail Merge:
                     Add the data file of the relatives in a separate file in the given format named as ‘Relative List’.

                                  S. No                             Name                            Address



                    •   Create a document and type an invitation letter for the marriage anniversary of your parents and save
                       it with the name ‘Invitation’.
                    •    Mail Merge ‘Relative List’ as the recipient and ‘Invitation’ as the main document.
                    •  Merge the document ‘Invitation’ to a new document.
                  7.  Type the following paragraph in LibreOffice Writer:
                     India is known for its rich cultural heritage and diverse traditions. The country is famous for its festivals,
                    arts,  and  crafts.  Additionally,  India  has  made  significant  advancements  in  science,  technology,  and
                    education.
                     Also, perform the following tasks:
                    •  Create a bulleted list for the following items after the paragraph:
                         Festivals
                         Arts and Crafts
                         Science and Technology
                         Education
                    •  Save the document with the name ‘India’s Heritage’.

                    •  Convert the bulleted list into a numbered list.
                    •  Bold the text in the list to emphasise the key points.
                  8.  Create a Worksheet with the following headings and data:

                                          A                B          C           D             E               G
                        1.     Name of the Student       Maths       Sci.        S.St          Eng.           Hindi
                        2.     Aniket Kumar                91         95          92            75             84
                        3.     Abhijit Kundu               94         87          69            78             81
                        4.     Arun Kumar                  85         85          79            85             88
                        5.     Sanjay Jain                 96         91          94            88             72
                        6.     Vikash Gupta                78         88          82            65             70



                                                                                                   Practical Work   321
   318   319   320   321   322   323   324   325   326   327   328