MS Office MCQ (Microsoft office Questions)

MS office MCQ. Microsoft office Questions and answers PDF for competitive exams preparation. Important MCQ multiple choice objective question for all exam like CCC, CHSL, MP Police, HSSC, SSC, COPA etc.

1. Microsoft Office Related Questions

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

2. 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

3. 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

4. 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

5. 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

41. The intersection of a row and column in MS Excel is called _______ .
(a) spreadsheet (b) workbook (c) document (d) cell
Ans. d

42. The cell having and column number 3 and row number 6 is denoted by the name ______.
(a) F3 (b) C6 (c) C3 (d) F6
Ans. b

43. In MS Excel, a function is entered by typing ______ symbol first.
(a) @ (b) $ (c) # (d) =
Ans. d

44. MS Excel can ______ given data.
(a) sort (b) statistically analyze (c) draw graphs for (d) all of them
Ans. d

45. The latest version of MS Excel can have ______rows.
(a) 10,48,576 (b) 16,384 (c) 1024 (d) 512
Ans. a

46. The latest version of MS Excel can have ______columns.
(a) 10,48,576 (b) 16,384 (c) 1024 (d) 512
Ans. b

47. Excel supports recording of repeated actions with the help of ______.
(a) graph (b) chart (c) macro (d) other applications
Ans. c

48. MS Excel macros can be invoked using_______.
(a) button (b) keystroke (c) both a & b (d) neither a nor b
Ans. c

49. MS Excel supports a version of Visual Basic called ______for programming.
(a) Javascript (b) Visual Basic for Applications (VBA)
(c) ASP.NET (d) C#.NET
Ans. b

50. Each sheet in MS Excel file is called a ______.
(a) workbook (b) worksheet
(c) notesheet (d) notebook
Ans. b

6. 51. In Powerpoint, animated flow of text and images in presentation can be applied using _______
menu.
(a) Animations>Advanced Animation (b) Animations>Preview
(c) Animation>Timing (d) none of them
Ans. a

52. In Powerpoint, slide animation preview can be opened using _______ menu.
(a) Animations>Advanced Animation (b) Animations>Preview
(c) Animation>Timing (d) none of them
Ans. b

53. In Powerpoint, animation timings can be controlled using _____ menu.
(a) Animations>Advanced Animation (b) Animations>Preview
(c) Animation>Timing (d) none of them
Ans. c

54. In Powerpoint, slide shows from beginning, slide show from current slide and custom slide
show can be started using ______ menu.
(a) Slide show>Start slide show (b) Slide show>Set up
(c) Slide show>Monitors (d) none of them
Ans. a

55. In Powerpoint, slide shows can be setup, slide can be hidden, timing can be rehearsed and
slide transition times can be recorded using _____menu.
(a) Slide show>Start slide show (b) Slide show>Set up
(c) Slide show>Monitors (d) none of them
Ans. b

56. In Powerpoint, proofing, language, comments and comparison of 2 slide shows can be
accomplished using ______ menu.
(a) Review (b) View (c) Slide show (d) Animations
Ans. a

57. In Powerpoint, presentation views, master views, ruler, grilines, guides, zoom, fit to window,
color, grayscale, black and white, new window, arrange all, cascade, move split, swich windows
and macros can be accessed using _____ menu.
(a) Review (b) View (c) Slide show (d) Animations
Ans. b

58. To make effective presentation, minimize text and maximize ______.
(a) images (b) graphs (c) videos (d) all of them
Ans. d

59. To make an effective impact, a presentation should be _____.
(a) very long, running to 2 or 3 hours
(b) short and sweet
(c) unorganized, mixing head and tail at one place
(d) blank from first to last slide
Ans. b

60. Optimum duration for making a presentation is_______ .
(a) 7 hours (b) 3 to 4 hours (c) 1 minute (d) 22 to 35 minutes
Ans. d

7. 61. In presentation, the rule of 3 means, ________ .
(a) people forget the first 3 items (b) people forget the last 3 items
(c) people remember the best 3 items (d) people remember the worst 3 items
Ans. c

62. After preparing a presentation, it should______ to make it effective.
(a) be kept in a pen drive or CD till delivery (b) never be opened till delivery
(c) be opened just for delivery (d) be rehearsed many times
Ans. d

63. To make an effective presentation, one should _____ the text typed in the slides.
(a) simply keep reading
(b) add spice to the text through stories and fables
(c) keep reading (whether the audience listens or not)
(d) none of them
Ans. b

64. One should record the presentation in ______ and watch it again to find the mistakes done
during delivery.
(a) paper (b) video (c) text (d) transcript
Ans. b

65. To make an effective presentation, one should________ .
(a) forget what is on the current slide (b) forget what is on the next slide
(c) remember offer a lead to the next slide (d) never care for the order of slides
Ans. c

66. One should have_________ to cater to the unexpected situations of projector failure, power
failure, computer failure, disk error, etc.
(a) a backup plan for alternate delivery (like through paper handouts)
(b) a style to say sorry
(c) a practice to weep in front of the audience over the failure
(d) guts to say good bye without making the presentation
Ans. a

67. Before making a presentation, the presenter should _______.
(a) arrive at the room early
(b) verify the presentation loaded on the projector
(c) choose the best place to stand during the presentation
(d) all of them
Ans. d

68. The Powerpoint dialog box is useful to create a new presentation by using:
a) Installed tamplates b) Open c) Installed themes d) Both A and C
Ans. d

69. How many slide layouts are available in new slide dialog box?
a) 9 b) 7 c) 14 d) 16
Ans. a

70. Which view is shown in the presentation of slides in a conference?
a) Slide sorter view b) slide view c) slide show view d) outline view
Ans. c

8. 71. You need to arrange a meeting for all employees in a particular department – do you
a) Call up the members contact detains in the address book, and send them an email with the date
and time of the meeting?
b) Click the send and receive button, in the group email section click on the group, then choose
meeting
c) Right click the calendar and choose new meeting request, then complete the form and choose
send
d) Don’t know
Ans. c

72. You want to set up a button to automatically send an email you’ve received on to your
manager, rather than have to manually choose their name every time. Would you
a) Click the forward button on the home tab then from the file tab choose save as button
b) Click the home tab and choose to manger from quick steps
c) Click the send/receive tab and choose forward to address book member
d) Don’t know
Ans. b

73. What’s an effective and efficient way to send the same email message to a group of people?
a) Create a distribution list b) Use the Bcc field
c) Send the message over and over d) List every person’s email address in The “To” field
Ans. a

74. If Outlook shows only one day’s schedule in the calendar, how can you make it show several
days?
a) Click one of the toolbar buttons preset for longer times
b) Drag to increase the column size for the area that shows the day
c) Make more room in the Calendar window by closing the Outlook Bar
d) None of these
Ans. a

75. The fastest way to place an email into a folder you have created is…..
a) Right click the email message and choose “Move to folder…”, then click on the folder and click
OK
b) click and drag the message into the folder
c) Go to the Edit menu and choose “Move to folder..”
d) None of these
Ans. b

76. We can request a receipt to show an email has been read by
a) Right clicking the send button and choosing send with receipt
b) Click the send/receive tab, and click the receipted mail button
c) Click the options tab from the message window and choose request receipt
d) Don’t know
Ans. c

77. We can set the reading pane under the email list by –
a) From the view tab click the reading pane button and choose bottom
b) From the home tab click tools, choose options and click the reading pane button for below list
c) Click the file tab, and choose PowerPoint preferences then click the button for pane under text
d) None of these
Ans. a

9. 78. On the task list, to arrange tasks in date order, then in alphabetical order we
a) Click at the top of the date column, then on the top of the subject column
b) Use the file menu, and choose the date arrange command
c) Use the view tab and use the view settings button
d) None of these
Ans. c

79. What are categories?
a) ways to assign a colour code and name to an item to help find that item later and group it with
other similar items
b) Different types of data, like appointments, to do tasks, email messages etc
c) A quick classification system for contacts, for example into business and personal
d) None of these
Ans. a

80.Your boss sent you an important account code by mail two months ago. Unfortunately, you
haven’t been sorting or deleting your mail and there are currently over 41,000 mails in your inbox.
You need that account code now. What is the quickest way to find it?
a) Look through the “Important mail from my boss” folder
b) Sort by “From” and then look at all other mail from your boss
c) Search on key words related to the account code and your boss’s name
d) Sort by date and then look through mail from two months ago
Ans. c

81. ______ menu contains items required for mail merge functionality in MS Word.
(a) Home (b) Insert (c) Mailings (d) Reference
Ans. c

82. A set of VBA instructions to assist in carrying out recurring activities in is called _____ .
(a) mail merge (b) macro (c) thesaurus (d) spell check
Ans. b

83. On opening MS Word (without clicking on a target document), it displays _______ document.
(a) previous (b) formatted (c) completed (d) blank/ new
Ans. d

84. MS Word provides ______ to function as the starting point special new documents like report,
visiting card, brochure, etc.
(a) template (b) macro (c) image (d) table
Ans. a

85. After opening a new document in MS Word, one should _______ to create a comfortable
experience.
(a) set paper size (b) set font size
(c) set paragraph spacing, line spacing (d) all of them
Ans. d

86. ______ are the most important objects used in MS Word documents.
(a) tables& pictures
(b) shapes, flow charts & clip arts
(c) equations, lists, bullets & numbering
(d) all of them
Ans. d

10. 87. MS Word has the ability to automate repeated tasks using _______ .
(a) tables (b) pictures
(c) equations (d) macros
Ans. d

88. In MS Word, a Macro may be assigned _______ to invoke its functionality.
(a) keyboard shortcut
(b) a button
(c) either keyboard shortcut or button
(d) neither keyboard shortcut nor button
Ans. c

89. In MS Word, the default macro security setting is _______ .
(a) Enable all macros
(b) Disable all macros
(c) Trust VBA Code
(d) Do not trust VBA code
Ans. b

90. In MS Word, it is better change macro security setting to ________ before starting record or
use macros.
(a) Enable all macros
(b) Disable all macros
(c) Trust VBA Code
(d) Do not trust VBA code
Ans. a

1. Name the Desktop Database application that is part of MS Office suit.
a) MS word
b) MS access
c) MS PowerPoint
d) MS excel

2. A feature of MS Office that saves the document automatically after certain interval is
called______
a) Save
b) Save as
c) Auto Save
d) Backup

3. Which feature is used to make selected sentence to All Capital letters or all Small letters?
a) Change Letter
b) Change Sentence
c) Change Case
d) Change Word

4. Which of these software application was not part of the first version of Microsoft Office?
a) Paint b) PowerPoint
c) Outlook d) MS Word

5. To go to a specific location in a document we use:
a) Table of Contents b) HyperText
c) Bookmark d) Macro

11. 6. Which one of the most suitable reason to use Macro in MS Office (Word, Excel, PPT, etc.)?
a) To Record sound b) To autosave repetitive tasks
c) To record Mouse Move d) To record Keystroke

7. Superscript, Subscript, strikethrough are known as?
a) Font Face b) Font Style
c) Font Effects d) Font Format

8. A Microsoft Office user who has been certified by Microsoft is called MOS. What is the full form
of MOS?
a) Microsoft Office Special b) Microsoft Office Superior
c) Microsoft Office Specialist d) Microsoft Office eSpecial

9. Name the application under MS Office software bundle, that we use to create audio visual
presentation.
a) MS Word b) MS excel
c) MS PowerPoint d) MS access

10. You cannot close MS Office application by
a) Exit from File menu b) Pressing Alt + F4
c) Clicking [x] Button d) close from file menu

Click here for Answers
Computer Best MCQ Book in Just Rs.29/- [7000+ Question in English]
https://bharatskills.in/best-computer-mcq-book-for-competitive-exams/

Computer Best MCQ Book in Just Rs.25/- (2100+ Question in Hindi)
https://bharatskills.in/computer-mcq-book-in-hindi-pdf/

HEETSON

Telegram https://t.me/Heetson_Official
WhatsApp Channel

@heetsoniti