DISTANCE EDUCATION
M.C.A. DEGREE EXAMINATION, MAY 2017.
First Semester
OFFICE AUTOMATION
(2005 to 2010 Calendar year)
Time Three hours Maximum 100 marks
Answer any FIVE questions.
All questions carry equal marks.
20 100)
1. Give a detailed note on managing files with
windows explorer and working with multiple
Windows.
Explain in detail about how to create, open and save
the file in Microsoft Word with relevant dialog boxes
for each of them.
2. Discuss in detail about the various keys used for
editing in Microsoft Word.
How can the user handle tables in Microsoft
Word?
3. What are the various options available for printing
a document in Microsoft Word? Explain them.
Write down the step by step procedure to implement
mail merge feature in Microsoft Word with
corresponding dialog boxes.
Sub. Code
14
DE-442
2
wk16
4. What is a formula bar in Microsoft Excel? Explain
in detail about the use of formula bar in Microsoft
Excel.
How can the user insert and resize rows and
columns in Microsoft Excel?
5. Write a note on conditional formatting in Microsoft
Excel.
Explain how the user can create various kinds of
charts in Microsoft Excel with relevant dialog
boxes.
6. What are the various views available in Microsoft
Excel? Explain.
Write a detailed note on auto layouts and handouts
in Microsoft Excel.
7. Discuss how the user can create tables using
primary key in Microsoft Access.
Write a detailed note on the various operations that
can be performed on fields in Microsoft Access.
8. Discuss about how the user can create and print
reports in Microsoft Excel.
Explain how the user can combine the data and
charts in excel with word documents.