MCQs > Finance & Management > Excel MCQs > General MCQs

General MCQ for Excel

1. A red triangle at the top right corner of a cell indicates what?

2. The Doughnut chart type

3. Which formula below will add the value of B2 to the value of C3

4. A user can sort a maximum of...

5. There are three worksheets with every new workbook. You can change that automatic number if you want to.

6. Which of the following is a 'Lookup and Reference' function?

7. What does Live Preview allow the user to do?

8. A ________________ consists of a grid made from columns and rows?

9. The cell range that starts in cell A1 and goes over to column J and down to row 15 is _____

10. How do you make a chart?

11. What is the correct formula to calculate the total of cell B3 and B4?

12. When a formatted number does not fit within a cell, what does the cell display?

13. An example of a range address.

14. The cell reference of a range of cells that starts in cell B1 and goes over to column G and down to row 10 is ….

15. If you choose a larger font size, the height of the row is automatically made taller.

16. To unhide a sheet and make viewable with other tabs in the current window:

17. Which cannot be included in a header/footer?

18. The Remove Duplicates command:

19. What is the answer for this formula? =if(A1>=B1,'Good','Not Good') ---> A1=90 , B1=90

20. What would the following formula do? =Sheet1!D9+Sheet1!E9

21. Data displays in the ____ as you type.

22. Formatting a cell in Currency, you can specify...

23. How can you set 0.5 inch left indentation for a cell in Excel?

24. An array range that includes both rows and columns is known as____?

25. On an excel sheet the active cell in indicated by ?

26. How can you remove borders applied in cells?

27. What happens when dollar signs ($) are entered in a cell address? (ex. $B$2:$B$10)

28. If you see a small red triangle in the top right corner of a cell, it means there is something 'attached' to the cell. What is it?

29. True or False: The formula =((A2+B5)*5% is valid.

30. Which is an INCORRECT formula for sum of cells A1 to A5?

31. In the formula, which symbol specifies the fixed columns or rows?

32. Data can be arranged in ascending or descending order by using:

33. A _______ is a predefined formula that helps perform common mathematical functions.

34. What should be the file type of a saved excel macro file

35. How would you find the absolute value of A1?

36. If A1=6 and B1=4, then what is =A1&B1?

37. A ____ is a predefined set of colors, fonts, chart styles, cell styles, and fill effects that can be applied to an entire workbook.

38. What is a group of cells that form a rectangle on the screen?

39. Which function returns the Student's t-distribution?

40. Which of the following is mixed cell reference with a fixed row address?

41. What is a shortcut to minimize or maximize the ribbon?

42. Selecting the Rows 5 & 6 then choose Insert->Row

43. Where is conditional formatting located?

44. What does it mean when the 'marching ants' border around selected cells disappears?

45. The formula QUARTILE(a1:a100,1) returns:

46. Two common wildcard characters that Excel recognizes are

47. What's the recalculate shortcut?

48. What does COUNTA () function do?

49. The formula QUARTILE(a1:a100,4) returns:

50. Which is false regarding Conditional Formatting?

51. What is the Mini Toolbar used for?

52. Which setting must you modify to print a worksheet using a letterhead?

53. The chart wizard term data series refers to:

54. What does 'Merge Cells' do?

55. Which of the following is NOT a 'Solving Method' available in the Solver Add-in?

56. Which of the following options is NOT located in Page Setup?

57. To print a page number on the bottom of every printed page:

58. You can set Page Border in Excel from...

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

60. The formula =IFISERROR(A2) returns:

61. A 3D reference means

62. Which option allows us to copy content without formatting?

63. Timelines are particularly designed for _______ fields that sort out data from a pivot table.

64. Which limitation is valid in Microsoft Excel 2010?

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

66. Which cell reference in a formula should be used for making sure that a column value does not change when copied?

67. Sam wants to generate a Pivot table based on the data given in the image. He wants to show the count of employees for the values given in the Days column. For example, Days 5 = 3, Days 6 = 2, etc. Which of the following options will be the correct fields

68. What is the correct function of the Format Painter option?

69. The Split command enables a user to view a worksheet in how many panes?

70. What will happen if you enter XYZ1 in a cell and drag the fill handle down?

71. Which is used to avoid users to make changes to a worksheet in Microsoft Excel 2016?

72. What does the VALUE function do?

73. Commands should NOT be removed from the Quick Access Toolbar because these commands are NOT available on the ribbon's command tabs?

74. Keyboard shortcut pressed to switch between relative and absolute cell references while writing a formula in a worksheet?

75. Suppose that you conducted an aptitude test in a class room to check if the students are ready for competitive exams. Now you want to calculate the average of the total marks obtained by the students in the test. Which of the following formulas can be used to calculate the average of the 'Marks Obtained' in the cell 'I4'

76. With respect to Protect Workbook in Microsoft Excel 2016, the Windows option can be used for preventing users from moving, resizing or closing the workbook window

77. John inserts a PivotTable in Sheet 2, based on the data given in the image. He drags the 'Days' field from the list of columns to the Values section in the PivotTable Fields pane. Which of the following options will be the default selection under the Values section?

78. Correct procedure used for converting a table to a regular range?

79. If a user specifies a print area from the backstage view, then it saves the setting with the workbook.

80. User can enable the Data Connections settings, in order to connect with external data?

81. John inserts a PivotTable in a worksheet, as shown in figure 1 of the given image. There are three columns in the data source: Employee, Product and Sales. Now John wants to show the list of products under the employee names as shown in figure 2 of the given image. Where should he double-click on the PivotChart in figure 1, so that he should be able to select the Product column?

82. Default file extension(s) of a Microsoft Excel 2016 workbook?

83. In order to treat a numerical value as a text value in Microsoft Excel 2016, it should precede with which of the following symbols?

84. Keyboard shortcut used for achieving the strikethrough effect as shown in the given image?

85. Suppose that you have a table in a worksheet of Microsoft Excel 2016 workbook, as shown in the image. Which of the following output is obtained if you select the table and check the Total Row option under the Design tab?

86. Which tab will you click for accessing the View Macros option?

87. Which is NOT a valid option for Macro Settings under the Trust Center?

88. The CHOOSE function can be used for selecting up to how many values based on an index number?

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

90. Which is correct about the #Data constant in Microsoft Excel 2016?

91. Which filter can be created using the AutoFilter option in Microsoft Excel 2016? i) By list values. ii) By format. iii) By criteria.

92. Commands allows a user to automatically create groups and use common functions such as sum, count and average for helping in summarizing data?

93. Which statements is correct about Track Changes in Microsoft Excel 2016?

94. Function used for providing the decimal number of the time represented by a text string?

95. Options used to access the option that is used to get data from a text file?

96. Keyboard shortcuts used for moving from any cell to the beginning of a worksheet, i.e. cell A1?

97. Correct syntax of the VLOOKUP command?

98. Which options provides a user the access to options such as Share, Export, Account, Publish, etc.?

99. 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'?

100. In Microsoft Excel 2016, the commands used for recording, creating and deleting macros is accessed from the Developer tab. Which of the following is the correct way of displaying the developer tab on the ribbon?

101. What happens when the Freeze Panes option is used on some of the rows and columns in Microsoft Excel 2016?

102. Which command is used in Microsoft Excel 2016 for totaling all the budget spreadsheets prepared by each department in an organization?

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

104. Which option can be used for checking the protection status of a file in Microsoft Excel 2016?

105. How can we remove password encryption from a Microsoft Excel 2016 file?

106. Which logical function doesn't return True or False as a result in Microsoft Excel 2016?

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

108. In Microsoft Excel 2016, which of the following arguments of the YEARFRAC function is/are optional? i) Start date. ii) End date. iii) The type of day count basis to use.

109. What does the blue triangle and border color imply in cell B4?

110. 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?

111. Peter was working in a Microsoft Excel 2016 workbook. His workbook closed due to a system error and he couldn't save it. Which of the following is the correct way to recover an unsaved workbook?

112. The 'brush' symbol indicates which of the following options?

113. Consider the data given in the image. What will be the output if the formula, =PROPER(A1), is applied to cell A2?

114. Correct keyboard shortcut for accessing the backstage view in Microsoft Excel 2016?

115. Which is correct about macro naming rules in Microsoft Excel 2016?

116. While editing a cell's content, if you change your mind about the changes you made before pressing the enter key, which of the following keys can be pressed to restore to the original text?

117. Which function can be performed on a protected worksheet if the password is not known?

118. For which of the following options, if included in a worksheet, we cannot use the Track Changes option?

119. When do we receive a '#Value!' error in the VLOOKUP function? 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.

120. Which of the following options is NOT a correct method for consolidating data in Microsoft Excel 2016?

121. Which of the following options can be copied using the format painter in Microsoft Excel 2016? 1. Alignment 2. Background color 3. Cell text

122. Consider the Excel sheet given in the image. If you wanted to find out the average of all the cells that meet multiple criteria which function would you use?

123. What does the Look up value function do?

124. In Excel 2016 worksheet, which shortcut is used for switching between displaying formulas and their results?

125. Which of the given page margins are available under the Page Layout tab in Excel 2016?

126. Which of the given types Of pivot charts can be used in Microsoft Excel 2016? 1. Pie chart 2. Waterfall chart 3. Treemap chart

127. Data sorting in columns can be performed on which Of the given Options? 1. Values 2. Cell Color 3. Font Color 4. Cell icon

128. In Microsoft Excel 2016, which of the following Engineering functions tests the equality Of two numbers?

129. Consolidate Option is available under which of the following tabs?

130. In Excel 2016, which function returns an aggregated value from the cube?

131. Can we change the default font size of a new workbook in Excel 2016 from the Backstage view?

132. Which of the given statements are correct about the slicers in Microsoft Excel 2016? 1. They can be used to filter data in a table. 2. They can be used to f‌ilter data in a PivotTable. 3. They can only be connected to PivotTables that share the same data source.

133. A valid certificate from a certificate authority is required to add a digital signature in Microsoft Excel 2016 workbook.

134. lf Sam wants to insert a pivot chart in his Excel worksheet, then which Of the following tabs should he use tO perform the same?

135. In order to protect your Excel data, which of the given f‌ile-level protections are available in Microsoft Excel 2016? 1. File encryption 2. Setting a password to open or modify a f‌ile 3. Digital signature

136. Correct function of the Wrap Text in Microsoft Excel 2016?

137. Can you perform a case sensitive data sorting in Microsoft Excel 2016?

138. if Sam wants to change the Office theme or background. then which of the following options will he use?

139. in relation to the Backstage view in Microsoft Excel 2016, which of the given commands! options are available under the Info tab? 1. Protect Document 2. Manage Workbook 3. Browser View Options

140. The cursor in the given image is on A3 cell. If you want to move the cursor to E8 cell, then which of the following shortcuts can be used?

141. What are the correct purposes of CEILINGMATHI) function in Microsoft Excel 2016?

142. The Lookup & Reference Option is available under which Of the following tabs?

143. In relation to the Clear option under the Home tab in Microsoft Excel 2016. which of the following options can be cleared from the cell?

144. Which of the following tabs will you use to hide the header row of the table (given in the image)?

145. While creating a PivotTable in Excel 2016, where can a user place the PivotTable report? It is always placed in a new worksheet. It is always placed in an existing worksheet. It can either be placed in a new worksheet or in an existing worksheet. In Microsoft Excel 2016, which of the following values can be returned by the ISTEXT() function?

146. Which of the following functions checks whether all the arguments are TRUE, and returns TRUE if all the arguments are TRUE?

147. In relation to building out the PivotTable, which of the following fields are added to the COLUMNS area?

148. An Excel workbook is a collection of ?

149. To create an outline in Excel in order to easily expand a heading and show the summary below it, you would select from the menu:

150. Which is not a valid file extension in which an Excel file can be saved?

151. What will be the result if the formula =B3&', '&A3 is applied on the given table?

152. Which among the following is not true regarding a calculated column?

153. Which among the following options displays Legend entries in the given picture?

154. Excel keeps the changed history of a workbook for ________ days by default

155. Which of the following statements are true regarding PowerPivot in Microsoft Excel 2010?

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

157. In the above given screenshot of a Microsoft Excel 2010 Worksheet, there are two columns B and D containing some integer data. Considering that cell D9 is assigned the formula: =SUM(D3:D7), which of the following statements is true?

158. In the given screenshot, the contents of the 'Name of User' column have been oriented at an angle. How is this done?

159. 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?

160. The following sequence, 1, 2, 3, etc., is an example of a(n) ____ series.

161. In the formula =if(a1=b1, c1, c2), the result will be c2 if ____.

162. You need to add a line chart showing a sales trends over the last 12 months and you have only a little space to work with. How can you convey the required information within a single cell?

163. A cell contains the value 7.877 and you want it to display as 7.9. How can you accomplish this?

164. You select cell A1, hover the pointer over the cell border to reveal the move icon, then drag the cell to a new location. Which ribbon commands achieve the same result?

165. How do you remove only the conditional formatting from a cell and leave all other formatting intact?

166. If a range name is used in a formula and the name is deleted, what happens to the formula?

167. You want to restrict the values entered in a cell to a specified set, such as Hop, Skip, Jump. Which type of data validation should you use?

168. You want to find the second-largest invoice in a column containing all the invoices in a given month. What function would you use?

169. Cell D1 contains the value 7.877. You want cell D1 to display the value as 7.9 but keep the original number in calculations. How can yu=ou accomplish this?

170. A colleague shared an excel file with you, and you want to display a worksheet that is hidden in it. How you can do that?

Excel MCQs | Topic-wise

MCQ on Basic Excel

General Excel MCQs