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

