M.C.A. (Semester II) (CBCS) Examination, 2017
M.C.A
OFFICE AUTOMATION
Day Date: Friday, 28-04-2017 Max. Marks: 70
Time: 10.30 AM to 01.00 PM
N.B. and are compulsory.
Answer any three questions from Q.3 to Q.7.
All questions carry equal marks.
Q.1 Choose correct alternatives. 10
CPU is considered as the of the computer.
Brain Heart Software None of these
A new presentation can be created from
Blank Presentation From Existing Presentation
From Design Template All of above
A feature that displays only the data in column(s) according to
specified criteria is called
Formula Sorting Filtering Pivot
The process of removing unwanted part of an image is called

Hiding Bordering Cropping Cutting
Where footnotes appear in a document
End of document Bottom of a page
End of Heading None of these
The intersection of a column and a row on a worksheet is called

Column Value Address Cell
Which of the following creates a drop down list of values to choose
from
Ole Object Hyperlink
Memo Lookup wizard
is collection of programs designed to operate,
control, and extend the processing capabilities of the computer itself.
System Application Window None of these
Page 1 of 2
Which of the following is not one of PowerPoint view
Slide show view Slide view
Presentation view Outline view
10) The feature of MS Excel quickly completes a series of
data.
Auto Complete Auto Fill
Fill Handle Sorting
Fill in the blanks or true false: 04
Ms Office is Application Software
The Undo command in the Edit menu issued to reverse actions.
It is not possible to insert an Excel sheet in a word document.
It is not possible to animate different parts of a slide.
Q.2 Write short notes on the following 08
Difference between Save and Save As.
Pivot Chart
Answer the following 06
Explain Desktop icons and their functions.
Explain Hyperlink object.
Q.3 Answer the following 14
Explain components of computer
Explain Charts group in MS Excel.
Q.4 Answer the following 14
What do you mean by computer? Explain Applications of Computer.
Explain any 5 objects of Insert Menu in MS PowerPoint.
Q.5 Answer the following 14
Explain computer software and Hardware.
What is comment? Why it is used?
Q.6 Answer the following 14
What is Database? How to create form in MS Access?
Write the Important features of MS PowerPoint?
Q.7 Answer the following: 14
Explain Pivot Table in detail.
Explain Page layout objects.