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

