Amrita Vishwa Vidyapeetham 2007 Post Graduate Diploma Computer Application PGDCA Basics Of Automation PCA5103 - Question Paper

PGDCA Basics Of Automation PCA5103 May 2007
Time : 3 hours Maximum : 100 marks
ans any 5 ques..
All ques. carry equal marks.
1. (a) Explain the applications of Windows. (10)
(b) Explain different tool bar elements in detail. (10)
2. (a) Describe how to format your snippet in Ms-Word.
(10)
(b) What is meant by headers and footers? (5)
(c) How to use templates and wizards in Ms-Word? (5)
3. Type your bio-data and mail it to ten various companies to seek a suitable job. Write down the procedures for the above by using mail merge concept. (20)
4. (a) How to insert and delete rows and columns in
MS-Excel? (5)
(b) Explain any 5 mathematical functions available in MS-Excel and provide its uses. (15)
5. (a) Explain different operations to be performed in chart objects. (10)
(b) Discuss how to build an Excel database. (10)
6. (a) Explain how to create and edit your slide contents.
(10)
(b) Describe the steps involved in create graph chart and organization charts. (10)
7. (a) What do you mean by a primary key? discuss its significance. (5)
(b) Explain how to obtain and sort your records in
MS-Access. explain. (10)
(c) Write short notes on queries and its uses. (5)
8. (a) Explain the advantages of Report Wizard. (10)
(b) Discuss how to combine Excel data and charts with Word documents. (10)

Earning:   Approval pending.