270+ Office Automation Tools Solved MCQs

1.

What is the function of Ctrl + B in Ms-Word

A. it converts selected text into the next larger size of the same font
B. it adds a line break to the document
C. it makes the selected text bold
D. it applies italic formatting t the selected text
Answer» C. it makes the selected text bold
2.

Graphics for word processor is

A. peripheral
B. clip art
C. highlight
D. execute
Answer» B. clip art
3.

What is the function of CTRL+R in MS-Word

A. open the print dialog box
B. update the current web page
C. close the current window
D. none of these
Answer» D. none of these
4.

Which of the following is / are the additional features of Ms Word 2007?

A. quick access toolbar
B. ms button
C. ribbon
D. all the above
Answer» D. all the above
5.

In Microsoft Word shortcut key CTRL+W is used for

A. open the print dialog box
B. update the current web page
C. close the current window
D. none of these
Answer» C. close the current window
6.

Which shortcut key is used to spell check in MS-Word?

A. f1
B. f2
C. f7
D. f9
Answer» C. f7
7.

Why headers and footers used in MS -Word

A. to enhance the overall appearance of the document
B. to mark the starting of a page
C. to make large document more readable
D. to allow page headers and footers to appear on document when it is printed
Answer» D. to allow page headers and footers to appear on document when it is printed
8.

The minimum number of rows and columns a word table can have is

A. zero
B. 2 rows and 1 column
C. 2 rows and 2 column
D. 1 row and 1 column
Answer» D. 1 row and 1 column
9.

In MS-Word shortcut SHIFT+DELETE is used to

A. delete the selected item permanently without placing the item in the recycle bin
B. copy the selected item
C. rename the selected item
D. create a shortcut to the selected item
Answer» A. delete the selected item permanently without placing the item in the recycle bin
10.

In MS Word to move the insertion point to the beginning of the next word command used is

A. ctrl+rightarrow
B. ctrl+left arrow
C. ctrl+down arrow
D. none of these
Answer» A. ctrl+rightarrow
11.

Which of the following line spacing is invalid?

A. multiple
B. double
C. triple
D. single
Answer» C. triple
12.

How can you apply exactly the same formatting you did to another text?

A. copy the text and click on paste special tool on new place
B. select the text then click on format painter and select the new text
C. copy the text and paste in new location. then type the new text again
D. all of above
Answer» B. select the text then click on format painter and select the new text
13.

What should you do if you require pasting the same format in many places?

A. double click the format painter then go on pasting in many places
B. click the format painter then go on pasting to many places holding ctrl key
C. click the format painter and go on pasting in many places holding alt key
D. all of above
Answer» A. double click the format painter then go on pasting in many places
14.

On which toolbar can you find Format Painter tool?

A. formatting toolbar
B. picture toolbar
C. drawing toolbar
D. standard toolbar
Answer» D. standard toolbar
15.

Which indent marker controls all the lines except first line?

A. left indent marker
B. first line indent marker
C. right indent marker
D. hanging indent marker
Answer» A. left indent marker
16.

Which operation you will perform if you need to move a block of text?

A. copy and paste
B. paste and cut
C. cut and paste
D. paste and delete
Answer» C. cut and paste
17.

What is the extension of Word files?

A. dot
B. txt
C. fil
D. doc
Answer» D. doc
18.

Which of the following option is not available in Insert >> Picture?

A. chart
B. graph
C. clip art
D. word art
Answer» B. graph
19.

To insert a drop cap in one of the paragraph you should access

A. format
B. tools
C. insert menu
D. none of above
Answer» A. format
20.

How many different positions can you set for drop cap?

A. 1
B. 2
C. 3
D. 4
Answer» B. 2
21.

Which of the following can NOT be used to create parallel style column?

A. insert textbox
B. table insert table
C. format tabs
D. format columns
Answer» D. format columns
22.

Which of the following is used to create newspaper style columns?

A. format columns
B. table insert table
C. format tabs
D. insert textbox
Answer» A. format columns
23.

Columns dialog box can be opened from...

A. press alt + o + c
B. format menu columns submenu
C. double click on column space in ruler
D. all of above
Answer» D. all of above
24.

You can jump to the next column by

A. press alt + down-arrow
B. clicking with your mouse on the next column
C. both of above
D. none of above
Answer» C. both of above
25.

To open Columns dialog box quickly..

A. double click the space between area on ruler
B. double click the right margin in ruler
C. double click on the left margin area of ruler
D. all of above
Answer» A. double click the space between area on ruler
26.

Which of the following command is not available in Tools menu?

A. auto summarize
B. macro
C. autocorrect
D. auto text
Answer» D. auto text
27.

Text boundary can be displayed or hidden from

A. customize from tools menu
B. auto text option from insert menu
C. options from tools menu
D. all of above
Answer» C. options from tools menu
28.

Which of the following is / are word processing software?

A. ms word
B. easy word
C. wordperfect
D. all of above
Answer» D. all of above
29.

MS Office provides help in many ways, which of these is one of them?

A. help menu
B. what is this?
C. office assistant
D. all of the above
Answer» D. all of the above
30.

What is the maximum scale percentage available in Scale drop down box?

A. 300
B. 200
C. 100
D. 50
Answer» B. 200
31.

Bold, Italic, Regular are known as

A. text effects
B. font effects
C. font styles
D. word art
Answer» C. font styles
32.

Changing the appearance of a document is called

A. editing
B. proofing
C. formatting
D. all of above
Answer» C. formatting
33.

In a document what is the maximum number of columns that can be inserted in MS Word Table?

A. 31
B. 32
C. 63
D. 64
Answer» C. 63
34.

A screen element of MS Word that is usually located below the title bar that provides categorized options is...

A. status bar
B. menu bar
C. tool bar
D. all of the above
Answer» B. menu bar
35.

A ____________ is a small program that helps to automate a frequently used series of commands in most productivity software tools.

A. macro
B. utility
C. template
D. wizard
Answer» A. macro
36.

Which of the following is the second step in creating a macro?

A. using your mouse or keyboard, perform the task you want to automate
B. give the macro a name
C. assign a keyboard shortcut to the macro
D. start recording
Answer» C. assign a keyboard shortcut to the macro
37.

If you will be displaying or printing your document on another computer, you’ll want to make sure and select the _____________ option under the ‘Save’ tab.

A. embed true type fonts
B. embed fonts
C. save true type fonts
D. save fonts
Answer» A. embed true type fonts
38.

In Word, the mailing list is known as the ____________.

A. data source
B. sheet
C. data sheet
D. source
Answer» A. data source
39.

Which of the following button will allow you to add, delete, or change records in your Data Source?

A. ‘edit’ button
B. ‘data editing’ button
C. ‘data source’ button
D. ‘edit data source’ button
Answer» D. ‘edit data source’ button
40.

It is possible to _______ a data source before performing a merge.

A. modify
B. sort
C. create
D. all of the above
Answer» D. all of the above
41.

What is the default font size of a new Word document based on Normal template?

A. 9 pt
B. 12 pt
C. 14 pt
D. none of above
Answer» B. 12 pt
42.

What is the default font used in MS Word document?

A. times new roman
B. arial
C. algerian
D. none of the above
Answer» A. times new roman
43.

Which tab in Font dialog box contains options to apply font effects?

A. text effects
B. standard toolbar
C. font tab
D. character spacing
Answer» C. font tab
44.

Drop Cap means

A. small caps
B. title case
C. all caps
D. none of above
Answer» D. none of above
45.

Which function of Ms Word enables you to create multiple mails at a time?

A. macro
B. mail merge
C. scenario manager
D. pivot table
Answer» B. mail merge
46.

Which of the following is not valid version of MS Office?

A. office xp
B. office vista
C. office 2007
D. none of above
Answer» D. none of above
47.

You cannot close MS Word application by

A. choosing file menu then exit submenu
B. press alt+f4
C. click x button on title bar
D. from file menu choose close submenu
Answer» D. from file menu choose close submenu
48.

The key F12 opens a

A. save as dialog box
B. open dialog box
C. save dialog box
D. close dialog box
Answer» A. save as dialog box
49.

What is the short cut key to open the Open dialog box?

A. f12
B. shift f12
C. alt + f12
D. ctrl + f12
Answer» D. ctrl + f12
50.

A feature of MS Word that saves the document automatically after certain interval is available on

A. save tab on options dialog box
B. save as dialog box
C. both of above
D. none of above
Answer» A. save tab on options dialog box
51.

Where can you find the horizontal split bar on MS Word screen?

A. on the left of horizontal scroll bar
B. on the right of horizontal scroll bar
C. on the top of vertical scroll bar
D. on the bottom of vertical scroll bar
Answer» C. on the top of vertical scroll bar
52.

Which of the following is not available on the Ruler of MS Word screen?

A. tab stop box
B. left indent
C. right indent
D. center indent
Answer» D. center indent
53.

What is place to the left of horizontal scroll bar?

A. tab stop buttons
B. view buttons
C. split buttons
D. indicators
Answer» B. view buttons
54.

Which file starts MS Word?

A. winword.exe
B. word.exe
C. mswo
D. exe
Answer» A. winword.exe
55.

How many ways you can save a document?

A. 3
B. 4
C. 5
D. 6
Answer» A. 3
56.

If you want to keep track of different editions of a document which features will you use?

A. editions
B. versions
C. track change
D. all of above
Answer» B. versions
57.

Background colour or effects applied on a document is not visible in

A. web layout view
B. print layout view
C. reading view
D. print preview
Answer» D. print preview
58.

What is a portion of a document in which you set certain page formatting options?

A. page
B. document
C. section
D. page setup
Answer» C. section
59.

Borders can be applied to

A. cells
B. paragraph
C. text
D. all of above
Answer» D. all of above
60.

Which of the following is not a type of page margin?

A. left
B. right
C. centre
D. top
Answer» C. centre
61.

What is the default left margin in Word 2007document?

A. 1"
B. 1.25"
C. 1.5"
D. 2"
Answer» B. 1.25"
62.

What is gutter margin?

A. margin that is added to the left margin when printing
B. margin that is added to right margin when printing
C. margin that is added to the binding side of page when printing
D. margin that is added to the outside of the page when printing
Answer» C. margin that is added to the binding side of page when printing
63.

Portrait and Landscape are

A. page orientation
B. paper size
C. page layout
D. all of above
Answer» A. page orientation
64.

If you need to change the typeface of a document, which menu will you choose?

A. edit
B. view
C. format
D. tools
Answer» C. format
65.

Which of the following is not a font style?

A. bold
B. italics
C. regular
D. superscript
Answer» D. superscript
66.

------------- is a spread sheet application

A. ms word
B. ms access
C. ms excel
D. all of these
Answer» C. ms excel
67.

Who is considered as father of electronic spread sheet?

A. dan bricklin
B. allen turing
C. winton serf
D. charles babbage
Answer» A. dan bricklin
68.

Which of the following is / are the additional features of Ms Excel 2007?

A. quick access toolbar
B. ms button
C. ribbon
D. all the above
Answer» D. all the above
69.

A file in Ms Excel is Called----------

A. work sheet
B. work book
C. work field
D. work file
Answer» B. work book
70.

A work book is a collection of ----------- used in a single file

A. work sheet
B. work record
C. work field
D. work file
Answer» A. work sheet
71.

A function inside another function is called _______

A. nested function
B. round function
C. sum function
D. text function
Answer» A. nested function
72.

Which of the following is not an underline option in the format cells dialog box?

A. double
B. single accounting
C. double accounting
D. single engineering
Answer» D. single engineering
73.

Formulas in Excel start with

A. %
B. =
C. +
D.
Answer» B. =
74.

The default header for a worksheet is

A. username
B. date and time
C. sheet tab name
D. none
Answer» C. sheet tab name
75.

Which of the following is not an option of the spelling dialog box?

A. ignore
B. ignore all
C. edit
D. change
Answer» C. edit
76.

Which of the following methods will not enter data in a cell?

A. pressing the esc key
B. pressing an arrow key
C. pressing the tab key
D. clicking the enter button to the formula bar
Answer» A. pressing the esc key
77.

The cell reference for cell range of F2 to P12 is _______

A. f2.p12
B. f;p12
C. f2:p12
D. f2-p12
Answer» C. f2:p12
78.

What is the keyboard shortcut for creating a chart from the selected cell range?

A. f2
B. f4
C. f8
D. f11
Answer» D. f11
79.

The Software which contains rows and columns is called ______

A. database
B. drawing
C. spreadsheet
D. word processing
Answer» C. spreadsheet
80.

You can group non-contiguous worksheets with

A. the alt+enter key
B. the ctrl key and mouse
C. the shift key and the mouse
D. the group button on the standard toolbar
Answer» B. the ctrl key and mouse
81.

Which of the following is not a valid Zoom percentage in Excel?

A. 75
B. 100
C. 200
D. 500
Answer» D. 500
82.

The spelling tool is placed on ______ toolbar

A. standard
B. formatting
C. drawing
D. reviewing
Answer» A. standard
83.

If you need a text to show vertically in a cell. How will you achieve this?

A. choose vertical on text alignment in format cells dialog box
B. choose 90 degrees in orientation of format cells dialog box
C. choose distributed from the vertical drop down list of format cells dialog box
D. choose centre across selection from horizontal combo box in format cells dialog box
Answer» B. choose 90 degrees in orientation of format cells dialog box
84.

Can you set 0.5 inch left indentation for a cell in Excel?

A. excel does not have indentation feature
B. you can specify indentation only if you turn the rulers on
C. indentation can be set from format cells dialog box
D. the indentation can be specified only when printing
Answer» C. indentation can be set from format cells dialog box
85.

You can automatically adjust the size of text in a cell if they do not fit in width by

A. double clicking on the right border of column header
B. from format choose columns and then auto fit selection
C. from format cells dialog box mark shrink to fit check box
D. all of above
Answer» C. from format cells dialog box mark shrink to fit check box
86.

Formatting a cell in Currency, you can specify

A. decimal places
B. currency symbol
C. both of above
D. none of above
Answer» C. both of above
87.

Formatting a cell in Number format you can’t set

A. decimal places
B. use 1000 separator
C. negative numbers
D. currency symbol
Answer» D. currency symbol
88.

What is entered by the function =today()

A. the date value for the day according to system clock
B. the time value according to system clock
C. today’s date as text format
D. all of above
Answer» B. the time value according to system clock
89.

Which function will you use to enter current time in a worksheet cell?

A. today()
B. =now()
C. =time()
D. =current time()
Answer» C. =time()
90.

Special category of Number tab in Format Cells dialog box can be used to apply formats like

A. zip code
B. phone number
C. both of above
D. none of above
Answer» C. both of above
91.

Merge cells option can be applied from

A. format cells dialog box alignment tab
B. formatting toolbar
C. both of above
D. none of above
Answer» C. both of above
92.

Pre-made sheet formats like Simple, Classic, Accounting, Colourful etc. can be applied from

A. from format >> cells
B. from format >> auto format
C. from table >> auto format
D. all of above
Answer» B. from format >> auto format
93.

Which of the following format you can decide to apply or not in AutoFormat dialog box?

A. number format
B. border format
C. font format
D. all of above
Answer» D. all of above
94.

How can you remove borders applied in cells?

A. choose none on border tab of format cells
B. open the list on border tool in formatting toolbar then choose first tool (no border)
C. both of above
D. none of above
Answer» C. both of above
95.

Where can you set the shedding colour for a range of cells in Excel?

A. choose required colour form patterns tab of format cells dialog box
B. choose required colour on fill colour tool in formatting toolbar
C. choose required colour on fill colour tool in drawing toolbar
D. all of above
Answer» D. all of above
96.

You can set Page Border in Excel from

A. from border tab in format cells dialog box
B. from border tool in formatting toolbar
C. from line style tool in drawing toolbar
D. you cannot set page border in excel
Answer» D. you cannot set page border in excel
97.

When all the numbers between 0 and 100 in a range should be displayed in Red Colour, apply

A. use =if() function to format the required numbers red
B. apply conditional formatting command on format menu
C. select the cells that contain number between 0 and 100 then click red colour on text colour tool
D. all of above
Answer» B. apply conditional formatting command on format menu
98.

You can check the conditions against __________ when applying conditional formatting

A. cell value
B. formula
C. both of above
D. none of above
Answer» C. both of above
99.

Which of the following is not true regarding Conditional Formatting?

A. you can add more than one condition to check
B. you can set condition to look for bold and apply italics on them.
C. you can apply font, border and pattern formats that meets the specified conditions
D. you can delete any condition from conditional formatting dialog box if it is not required
Answer» C. you can apply font, border and pattern formats that meets the specified conditions
100.

In Microsoft Excel 2007, the ----------- is used to issue commands

A. quick access tool bar
B. formula bar
C. ribbon
D. ms button
Answer» C. ribbon
Tags
Question and answers in Office Automation Tools, Office Automation Tools multiple choice questions and answers, Office Automation Tools Important MCQs, Solved MCQs for Office Automation Tools, Office Automation Tools MCQs with answers PDF download