Post Graduate Diploma Computer Application ALAGAPPA UNIVERSITY - DISTANCE EDUCATION P.G.D.C.A. EXAMINATION, MAY 2010. Non - Semester OFFICE AUTOMATION Question paper

OFFICE AUTOMATION (2000 onwards)

Time : Three hours
Maximum : 100 marks

Answer any FIVE questions.
All questions carry equal marks.

1. (a) Explain the window components of a word document.
(b) Discuss the various types of saving a document in word.

2. (a) Explain the procedure for cut, copy and paste commands in M.S. word.
(b) Discuss about creating table using MS word.

3. (a) How to add and remove rows and columns in excel worksheet?
(b) What are the various logical functions in Excel?

4. (a) How is a formula invoked in Excel?
(b) How do you improve the appearance of worksheet?

5. (a) Discuss the various field properties in Access.
(b) How do you sort data in access?

6. (a) Write the procedure for adding. Inserting and deleting records in access.
(b) How do you create, save and editing query?

7. (a) Explain the steps involved in creating powerpoint presentation.
(b) Explain how an access table merged with word letter.

8. (a) How do you create a word hand out from a power point presentation?
(b) Explain the utility of menus and dialog boxes in power point.