Page 380 - TP_IT_V1.0_C9_flipbpookl
P. 380

5.  Create a sheet 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 sheet, 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 LibreOffice
                  document.
                  • Save the document as ‘RRR_Poster’ and close the document.

                  •   Open the document ‘RRR_Poster’ , add two more R as Repurpose and Refuse & record the
                    changes.
                8.  Create a sheet 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


                  Create the above table in Calc and calculate the following by adding new rows or columns:
                  •   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’.


                378   Trackpad Information Technology (Ver. 1.0)-IX
   375   376   377   378   379   380   381   382   383   384   385