Illustrate the main parts and functions of a computer.

Discuss the commands for applying the following formatting concepts to the document:
i) Find and replace 
ii) Creating columns
iii)View magnification
iv)Format painter

Briefly describe the internet tools and discuss how to use the internet.

Create a MS Power point presentation on any topic of your interest, consisting of about 10-12 slides. Also write steps to perform following activities and prepare a CD for presentation and submit along with the assignment. It should involve all the following activities: 
i. It should have a master slide with a title
ii. Insert header and footer in all slides except master
iii. Show some data using a chart or graph
iv. Include smart art in of the slides
v. Insert picture in one of the slides
vi. Also, insert a video clip related to the topic at the end of the presentation

What is software and hardware troubleshooting? Suggest various measures to solve or prevent problems related to computer software and hardware.

What is mail merge? Write down the basic steps involved in Mail Merge? How do you
merge the main document and the data file in mail merge?

Suppose you are a manager of a school canteen. Create a worksheet using excel maintaining the monthly expenses of the canteen under various heads, for a year. Your assignment should contain the following: 
i. Make an account of purchases of fruits and vegetables
ii. You must find average expense per month
iii. Automatically find the month when a minimum amount was spent
iv. Create a chart for head wise expenditure per month
v. Use formulas to find sum and average