Page 348 - open office
P. 348

5.  Create a worksheet as shown below:
                               A                  B                   C                  D                  E

                     1.                                       Quartely 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

                  •  Find the sum of the range Qtr1 in the cell B7.

                  •  Also, find the sum of the other ranges  tr2,  tr3,  tr4 in cells C , D  and E  respectively.
                6.  Using Mail Merge, add the data file of the relatives in a separate file in the given format named as  Relative  ist .

                                S. No                            Name                             Address




                  •  Create a document and type an invitation letter for marriage anniversary of your parents and save it with the
                    name  Invitation .
                  •  Mail Merge  Relative  ist  as the recipient and  Invitation  as the main document.
                  •  Merge the document  Invitation  to a  ew Document.

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

                 .  Create a Worksheet with 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 current date and time in A7 cell.

                  •  Save the workbook by name  Report Card .







               348      Touchpad Information Technology-I
   343   344   345   346   347   348   349   350   351   352   353