Page 323 - IT_Play_V1.0 Class9
P. 323
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
Also, perform the following tasks:
• Find the sum of the range Qtr1 in the cell B7.
• Also, find the sum of the other ranges Qtr2, Qtr3, Qtr4 in cells C7, D7 and E7 respectively.
6. Perform the following tasks using Mail Merge:
Add the data file of the relatives in a separate file in the given format named as ‘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. Type the following paragraph in LibreOffice Writer:
India is known for its rich cultural heritage and diverse traditions. The country is famous for its festivals,
arts, and crafts. Additionally, India has made significant advancements in science, technology, and
education.
Also, perform the following tasks:
• Create a bulleted list for the following items after the paragraph:
Festivals
Arts and Crafts
Science and Technology
Education
• Save the document with the name ‘India’s Heritage’.
• Convert the bulleted list into a numbered list.
• Bold the text in the list to emphasise the key points.
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
Practical Work 321

