M.Sc.(Semester II) (CBCS) Examination, 2017
COMPUTER SCIENCE
OFFICE AUTOMATION
Day Date: Friday, 28-04-2017 Max. Marks: 70
Time: 10.30 AM to 01.00 PM
N.B. Q no. 1 Q. no. 2 are compulsory.
Attempt any three questions from Q. no. 3 to Q. no. 7
Figures to the right indicate full marks.
Q.1 Choose the correct Answer: 10
With which of the following all formulas in excel starts?

What term describes explanatory text attached to a cell?
Context Callout Comment Dialog
Which of these will not select all the cells in a document?
Using the Edit select All menu
Pressing Ctrl A on the keyboard
Clicking three times with the right mouse button in the
spreadsheet
None of these
What is the smallest and largest font size available in Font
Size tool on formatting toolbar?
8 and 72 8 and 68
6 and 72 6 and 68
MS-WORD automatically moves the text to the next line
when it reaches the right edge of the screen and is called?
Carriage Return Enter
Word wrap None of these
Where can you find the horizontal split bar on MS Word
screen?
On the left of horizontal scroll bar
On the right of horizontal scroll bar
On the top of vertical scroll bar
On the bottom of vertical scroll bar
Which of the following helps to reduce spelling error in the
document?
Auto Format Auto Correct
Smart Tags AutoText d
Page 1 of 2
Where can you find the Master view on MS-Power point
screen?
View Animation Design Layout
Which among following first generation of computers had?
Micro processor
Vacuum Tubes and Magnetic Drum
IC chips
All of above
10) If the displayed system time and data is wrong, you can
reset it using
Control panel MS Word
Toolbar Desktop panel
Fill in the blanks. 04
key for add new slide below current slide in
MS-Power point.
2)MS Access is Software.
Start Restart the computer is called
key for find and replace the query text from
text document.
Q.2 Attempt the following. 08
Explain the importance and use of My Documents.
How to use Formula Auditing in MS-Excel? Explain with
example.
Write a short note on 06
Print Preview
Recycle Bin
Q.3 What is desktop icon? Explain three icon with their function. 07
What is Computer? Explain its characteristics. 07
Q.4 What is the use of mail merge? Explain detail process of mail
merge.
07
What is the use of table in MS word? Explain the process of
adding formula in table.
07
Q.5 What is MS excel? Explain its application. 07
Describe pivot table in MS excel with a suitable example. 07
Q.6 What are different method of setting presentation style in MS
Power Point? briefly explain any two method.
07
What is a MS power point? Describe use of MS power point in
education with an example.
07
Q.7 Describe the detail process of importing and exporting data
from other databases in MS Access.
07
Describe the "form" in MS access and any two operations with
a suitable example.