General Microsoft Office MCQs

1. Suppose that you have downloaded a new font from the web for your Microsoft Word 2016 document. If you want to open this document on another computer that doesn‘t have the same font. you need to embed it. Which of the following options marked in the image will you choose to embed the font in the document?

2. There are red triangles in the upper-right corner of each cell under the column titled ‘Class'. What do they signify?

3. The IT security depanmc-ltt of Mark's organization has (loaded that only digitally signed macros will he allowed in micorosoft’s Excel 2016. Which of the following is the correct way to restrict the unsigned macros?

4. In order to show a timeline; a progression; sequential steps In a process. task or workflow; or to emphasize movement or direction, which of the following Process type SmatArt graphics will be the most suitable option?

5. When you create a document in Microsoft Word 2016, certain personal information is added to the f‌ile, eg. information about the author of the document. if you want to share the document with others but do not want to share that personal Information, then which of the following options will you choose to retrieve that information from the file?

6. What will be the output if we apply the formula. =AVERAGEIFS(D2:D7, A2:A7, 2016, B2:B7, '>6')?

7. Which type of circle represents the top of the hierarchy in a Sunburst chart in Microsoft Word 2016?

8. Suppose that you have entered some text in a Microsoft Word 2016 document as shown in figure 1 of the given image. Which of the following actions will you perform to achieve the text formatting (underline every word) as shown in figure 2 of the given image?

9. Suppose that you have inserted a few images into a Microsoft Word 2016 document. From which of the following views under the View tab, you will NOT be able to edit these images? 1. Print Layout 2. Web Layout 3. Outline 4. Draft

10. Which tab will you click for accessing the View Macros option in Microsoft Excel 2016. ?

11. Maria inserts a table with three rows and three columns into a Microsoft Word 2016 document. Now she wants to delete that table from the document- Which of the following isr’are the correct procedure[s] to do this? 1. Place the cursor Inside any cell of the table and press the Delete key. 2. Right-click on the table move handle and select Delete Table. 3. Select the whole table by right-clicking on the table move handle and press Delete key. 4. Select the whole table by right-clicking on the table move handle and press Ctrl + Delete

12. In Microsoft Excel 2016. which of the following options is used for limiting or restricting the cell entries to a certain data type?

13. In Microsoft PowerPoint 20i6, which of the following keys can be used to pause the slideshow delivery?

14. The coach of the national cricket team wants to analyze the strengths and weaknesses of the team players. He has selected 4 major areas to analyze: fitness. f‌lexibility. attitude and punctuality. Which of the following chart types will be most suitable in this situation?

15. in Microsoft PowerPoint 20l6. which of the following view types should be used to show all the slides in a presentation on one screen?

16. While changing the resolution of a picture in Microsoft PowerPoint 2016. which of the following is NOT included in the Adjust group under the Format tab?

17. Which is the correct syntax of the VLOOKUP command?

18. Consider the given Image for the following question. John inserts a PivotTa bie in Sheet 2, based on the data given in the image. He drags the 'Days' f‌ield from the list of columns to the Values Section in the PivotTabie Fields pane. Which of the followi

19. Which is correct about subtotal and total f‌ields in a Microsoft Excel 2016 PivotTable report?

20. Which keyboard shortcut should be pressed to switch between relative and absolute cell references while writing a formula in a worksheet in Microsoft Excel 20l6?

21. Which is NOT a correct method for consolidating data in Microsoft Excel 2016?

22. Which keyboard shortcuts is used to add a new slide to a presentation in Microsoft PowerPoint 2016?

23. Which is correct procedure to divide a paragraph into three columns in a Microsoft Word 2016 document?

24. Which option is NOT a default watermark in the Watermark gallery in Microsoft Word 2016?

25. Suppose that you have typed a paragraph as shown in f‌igure 1 of the given image. You have applied center alignment to the paragraph and the resultant paragraph is shown in f‌igure 2 of the given image. Which of the following is the correct procedure to apply center alignment to the paragraph?

26. For which options, if included in a worksheet. we cannot use the Track Changes option while working in Microsoft Excel 2016. ?

27. Which is incorrect about deleting cropped areas of a picture in Microsoft PowerPoint 2016?

28. Which is used for displaying or hiding formulas changers) the state of a cell in Microsoft Excel 2016? i) Prevent formulas from displaying in the formula bar by protecting the cells that contain them. ii) Switch between displaying formulas and formula results on a worksheet. iii) Show hidden formulas by removing the protection from cells.

29. By default. how many worksheets are there in a new Microsoft Excel 2016 workbook?

30. Which type of chart is shown in the given image with reference to Microsoft Word 2016.?

31. Which keyboard shortcut is used to add a new slide to a presentation in Microsoft PowerPoint 2016?

32. Which keyboard shortcut is used to apply subscript formatting?

33. While changing the resolution of a picture in Microsoft PowerPoint 2016, which of the following is NOT included in the Adjust group under the Format tab?

34. If you want to remove a picture watermark that was applied as a background, then which of the following sets of steps will you choose in Microsoft PowerPoint 2016?

35. Which is incorrect about the Animations pane with respect to Microsoft PowerPoint 2016?

36. By default, all cell references in Microsoft Excel 2016 are:

37. How can we define a name to a cell in a Microsoft Excel 2016 Worksheet?

38. Which is correct about working with slides in a Microsoft PowerPoint 2016 presentation?

39. Which keyboard shortcut is used to open the Macros dialog box in Microsoft Word 2016?

40. When you are applying animations to objects, in which of the following panes can you give each object a distinct name to make it easier to work with them, In Microsoft PowerPoint 2016?

41. Which option is used for limiting or restricting the cell entries to a certain data type in Microsoft Excel 2016,?

42. Which option is NOT a valid setting for Page Border in Microsoft Word 2016,?

43. Suppose that you have copied data from an Excel worksheet and want to paste it in your PowerPoint 2016 presentation. While pasting data to your presentation from thePasteoption under theHometab, which of the following options will you choose in order to copy the data as information that can be edited in Excel later?

44. Which tab on the ribbon is used to display the Navigationpane while working in a Microsoft Word 2016 document, ?

45. Which is NOT a part of Emphasis Animations under the Animations tab in Microsoft PowerPoint 2016, ?

46. Suppose that you have downloaded a new font from the web for your Microsoft Word 2016 document. If you want to open this document on another computer that doesn

47. Which one is NOT an animation effect?

48. Which statement is correct with respect to PowerPoint 2016, ?

49. Rony has written a research paper in a Word document and wants to share it with his friend for review. Rony has turned on Track Changes in the document and wants to use a password to prevent his friend from turning off Track Changes. Which of the following options is the correct procedure to apply a password?

50. In which view, gridlines in the background of the document can be seen while working with a Microsoft Word 2016 document, ?

51. While inserting PDF file contents as a picture into your PowerPoint 2016 presentation, which of the following options is the correct set of steps for screen clipping?

52. Which is the correct procedure to divide a paragraph into three columns in a Microsoft Word 2016 document,?

53. If the word 'Permit' is typed in a Word document with the cursor between the letters

54. Which option is NOT a default watermark in the Watermark gallery in Microsoft Word 2016?

55. Which is correct about subtotal and total fields in a Microsoft Excel 2016 PivotTable report?

56. Which type of circle represent(s) the top of the hierarchy in a Sunburst chart in Microsoft Word 2016,?

57. Which functional key is used for spelling and grammar check in a Microsoft Word 2016 document?

58. Suppose that you have selected some text in a Microsoft Word 2016 document and you want to strikethrough that selected text, then which of the following keyboard shortcuts will you use?

59. Which option is NOT available under 'What-If Analysis' in Microsoft Excel 2016,?

60. Which keyboard shortcut should be pressed to switch between relative and absolute cell references while writing a formula in a worksheet, in Microsoft Excel 2016. ?

61. When do we receive a '#Value!' error in the VLOOKUP function in Microsoft Excel 2016? i) When the 'lookup_value' argument is more than 255 characters. ii) When the 'col_index_num' argument contains text. iii) When the 'col_index_num' argument is equal to 0.

62. Which type of chart do NOT have axes in Microsoft Word 2016?

63. What is the correct function of the Format Painter option in Microsoft Excel 2016?

64. Which statement is incorrect about templates, In Microsoft PowerPoint 2016?

65. if you want to look for grammar options under the Smart Lookup dialog box, which of the following options will you choose in In Microsoft PowerPoint 2016?

66. The IT security department of Mark's organization has decided that only digitally signed macros will be allowed in Microsoft Excel 2016. Which of the following is the correct way to restrict the unsigned macros?

67. which key can be used to pause the slide show delivery? in Microsoft PowerPoint 2016,

68. Suppose that you have inserted a few images into a Microsoft Word 2016 document. From which of the following views under the View tab will you be NOT able to edit those images?

69. Which keyboard shortcut will you press to run the Spell Checker?

70. Which is used to set up a presentation to play at a certain speed by saving appropriate time for each slide and animation?

71. A Pareto chart belongs to which chart type in Microsoft Word 2016?

72. In Microsoft Excel 2016, the =TODAY()command returns:

73.

Consider the Excel sheet given in the image. What will be the output if you type the formula, =COUNTA(A1:B8), in cell B9?

74.

Which of the following options can be used for checking the protection status of a file in Microsoft Excel 2016?

75.

In Microsoft Excel 2016, which of the following options used for displaying or hiding formulas change(s) the state of a cell?

i) Prevent formulas from displaying in the formula bar by protecting the cells that contain them.

ii) Switch between displaying formulas and formula results on a worksheet.

iii) Show hidden formulas by removing the protection from cells.

76. Which tab will you click for accessing the View Macrosoption?

77. While using cell references with multiple worksheets in Microsoft Excel 2016, which of the following options is the correct absolute cell reference that must be used for cell B2 on a sheet named 'Sheet5'?

78. Which tab should you select to make choices about how and when a video plays, if you have inserted or linked to a video on a video-sharing social media platform such as YouTube?

79. By default, how many worksheets are there in a new Microsoft Excel 2016 workbook?

80. The coach of the national cricket team wants to analyze the strengths and weaknesses of the team players. He has selected 4 major areas to analyze: fitness, flexibility, attitude and punctuality. Which of the following chart types will be most suitable in this situation?

81. Which is the correct method of consolidating data in Microsoft Excel 2016?

82. John wants to use a SmartArt graphic to create a chart for his organization. He wants to show the reporting relationships of his organization, such as managers of the departments and non-management employees. Which of the following SmartArt graphic types will be the most suitable for him to use?

83. Which shortcut is used to redo the last performed action in a Microsoft Word 2016 document?

84. Which can be used to avoid users to make changes to a worksheet in Microsoft Excel 2016?

85. Maria inserts a table with three rows and three columns into a Microsoft Word 2016 document. Now she wants to delete that table from the document. Which of the following is/are the correct procedure(s) to do this?

86. What will happen when we click on the marked triangle as shown in the given image?

87. While formatting a text, which option will you choose for applying a reflection, shadow, bevel, glow, transform or a 3-D rotation?

88. Which keyboard shortcut is used to switch between Normal view and Outline view?

89. Which type should be used to show all the slides in a presentation on one screen?

90. Which optioncan be copied using the format painter in Microsoft Excel 2016?

91. In a Microsoft Word 2016 document, which of the following functions are performed by footnotes and endnotes?

92. While working in Microsoft Excel 2016, for which of the following options, if included in a worksheet, we cannot use theTrack Changesoption?

93. In a Microsoft Word 2016 document, what is the maximum number of columns that can be added to a selected paragraph?

94. What is the keyboard shortcut for toggling between cases (uppercase/lowercase/sentence case)?

95. Which option is the correct procedure that is used for converting a table to a regular range?

96. In Microsoft PowerPoint 2016, which of the following statements is incorrect about deleting cropped areas of a picture?

97. In Microsoft Word 2016, which of the following tabs can be used to record a macro?

98. Samantha is using SmartArt graphics to represent the performance of her team members. She wants to show the best performers on the top and narrowing down. Which of the following SmartArt types will be the most suitable option to do this?

99.

When you create a document in Microsoft Word 2016, certain personal information is added to the file, e.g. information about the author of the document. If you want to share the document with others but do not want to share that personal information, then which of the following options will you choose to remove that information from the file?

100. In Microsoft Excel 2016, which of the following is the correct syntax of the VLOOKUP command?

101. In Microsoft PowerPoint 2016, which of the following options can be used to create a unified look for a presentation by using closely-united theme colors, effects, fonts and slide backgrounds that suit each other?

102. In Microsoft PowerPoint 2016, which of the following options is the correct way to change the layout of slides?

103. In Microsoft Excel 2016, how can we publish a Workbook to Power BI?

104. In Microsoft PowerPoint 2016, following are the advanced motion path options, except for:

105. In order to change the Office theme in Microsoft PowerPoint 2016, go to File > Account, and then click the drop-down menu next toOffice Theme. Which of the following options is another way to change the Office theme?

106. Which of the following keyboard shortcuts will let you exit the Slide Show view at any time?

107. Which of the following commands in Microsoft Excel 2016 allows a user to automatically create groups and use common functions such as sum, count and average for helping in summarizing data?

108. In Microsoft Word 2016, which of the following is NOT a valid option for Macro Settings under the Trust Center in Word Options?

109. In order to show a timeline; a progression; sequential steps in a process, task or workflow; or to emphasize movement or direction, which of the following Process type SmartArt graphics will be the most suitable option?

110. In the New Slide option under the Insert tab, which option should you select if you want to import slides from another presentation in Microsoft PowerPoint 2016?

111. Suppose that you have typed a paragraph as shown in figure 1 of the given image. You have applied center alignment to the paragraph and the resultant paragraph is shown in figure 2 of the given image. Which of the following is the correct procedure to apply center alignment to the paragraph?

112. Which of the following types of watermark can be applied to a Microsoft Word 2016 document?

113. A user can enable the Data Connections settings, in order to connect with external data?

114. which statement is correct about Morph transition?

115. which keyboard shortcuts is used for the 'Clear filter' command for Slicer in a Pivot table?

116. With reference to Microsoft Word 2016, which of the following types of chart is shown in the given image?

117. Which of the following axis settings are available for the appearance of data bars for negative values in Microsoft Excel 2010?

118. Which of the following is true regarding Microsoft Excel 2010 Web App?

119. Which of the following statements regarding images in Microsoft Excel 2010 are true?

120. In Microsoft Word 2010, 'Keep lines together' paragraph formatting:

121. You want to add an image as the first character in your paragraph. Which type of text wrapping treats your graphic as if it were a character?

122. Which of the following types of worksheets will not load in Microsoft Excel Services?

123. Why would you use content controls in a document?

124. Which of the following actions CANNOT be performed by the user on the Business Contact Manager database?

125. If a table cell is vertically split into two separate cells using the Draw Table option, any existing text in the cell will be split up and text will appear in both of the two newly created cells .

126. You are editing a shape using the Drawing Tools. Which among the following Shape Fill options in the Shape Styles group gives you control over the transparency for a shape?

127. You have just created a new document based on the normal template and have created a custom style. You now want to make that custom style easily available in all future documents. In order to do this, you need to select:

128. Which of the following delegate permission levels allows you to change and delete the items that the manager created?

129. What is one way to ensure that the sound icon doesn't show in the presentation?

130. Which of the following is INCORRECT regarding setting of passwords in Microsoft Outlook 2010?

131. With which chart type(s) is the 'Depth Gridlines' option available?

132. Which of the following tag is not available in Microsoft Outlook 2010?

133. By default, when you paste a chart from Excel into PowerPoint 2007, is it linked or embedded?

134. Below are two statements regarding Breaks in Microsoft Word 2010. Statement X: Text Wrapping Page Break separates text around objects on web pages, such as caption text from body text. Statement Y: Continuous Section Break inserts a section break and starts the new section on the next page. Which of the following options is correct?

135. Which of the following is not a category of transition?

136. Dave receives a file named Theme1.thmx from his boss. Opening the file opens a blank PowerPoint document. On clarifying from his boss, he learns that the .thmx file contains a particular theme which needs to be applied to the annual report on which Dave is working. How can Dave achieve this?

137. How can you remove duplicate emails present in a particular folder?

138. How do you turn off the controls that show in the lower left corner of the screen during a slide show?

139. You are a financial consultant to multiple clients and you made an investment model for them. Now you want to find out how investment rates change under different market conditions. Which of the following Microsoft Excel 2010 What-if analysis tools will you use to study such conditions?

140. In the given screenshot, there are red triangles in the upper-right corner of each cell under the column titled 'Registrations'. What do these signify?

141. When using the booklet-printing feature, the term 'gutter' refers to the space between page content and the fold in the middle of the paper where you would normally bind pages together.

142. Which of the following are included in a digitally signed e-mail message?

143. Which of the following actions from the Delete group not only moves all the existing messages but also the future messages in the selected Conversations to the Deleted Items folder?

144. Which of the following methods will you use to insert a hyperlink in a message in Microsoft Outlook 2010, if the format of the mail is set to Rich Text?

145. If you were writing a book and wanted each chapter to start on the right page, which Section Break would you use to begin each chapter?

146. Which standard form is used to record actions which relate to specific contacts and put the action in a Timeline view?

147. Which of the following areas in the Microsoft Excel 2010 PivotTable Field List, calculates the aggregates of columns?

148. If I do not want the contents of one of my fields to automatically update, I would have to do which of the following?

149. Consider the following scenario: A table cell contains text. You place your cursor in that cell and split it into two columns. The resultant text will:

150. How will you read comments that reviewers have added to your presentation?

151. Which of the following animation Effect Options will you choose when you want the SmartArt diagram to animate piece by piece?

152. What is one thing the Compress Pictures feature does?

153. Which of the following is NOT an option when inserting a Cross-reference?

154. What is the purpose of time stamping a digital signature in Microsoft Excel 2010?

155. In MS Excel when your cursor is in the last cell of a table, what does Tab key do?

156. Suppose you want to use the Translate command to work with the text. Where can you locate it on the Ribbon?

157. Which of the following types of tabs is displayed in the tab row when an object, such as an image, is selected or highlighted in the application workspace, in Microsoft Outlook 2010?

158. Which of the following statements is not true regarding offline cube files in Microsoft Excel 2010?

159. To insert a new citation to a specific book in a Microsoft Word 2010 document, you should select:

160. You customized the navigation pane with a lot of folders and shortcuts but now you want to remove all of them. What command line switch would you use with outlook.exe to remove the folders you added?

161. How would you write on the slides during a slide show?

162. Which of the following record types of Business Contact Manager for Microsoft Outlook 2010 allows you to plan and track communication activities to accomplish a business result, such as increasing market share, introducing a new product, or retaining customers?

163. The default chart colors are determined by what?

164. How would you assign a macro to a graphic?

165. In MS 2010 PowerPoint, how would you crop a picture to an exact set of dimensions?

166.

What are the benefits of digitally signing an e-mail in Microsoft Excel 2010?

167. Which of the following describes the outcome of double-clicking on a pivot report value of a PivotTable in Microsoft Excel 2010?

168. Suppose you have created a report in Excel named 'report.xlsx'. Now you want your team members should be able to see the report remotely on a web browser, and edit the report, as desired. Also it is required that the previous versions of the report are maintained to protect against any loss of data. Which of the following options is the most suitable one to deploy this report?

169. Which of the following defines the correct purpose of using a poster frame image?

170. Which among the following settings is the default macro security setting?

171. What does the Compare tool do?

172. Which among the following chart types do not have axes?

173. Which level of junk e-mail protection available in Microsoft Outlook 2010 will you apply, if you want all such e-mails to be treated as junk whose senders are neither on your Safe Senders List nor on your Safe Recipients List?

174. Which picture format maintains transparency in MS 2010 Powerpoint?

175. How do you insert a new slide master into a presentation?

176. In the Customize Ribbon dialog, choosing Reset All Customizations does what?

177. How many items can be maintained on the clipboard at one time?

178. You added a custom tab in the Microsoft Excel Ribbon and exported this Ribbon Toolbar customization into a file named 'custom.exportedUI'. After a few days, you import this Ribbon Toolbar customization file back to Microsoft Excel 2010. What will happen to the prior Ribbon Toolbar customizations made during this period?

179. How do you repair a Microsoft Outlook 2010 .pst file if it gets damaged?

180. Suppose there are some files in a folder named 'demo', which were archived to a file named demo.pst. Now you want to restore this archive to a folder named 'demo1'. Which option in the File tab will you use for this purpose, in Microsoft Outlook 2010?

181. Josh is to create a technical write-up comprising short paragraphs with double line spacing. Each paragraph is to be separated from the other by a single line space. He writes a paragraph, selects the text, points to Line Spacing on the paragraph toolbar and sets it to 2.0. He gets the paragraph double spaced. The moment he clicks enter to start a new paragraph, it automatically gets double spaced. How can Josh achieve paragraphs separated by single line spaces from each other within the document?

182. Which among the following command-line switches starts up Microsoft Outlook 2010 with the Reading Pane turned off?

183. What view must be used when inserting a subdocument?

184. Slicers are filtering components which are used to filter the data in a PivotTable report or CUBE functions. Which of the following data sources is/are supported by Slicers in Microsoft Excel 2010?

185. Which tools are used to format Excel worksheet data, as shown in the figure above?

186. In Microsoft Excel 2010, The LOOKUP function returns a value either from a one-row or one-column range or from an array. Which of the following statements are true regarding the LOOKUP function in Microsoft Excel 2010?

187. contents of the 'Name of User' column have been oriented at an angle. How is this done?

188. For which of the following Business Contact Manager record types is it mandatory to be linked to an Account or Business Contact record?

189. How would you add a logo to all the slides in a presentation?

190.