Amrita Vishwa Vidyapeetham 2007 M.C.A Office Automation Principles And Practice - Question Paper

M.C.A. dec 2007
Office Automation Principles And Practice
Time : 3 hours Maximum : 100 marks
ans any 5 ques..
All ques. carry equal marks.
1. (a) Explain the icons of the subsequent : (10)
Status bar, Title bar, Menu bar and Tool bar.
(b) Explain the subsequent document operations : (10)
Copy, Un delete, Move and obtain.
2. (a) Explain the subsequent picture operations in WORD.
Inserting, Moving and Resizing. (6)
(b) (i) Explain the process of page numbering and indenting in WORD. (7)
(ii) Explain different operations on fonts in WORD.
(7)
3. (a) How you improve the appearance of worksheet by using functions? (4)
(b) (i) How will you format the texts and numbers in EXCEL. (8)
(ii) How will you create and enhance the chart? (8)
4. (a) How will you change the column width in EXCEL?
(6)
(b) Write short notes on the subsequent : Spellchecking in EXCEL and Chart Wizard. (14)
5. (a) How will you create and save a table and also?
How will you create a new database? (15)
(b) How will you change the formats of the fields? (5)
6. (a) Describe the subsequent :
Autoform and printing reports (10)
(b) Explain in detail about query table. (10)
7. (a) Explain the subsequent operations with suitable examples :
Hiding columns, Finding records and sorting records (15)
(b) How will you adjust the column widths? (5)
8. (a) Give any 5 applications of Office Automation. (5)
(b) Develop a power point presentation to discuss about different course offered by your university in details. (15)

Earning:   Approval pending.