Page 374 - Trackpad IT-402_Class-IX
P. 374

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


             After creating the above worksheet, find the sum of the range of Qtr1, Qtr2, Qtr3, and Qtr4 in cells B7, C7, D7, and E7
             respectively.
          6.  Using Mail Merge, add the data file of the relatives in a separate file in the given format named ‘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.  Create a poster on the “Reduce, Recycle, Reuse” topic using the features learnt in the OpenOffice
            document.

            • Save the document as ‘RRR_Poster’ and close the document.
            •  Open the document ‘RRR_Poster’ & record the changes.
          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


            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’.


          374   Trackpad Information Technology-IX
   369   370   371   372   373   374   375   376   377   378   379