MS office MCQ. Microsoft office Questions and answers for competitive exams preparation with pdf. Important MCQs multiple choice objective question for all exam like CCC, CHSL, MP Police, HSSC, SSC, COPA etc.
MS Office MCQ
1. Microsoft Office is a set of vital applications Primarily known as______.
Ans. Office suit
2. Starting with Microsoft Office 2003, Photo Editor was renamed to:
a) Photo Manager
b) Picture Manager
c) Picture Editor
d) Paint Editor
Ans. b
3. Is Microsoft Works is part of the Microsoft Office suite?
a) Yes
b) No
Ans. b
4. What was the HTML editor that was part of Microsoft Office until 2003?
a) Web Page
b) Explorer
c) FrontPage
d) Dream Weaver
Ans. c
5. Office 365 is now the most popular cloud application in the world. But when did it debut?
a) 2008
b) 2010
c) 2011
d) 2014
Ans. c
6. Can we edit a Macro programmatically after recording it?
a) Yes
b) No
Ans. a
7. We can start MS Word by typing _____ in the Run Dialog Box.
a) winword.exe
b) word.exe
c) msword.exe
d) docx.exe
Ans. a
8. Can we assign a keyboard shortcut of our choice to a Macro?
a) No
b) Yes
Ans. b
9. Which one is the spreadsheet application that comes with MS Office software group?
a) MS Word
b) MS excel
c) MS PowerPoint
d) MS access
Ans. b
10. We can apply border to _____
a) Cell
b) Paragraph
c) Table
d) All of these
Ans. d
11.Which group includes superscript, subscript, strike through options in MS Word?
A. Clipboard
B. Font
C. Paragraph
D. Style
Ans. b
12.What in the purpose of ⌧ button?
A Close button
B Office button
C Maximize buttons
D Minimize button
Ans. a
13.What is the purpose of zoom option?
A Enlarge and reduce document / text size
B Move up and down document / picture
C Scroll left and light document / picture
D Minimize and maximize the document / picture
Ans. a
14.Which option is used for tab setting?
A horizontal ruler
B status bar
C vertical ruler
D vertical scroll bar
Ans. a
15.What in the purpose of vertical scroll bar?
A Move the document up and down
B Move the document left side
C Move the document right side
D Move the document only upwards
Ans. a
16.What in the purpose of undo action in MS Word?
A Restore previous action
B Get the current action
C Goes to previous page
D Goes to previous paragraph
Ans. a
17.Which option is used to activate and deactivate ruler?
A View → grids
B View → ruler
C Insert → tool bar
D Insert → ruler
Ans. b
18.What is the purpose of cover page?
AAllows to fill title, author, date and other information
B Fills the list of people intent to mail
C To view the mailed list
D Contains details of the documents
Ans. a
19.Which menu contains, Symbol option in MS Word?
A tools
B table
C format
D insert
Ans. d
20.Which option is used to locate any specific character, symbols or formulas in a document?
A Find
B Searching text
C Replace
D Selecting text
Ans. a
21.Which feature is used to create a newspaper type document?
A Tables
B Tab stops
C Columns
D Bullets and numbering
Ans. c
22.Which sequence of operation is required to insert bullets for list of data?
A Paragraph group → numbering button → select any number type
B Paragraph group → number button → select none
C Paragraph group → bullet button → type of bullets
D Paragraph group → bullet button → select none
Ans. c
23.Which sequence of operation is required to remove numbering from a list of data?
A Number button → select none from number type
B Number button → select number from number list
C Bullet button → select none from bullet type
D Bullet button → select bullets from bullets list
Ans. a
24.Which sequence of operation is required to remove tab stop markers from ruler?
A Drag the tab stop makers out of the ruler
B Double click the tab marker and clear all
C Right click the tab stop marker and choose remove
D Left click the tab stop marker and choose remove
Ans. a
25.Which feature is used to adjust the amount of space between words for alignment in MS Word
A Spacing
B Scaling
C Justifying
D Positioning
Ans. c
26.How can we rectify the errors occurs while typing?
AAuto entry
B Auto add
C Auto spell
D Auto correct
Ans. d
27.Which sequence of operation is required to force page break in word document?
A by using insert / selection black on the insert tab
B by positioning the cursor at the appropriate place and press enter
C by positioning the cursor at the appropriate place and press F1 key
D by position the cursor at the apporpliate place and pressing ctrl + enter
Ans. d
28.What is the purpose of inserting header and footer in document?
A To make the starting and ending page
B To entrance the appearance of the document
C To make larger document more readable
D To allow page headers and footer appear on the document
Ans. d
29.What is purpose of thesaurus tool is MS Word?
A Grammar option
B Spelling suggestion
C Synonyms and antonyms words
D Auto correction
Ans. c
30. MS word is a _________ software.
a) Word Processing
b) word editor
c) Text editor
d) typing
Ans. A
31.What is the purpose of ‘Enter Key’ in MS Excel?
A Moves cell pointer to previous column
B Moves cell pointer to next column
C Moves cell pointer to previous row
D Moves cell pointer to next row
Ans. d
32.Which function key is used to open goto dialogue box in MS Excel?
A F2
B F5
C F7
D F11
Ans. b
33.Which option in MS Excel is used to display the rows that meet certain conditions?
A Find
B Filter
C Format
D Sort
Ans. b
34.Which option in Excel is used to rearrange the rows base on the content of a particular column?
A Find
B Filter
C Sort
D Format
Ans. c
35.Which type of addressing is used to keep rows constant and column changes and vice versa while copying a formula from one area of the worksheet to another in Excel?
A Mixed
B General
C Relative
D Absolute
Ans. a
36.Which one of the following is ‘no argument’ function?
A Now()
B Lower()
C Max()
D IF()
Ans. a
37.Which key is used to move the insertion point to the beginning of the current sheet?
A Pageup
B Home
C Ctrl + pageup
D Ctrl + Home
Ans. d
38. Which key is used to make multiple line in a single cell?
A Alt+ ↵
B Tab+↵
C Ctrl+ ↵
D Shift+ ↵
Ans. a
39. Columns in MS Excel are named in the form of ______.
(a) alphabets (A, B, C, D,…)
(b) numbers (1,2,3,4,…)
(c) roman numerals (I,II, III, IV,…)
(d) none of them
Ans. a
40. Rows in MS Excel are named in the form of_____ .
(a) alphabets (A, B, C, D,…)
(b) numbers (1,2,3,4,…)
(c) roman numerals (I,II, III, IV,…)
(d) none of them
Ans. b