B.A. (Three Year) DEGREE EXAMINATION, MARCH/APRIL 2017.
End Semester Examination
Fourth Semester
Part II Computer Applications
OFFICE AUTOMATION TOOLS
(Common for B.A./B.Sc./B.Com. Computer Applications)
2 C 4303
Time 3 Hours Max. Marks 70
PART — A
Answer any FIVE of the following. 4 20 Marks)
1. What is the difference between auto fill and custom fill?
2. How can you change row height and column width?
3. Create a table in MS-Access using design view.
4. How can you import table in to Access?
5. What is sorting? Write steps to sort by multiple columns.
6. What do you know about number formatting in Excel?
7. What is the use of what-if analysis?
8. How can you print a report?
PART — B
Answer ALL of the following questions. 10 50 Marks)
UNIT I
9. What are the features of Excel?
Or
Write procedure to enter and edit formula in Excel.

UNIT II
10. What are the different formatting options in font dialog box?
Or
What are the advantages of functions?
UNIT III
11. Write a procedure to find the subtotals in Excel.
Or
What are the parts of chart? Explain with diagram.
UNIT IV
12. Write a brief notes on MS-Access. Also list the advantages of Access.
Or
Describe the procedure to create a form.
UNIT V
13. What do you know about simple query wizard?
Or
Describe about various types of relationships.