Amrita Vishwa Vidyapeetham 2007 Post Graduate Diploma Computer Application PGDCA(NS) Office Automation PCA6101 - Question Paper

PGDCA(NS) Office Automation PCA6101 May 2007
Time : 3 hours Maximum : 100 marks
ans any 5 ques..
All ques. carry equal marks.
1. Illustrate the creation of a document using Ms-Word. (20)
2. Describe the subsequent :
(a) Creation and formatting of tables. (10)
(b) Text alignment, Font selection, inserting page numbers. (10)
3. Discuss the features of Ms-Excel. (20)
4. (a) How do you create a chart using Ms-Excel? (10)
(b) Explain the steps to include the created chart in a word document. (10)
5. (a) Explain the process of inserting, moving and resizing a picture in a word document. (10)
(b) Explain the process of adding and removing rows and columns in a work sheet. (10)
6. Explain the subsequent.
(a) Finding records in a database. (5)
(b) Sorting records in a database. (5)
(c) Creating, saving and editing a query using Ms-Access. (10)
7. Explain the process of creating a power-point presentation. (20)
8. Write short notes on :
(a) Out look. (10)
(b) Creating an access report from an excel list.

Earning:   Approval pending.