MS Office MCQs 170+ MCQs

1. From which menu you can insert Header and Footer?

• Insert Menu
• View Menu
• Format menu
• Tools Menu

 

2. To get to the ‘Symbol’ dialog box, click on the menu and choose ‘Symbol’.

• Insert
• Format
• Tools
• Table

 

3.  option from clipboard is used to move data from one place to another in a

• Copy & Paste
• Cut & Paste
• Bold
• Justify

 

4. is an option in Font Group.

• Strikethrough
• Fin
• Replace
• Change Styles

 

 

5. Name the button in the picture?

• Font Color
• Fill Color
• Page Color
• Highlighter tool

 

 

6. Shortcut for document views toolbar is situated in

• Task bar
• Status bar
• Tool bar
• Title bar

 

 

7. Bullets and Numbering is in

• Home tab
• Insert tab
• Pagelayout tab
• View tab

 

8. To open a existing document, click on the and then select Open.

• MS Office button
• Quick Access Toolbar
• Document Views
• Ribbon

 

 

9. Cut, Copy and Paste is in Group in the Home tab.

• Font
• Page Setup
• Clipboard
• Editing

 

 

10. is used to covert from upper case to lower case and vice versa.

• Toggle case
• Sentence case
• Lower case
• Upper case

11. Pressing F8 key for three times selects

• A word
• A sentence
• A paragraph
• Entire document

12. What is the shortcut key you can press to create a copyright symbol?

• Alt+Ctrl+C
• Alt + C
• Ctrl + C
• Ctrl + Shift + C

13. What is the smallest and largest font size available in Font Size tool on formatting toolbar?

• 8 and 72
• 8 and 64
• 12 and 72
• None of above

14. Which of the following is graphics solution for Word Processors?

• Clipart
• WordArt
• Drop Cap
• All of above

 

 

15. A The keystrokes Ctrl + I is used to

• Increase font size
• Inserts a line break
• Indicate the text should be bold
• Applies italic format to selected text

16. A character that is raised and smaller above the baseline is known as

• Outlined
• Raised
• Superscript
• Subscript

17. Thesaurus tool in MS Word is used for

• Spelling suggestions
• Grammar options
• Synonyms and Antonyms words
• All of above

18. Why Drop Caps are used in document?

• To drop all the capital letters
• To automatically begin each paragraph with capital letter
• To begin a paragraph with a large dropped initial capital letter
• None of above

19. A bookmark is an item or location in document that you identify as a name for future reference. Which of the following task is accomplished by using bookmarks?

• To add anchors in web page
• To mark the ending of a paragraph of document
• To quickly jump to specific location in document
• To add hyperlinks in webpage

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

• Office XP
• Office Vista
• Office 2007
• None of above

21. You cannot close MS Word application by

• Choosing File menu then Exit submenu
• Press Alt+F4
• Click X button on title bar
• From File menu choose Close submenu

22. The key F12 opens a

• Save As dialog box
• Open dialog box
• Save dialog box
• Close dialog box

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

• F12
• Shift F12
• Alt + F12
• Ctrl + F12

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

• Save tab on Options dialog box
• Save As dialog box
• Both of above
• None of above

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

• Tab stop box
• Left Indent
• Right Indent
• Center Indent

26. Which file starts MS Word?

• exe
• exe
• exe
• exe

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

• Editions
• Versions
• Track Change
• All of above

28. Background color or effects applied on a document is not visible in

• Web layout view
• Print Layout view
• Reading View
• Print Preview

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

• Page
• Document
• Section
• Page Setup

 

30. Borders can be applied to

• Cells
• Paragraph
• Text
• All of above

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

• Left
• Right
• Center
• Top

32. What is the default left margin in Word 2003 document?

• 1″
• 25″
• 5″
• 2″

33. Portrait and Landscape are

• Page Orientation
• Paper Size
• Page Layout
• All of above

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

• Edit
• View
• Format
• Tools

35. Which of the following is not a font style?

• Bold
• Italics
• Regular
• Superscript

 

36. What happens when you click on Insert >> Picture >> Clip Art

• It inserts a clipart picture into document
• It lets you choose clipart to insert into document
• It opens Clip Art taskbar
• None of above

37. Which option is not available in Insert Table Autofit behavior?

• Fixed Column Width
• AutoFit to Contents
• Autofit to Window
• Autofit to Column

38. To autofit the width of column

• Double click the right border of column
• Double click the left border of column
• Double click the column header
• All of above

39. Which of the following statement is false?

• You can set different header footer for even and odd pages
• You can set different page number formats for different sections
• You can set different header footer for first page of a section
• You can set different header and footer for last page of a section

40. Where can you change the vertical alignment?

• Formatting toolbar
• Paragraph dialog box
• Page Setup dialog box
• Standard toolbar

41. AutoCorrect was originally designed to replace words as you type.

• Short, repetitive
• Grammatically incorrect
• Misspelled
• None of the above

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

• Start recording
• Using your mouse or keyboard, perform the task you want to automate
• Assign a keyboard shortcut to the macro
• Give the macro a name

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

• Data sheet
• Source
• Data source
• Sheet

44. Which of the following is not one of the three ‘Mail Merge Helper’ steps?

• Merge the two files
• Create the main document
• Set the mailing list parameters
• Create the data source

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

• ‘Data Source’ button
• ‘Edit’ button
• ‘Edit Data Source’ button
• ‘Data editing’ button

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

• Create
• Modify
• Sort
• all of the above

47. Comments can be added to cells using …..

• Edit -> Comments
• Insert -> Comment
• File -> Comments
• View –> Comments

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

• 10
• 100
• 300
• 500

49. The spelling tool is placed on toolbar

• Standard
• Formatting
• Drawing
• Reviewing

50. Which of the following is not a valid data type in Excel?

• Number
• Character
• Label
• Date/Time

51. Comments put in cells are called …..

• Smart Tip
• Cell Tip
• Web Tip
• Soft Tip

52. Which menu option can be used to split windows into two?

• Format -> Window
• View -> Window-> Split
• Window -> Split
• View –> Split

53. You can activate a cell by

• Pressing the Tab key
• Clicking the cell
• Pressing an arrow key
• All of above

54. When you use the fill effects in the format data series dialog box, you can not

• rotate text on the chart
• select a fore ground color
• select a pattern
• select a background color

55. To insert three columns between columns D and E you would

• Select column D
• Select column E
• Select columns E, F and G
• Select columns D, E, and

56. Hyperlinks cannot be

• Special shapes like stars and banners
• Drawing objects like rectangles ovals
• Pictures
• All can be hyperlinks

57. You can add an image to a template by clicking the Insert Picture From File button on the …. Toolbar.

• Standard
• Formatting
• Drawing
• Picture

58. To drag a selected range of data to another worksheet in the same workbook, use the

• Tab key
• Alt key
• Shift key
• Ctrl key

59. When you print preview a worksheet

• the entire worksheet is displayed
• the selected range is displayed
• the active portion of the worksheet is displayed
• a, b and c

60. You can open the Sort dialog box by choosing Sort from the ….. menu

• View
• Format
• Tools
• Data

61. When working in the page break preview, you can

• view exactly where each page break occurs
• add or remove page breaks
• change the print area
• all of above

 

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

• 10
• 100
• 300
• 500

 

63. The spelling tool is placed on toolbar

• Standard
• Formatting
• Drawing
• Reviewing

 

64. Formatting a cell in Currency, you can specify

• Decimal Places
• Currency Symbol
• Both of above
• None of above

65. Formatting a cell in Number format you can’t set

• Decimal Places
• Use 1000 separator
• Negative numbers
• Currency Symbol

66. What is entered by the function =today()

• The date value for the day according to system clock
• The time value according to system clock
• Today’s date as Text format
• All of above

67. Which function will you use to enter current time in a woksheet cell?

• =today()
• =now()
• =time()
• =currentTime()

68. Merge cells option can be applied from

• Format Cells dialog box Alignment Tab
• Formatting toolbar
• Both of above
• None of above

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

• Number format
• Border format
• Font format
• All of above

70. How can you remove borders applied in cells?

• Choose None on Border tab of Format cells
• Open the list on Border tool in Formatting toolbar then choose first tool (no border)
• Both of above
• None of above

71. You can set Page Border in Excel from

• From Border tab in Format Cells dialog box
• From Border tool in Formatting toolbar
• From Line Style tool in Drawing toolbar
• You can not set page border in Excel

72. You can check the conditions against when applying conditional formatting

• Cell value
• Formula
• Both of above
• None of above

73. When a range is selected, how can you activate the previous cell?

• Press the Alt key
• Press Tab
• Press Enter
• None of above

74. Each excel file is a workbook that contains different sheets. Which of the following can not be a sheet in workbook?

• work sheet
• chart sheet
• module sheet
• data sheet

75. Which of the following Excel screen components can NOT be turned on or off?

• Formula Bar
• Status Bar
• Tool Bar
• None of above

76. Which of the following option is not available in Paste Special dialog box?

• Add
• Subtract
• Divide
• SQRT

77. Which of the cell pointer indicates that you can fill series?

• Doctor’s symbol (Big Plus)
• small thin plus icon
• Mouse Pointer with anchor at the tip
• None of above

78. Which of the following is an absolute cell reference?

• !A!1
• $A$1
• #a#1
• A1

 

79. Which symbol must all formula begin with?

• =
• +
• (
• @

 

80. Which of the following formulas is not entered correctly?

• =10+50
• =B7*B1
• =B7+14
• 10+50

 

 

81. Which of the following formulas will Excel Not be able to calculate?

• =SUM(Sales)-A3
• =SUM(A1:A5)*.5
• =SUM(A1:A5)/(10-10)
• =SUM(A1:A5)-10

 

82. A worksheet range is a

• A command used for data modeling
• A range of values such as from 23 to 234
• A group of cells
• A group of worksheets

83. The auto calculate feature

• Can only add values in a range of cells
• Provides a quick way to view the result of an arithmetic operation on a range of cells
• Automatically creates formulas and adds them to a worksheet
• A and c

 

84. Excel uniquely identifies cells within a worksheet with a cell name

• Cell names
• Column numbers and row letters
• Column letters and row numbers
• Cell locator coordinates

 

85. To drag a selected range of data to another worksheet in the same workbook, use the

• Tab key
• Alt key
• Shift key
• Ctrl key

86. Hyperlinks can be

• Text
• Drawing objects
• Pictures
• All of above

 

87. To activate the previous cell in a pre-selected range, press

• The Alt key
• The Tab key
• The Enter key
• None of the above

88. Which button do yu click to add up a series of numbers?

• The autosum button
• The Formula button
• The quicktotal button
• The total button

89. When the formula bar is active, you can see

• The edit formula button
• The cancel button
• The enter button
• All of the above

 

90. In a worksheet you can select

• The entire worksheet
• Rows
• Columns
• All of the above

 

91. Which area in an excel window allows entering values and formulas

• Title bar
• Menu bar
• Formula bar
• Standard toolbar

 

92. To edit in an embedded excel worksheet object in a word document

• Use the excel menu bar and toolbars inside the word application
• Edit the hyperlink
• Edit the data in a excel source application
• Use the word menu bar and toolbars

93. To create a formula, you can use:

• Values but not cell references
• C ell references but not values
• Values or cell references although not both at the same time
• Value and cell references

94. Status indicators are located on the

• Vertical scroll bar
• Horizontal scroll bar
• Formula bar
• Standard toolbar

 

95. An excel workbook is a collection of

• Workbooks
• Worksheets
• Charts
• Worksheets and charts

96. Excel files have a default extension of

• Xls
• Xlw
• Wk1
• 123

 

97. Except for the …… function, a formula with a logical function shows the word “TRUE” or “FALSE” as a result

• IF
• AND
• OR
• NOT

 

98. Macros are “run” or executed from the ….. menu.

• Insert
• Frmat
• Tools
• Data

 

99. You can open the consolidate dialog box byt choosing Consolidate from the ….. menu.

• Insert
• Format
• Tools
• Data

 

100. How are data organized in a spreadsheet?

• Lines and spaces
• Layers and planes
• Rows and columns
• Height and width

 

101. Gridlines

• May be turned off for display but turned on for printing
• May be turned on or off for printing
• The be turned off for display and printing
• a, b and c

 

102. A function inside another function is called a ….. function.

• Nested
• Round
• Sum
• Text

 

103. Which function calculates your monthly mortage payment?

• PMT (payments)
• NPER (number of periods)
• PV (present value)
• All of above

 

104. To drag a selected range of data to another worksheet in the same workbook, use the

• Tab key
• Alt key
• Shift key
• Ctrl key

 

105. When the formula bar is activated, you can see

• The Edit Formula button
• The Cancel button
• The Enter button
• All of above

 

106. Which file format can be added to a PowerPoint show?

• .jpg
• .giv
• .wav
• All of the above

107. Material consisting of text and numbers is best presented as

• A table slide
• A bullet slide
• A title slide
• All of the above

108. In order to edit a chart, you can

• Triple click the chart object
• Click and drag the chart object
• Double click the chart object
• Click the chart object

109. to exit the PowerPoint

• click the application minimize button
• click the document close button
• double click the applications control menu icon
• double click the document control menu icon

110. To select one hyperlink after another during a slide presentation, what do you press?

• Tab
• Ctrl + K
• Ctrl + h
• All of above

111. special effects used to introduce slides in a presentation are called

• effects
• custom animations
• transitions
• present animations

112. What is the term used when you press and hold the left mouse key and more the mouse around the slide?

• Highlighting
• Dragging
• Selecting
• Moving

113. To give a PowerPoint presentation to a large audience, you:

• Set up your computer in a large auditorium, and click large, auditorium, OK
• Click the slide you wish the audience to see in normal view, then click the next slide, and so
• Choose either view, slide show or slide show, view show
• Slick slide show, OK

114. Which of the following can you use to add times to the slides in a presentation?

• Slice Show menu
• Rehearse timing button
• Slide transition button
• All of the above

115. Which of the following is not one of PowerPoint’s views?

• Slide show view
• Slide view
• Presentation view
• Outline view

116. Which PowerPoint view works best for adding slide transitions?

• Slide show view
• Slide sorter view
• Slide view
• Notes view

117. Which of the following views is the best view to use when setting transition effects for all slides in a presentation

• Slide sorter view
• Notes page view
• Slide view
• Outline view

118. Which option can be used to set custom timings for slides in a presentation?

• Slider Timings
• Slider Timer
• Rehearsal
• Slide Show Setup

119. Which of the following will not advance the slides in a slide show view?

• The esc key
• The space bar
• The enter key
• The mouse button

120. The quickest way to create a PowerPoint presentation is to use the

• Word for windows templates
• Auto creation wizard
• Auto content wizard
• Presentation wizard

121. Which opf the following can you format using buttons on the formatting toolbar?

• Your hard drive
• Format painting
• Font color
• Underlining

122. To start Microsoft PowerPoint application

• Click on Start >> Programs >> All Programs >> Microsoft PowerPoint
• Hit Ctrl + R then type ppoint.exe and Enter
• Click Start >> Run then type PowerPoint then press Enter
• All of above

 

123. Which menu provides you options like Animation Scheme, custom Animation, Slide Transition?

• Insert Menu
• Format Menu
• Tools Menu
• Slide Show Menu

 

124. In which menu can you find features like Slide Design, Slide Layout etc.?

• Insert Menu
• Format Menu
• Tools Menu
• Slide Show Menu

 

125. The selected design template can be applied

• To current slide only
• To all the slides
• To all the new presentation you create
• All of above

126. What feature will you use to apply motion effects in between a slide exits and another enters?

• Slide Transition
• Slide Design
• Animation Objects
• Animation Scheme

127. What PowerPoint feature will you use to apply motion effects to different objects of a slide?

• Slide Transition
• Slide Design
• Animation Objects
• Animation Scheme

128. Which command will you use in PowerPoint if you need to change the color of different objects without changing content?

• Design Template
• Color Scheme
• Font Color
• Object Color

129. Which short cut key inserts a new slide in current presentation?

• Ctrl+N
• Ctrl+M
• Ctrl+S
• All of above

130. To start slide show of a presentation

• Hit F5 key
• From Slide Show menu choose View Show option
• From Slide Show menu choose Rehearse timing
• Both a & b

 

131. If you select Insert >> Picture >> From File

• You can insert pictures and clipArts
• You can insert clipArts only
• You can insert pictures only
• None of above

 

132. Which of the following font effect is not available in PowerPoint Font dialog box?

• Underline
• Shadow
• Emboss
• Strikethrough

 

133. To insert a hyperlink in a slide

• Choose Insert >> Hyperlink
• Press Ctrl + K
• Hyperlinks can’t be inserted in slides
• Both a & b

 

134. In a PowerPoint presentation

• Sound clips can be inserted but not movie clips
• Movie clips can be inserted but not sound clips
• Both cannot be inserted
• Both can be inserted

135. To insert slide numbers

• Insert a text box and select Insert >> Page Number
• Insert a textbox and select Insert >> Number >> PageNumber
• Choose Insert >> Slide Number
• Insert a new text box and select Insert >> slide Number

136. What are the three options available in Insert >> Picture menu?

• Clipart, Pictures, Shapes
• Clipart, From File, Shapes
• Clipart, From Files, AutoShapes
• Clipart, Pictures, AutoShapes

137. From which menu you can access Picture, Test Box, Chart etc?

• File
• Edit
• Insert
• View

 

138. Which of the following is not a part of Slide Design?

• Design Template
• Color Scheme
• Animation Scheme
• Slide Layout

 

139. What is the term used when a clip art image changes the direction of faces?

• Group
• Flip
• Rotate
• All of the above

140. The slide that is used to introduce a topic and set the tone for the presentation is called the

• table slide
• graph slide
• bullet slide
• title slide

 

141. Which of the following features should you use when typing in the notes text box?

• Slide show
• Insert
• Slide maser
• Zoom

 

142. Which command brings you to the first slide in your presentation?

• Next slide button
• Page up
• Ctrl + Home
• Ctrl + End

 

143. You can show the shortcut menu during the slide show by

• Clicking the shortcut button on the formatting toolbar
• Right clicking the current slide
• Clicking an icon on the current slide
• a and b

 

144. Auto clipart is a feature that

• Automatically places clipart in your presentation
• Scans your presentation for incorrect spelling in your words on each slide
• Scans your presentation for incorrect spelling in Word Arts objects
• All of above

145. The view that displays the slides on a presentation as miniature representations of the slides is called

• slide show
• slide sorter view
• notes page view
• outline view

 

146. Which of the following provides a printed copy of your presentation?

• Outline
• Speaker notes
• Audience handouts
• All of the above

 

147. When using PowerPoint, to play a PowerPoint show for previewing the show, select

• View, slide sorter
• View, slide
• View, slide show
• View outline

 

148. To select all the boxes of an organization chart

• Click edit, select all
• Right click the chart background click select all
• Press and hold the shift key and click each box
• All of the above

 

149. Which of the following should e used when you want to add a slide to an existing presentation?

• File, add a new slide
• Insert, new slide
• File, open
• File, new

 

150. Which key deletes text before, or the left of, the insertion point?

• Backspace
• Page up
• Delete
• Page down

 

151. Microsoft PowerPoint is a

• Database program
• Spreadsheet program
• Presentation program
• Word processing program

 

152. Which of the following programs is not a popular desktop publishing program?

• Adobe PageMaker
• Microsoft Publisher
• Lotus AmiPro
• QuarkXPress

 

153. Which menu provides you options like Animation Scheme, custom Animation, Slide Transition?

• Insert Menu
• Format Menu
• Tools Menu
• Slide Show Menu

154. In which menu can you find features like Slide Design, Slide Layout etc.?

• Insert Menu
• Format Menu
• Tools Menu
• Slide Show Menu

155. Which of the following is not a font style?

• Bold
• Italics
• Regular
• Superscript

 

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

• Left
• Right
• Center
• Top

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

• Page
• Document
• Section
• Page Setup

 

158. Background color or effects applied on a document is not visible in

• Web layout view
• Print Layout view
• Reading View
• Print Preview

 

159. Which of the following is not true about Find and Replace in Excel

• You can search for bold and replace with italics
• You can decide whether to look for the whole word or not
• You can search in formula too
• You can search by rows or columns or sheets

160. The best way to insert a new slide in a presentation is to use the

• Normal view
• Special view
• Slide show view
• Slide sorter view

161. What is the maximum number of lines you can set for a drop cap?

• 3
• 10
• 15
• 20

162. Which of the following line spacing is invalid?

• Single
• Double
• Triple
• Multiple

163. Which of the following are word processing software?

• WordPerfect
• Easy Word
• MS Word
• All of above

164. Which of the following is not of the merge process?

• Sort the data source records
• Format a main document
• Edit a data source
• Merge the two files to print or create a new document

165. Which of the following is the latest version of MS Word?

• Word 2000
• Word 2007
• Word 2010
• Word 2011

166. In Microsoft PowerPoint two kind of sound effects files that can be added to the presentation are

• .wav files and .mid files
• .wav files and .gif files
• .wav files and .jpg files
• .jpg files and .gif files

167. special effects used to introduce slides in a presentation are called

• effects
• custom animations
• transitions
• present animations

168. In Microsoft PowerPoint the entry effect as one slide replaces another in a show is called a (an)

• animation
• slide transition
• custom animation
• preset animation

169. To add a header or footer to your handout, you can use

• The title master
• The slide master
• The handout master
• All of above

170. In Microsoft PowerPoint in order to see all the slides on one screen use

• view, slide sorter
• view, slide
• view, master
• view, slide show

171. Which of the following is the default page setup orientation for slides in PowerPoint?

• Vertical
• Landscape
• Portrait
• None of above

 

172. Pagemaker is a __________software.

• Desktop Publishing
• Word Processor
• Spredsheet
• Presentation

173. ____________ is at the top of the window and it display the name of the application.

• Menu bar
• Title bar
• Tool bar
• Tool box