MCQs about Microsoft Excel


MS Excel Question answers (MCQs) : MS Excel is a spreadsheet software and is part of widely used MS Office. MS Excel MCQs are very important MCQs in Computer section. Here you will find a great collection of MCQs. Most of the Questions are applicable to all versions (MS Excel 20097-2003, MS Excel 2007, MS Excel 2010) of Excel.


MCQs about Microsoft Excel

Select one option out of four given options

  1. First spreadsheet program for personal computer was





  2. See answer
    The correct answer is (3)

    https://theinfobia.com

  3. Microsoft introduced a spreadsheet program called ______________ in 1982





  4. See answer
    The correct answer is (3)

    https://theinfobia.com

  5. Lotus 1-2-3 was a/an ________________





  6. See answer
    The correct answer is (2)

    https://theinfobia.com

  7. The version of Excel 1.0 was released in 1985 for only ________





  8. See answer
    The correct answer is (3)

    https://theinfobia.com

  9. First version of MS Excel to run on Microsoft new windows operating system was released in





  10. See answer
    The correct answer is (3)

    https://theinfobia.com

  11. Which of the following is the first version of MS Excel to run on Microsoft new windows





  12. See answer
    The correct answer is (2)

    https://theinfobia.com

  13. First 32-bit version of Microsoft Excel was





  14. See answer
    The correct answer is (1)

    https://theinfobia.com

  15. MS Excel is used to _____________ data





  16. See answer
    The correct answer is (1)

    https://theinfobia.com

  17. A computer application program that displays data arranged in rows and columns is called





  18. See answer
    The correct answer is (1)

    https://theinfobia.com

  19. In MS Excel we cannot edit the contents of the cell by





  20. See answer
    The correct answer is (1)

    https://theinfobia.com

  21. In MS Excel which function is automatically total a column or row of values





  22. See answer
    The correct answer is (3)

    https://theinfobia.com

  23. Which of the following way cannot be used to link excel work sheet data to a Word document





  24. See answer
    The correct answer is (4)

    https://theinfobia.com

  25. In MS Excel if a numeric value starts with the _______________ then this value can be treated as a label





  26. See answer
    The correct answer is (4)

    https://theinfobia.com

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





  28. See answer
    The correct answer is (1)

    https://theinfobia.com

  29. The ____________ option is used to show a specific row or column on every printed page





  30. See answer
    The correct answer is (1)

    https://theinfobia.com

  31. A collection of related worksheets is called





  32. See answer
    The correct answer is (1)

    https://theinfobia.com

  33. The shortcut key for undo is





  34. See answer
    The correct answer is (3)

    https://theinfobia.com

  35. You can activate a cell by





  36. See answer
    The correct answer is (4)

    https://theinfobia.com

  37. ___________ users can open the MS Excel 2016 file at the same time





  38. See answer
    The correct answer is (4)

    https://theinfobia.com

  39. illustration group is in which tab





  40. See answer
    The correct answer is (1)

    https://theinfobia.com

  41. Which of the following can be renamed





  42. See answer
    The correct answer is (4)

    https://theinfobia.com

  43. Which of the following options are present in the illustration group under the insert tab





  44. See answer
    The correct answer is (1)

    https://theinfobia.com

  45. In MS Excel to create a formula you can use





  46. See answer
    The correct answer is (4)

    https://theinfobia.com

  47. Which of the following is not a function in Microsoft Excel





  48. See answer
    The correct answer is (4)

    https://theinfobia.com

  49. When an excel Workbook is linked to a word document





  50. See answer
    The correct answer is (4)

    https://theinfobia.com

  51. Which of the following Excel Feature Allows Users To evaluate values and return a result





  52. See answer
    The correct answer is (1)

    https://theinfobia.com

  53. In MS Excel 2016, zoom level of a page can only be





  54. See answer
    The correct answer is (3)

    https://theinfobia.com

  55. Which of the following methods cannot be used to enter data in MS Excel cell





  56. See answer
    The correct answer is (3)

    https://theinfobia.com

  57. In Microsoft Excel the Intersection of columns and rows is called a





  58. See answer
    The correct answer is (3)

    https://theinfobia.com

  59. When typing character search criteria Excel matches field based on





  60. See answer
    The correct answer is (3)

    https://theinfobia.com

  61. For combining two or more cells we use





  62. See answer
    The correct answer is (2)

    https://theinfobia.com

  63. To fix values in an excel we use





  64. See answer
    The correct answer is (1)

    https://theinfobia.com

  65. Rows and columns intersect at





  66. See answer
    The correct answer is (2)

    https://theinfobia.com

  67. Which alignment choice spreads the data across the width of the cell





  68. See answer
    The correct answer is (2)

    https://theinfobia.com

  69. In Microsoft Excel, the file you create and edit is called





  70. See answer
    The correct answer is (4)

    https://theinfobia.com

  71. There are two different ways to insert content from one application into another i.e. embedding and ___________





  72. See answer
    The correct answer is (3)

    https://theinfobia.com

  73. The function is a __________ which can calculate the values given in a specific order





  74. See answer
    The correct answer is (2)

    https://theinfobia.com

  75. Which command can be set to prohibit or allow a cell entry





  76. See answer
    The correct answer is (2)

    https://theinfobia.com

  77. In MS Excel 2016, one has to go to ______________ option for setting or clearing print area





  78. See answer
    The correct answer is (2)

    https://theinfobia.com

  79. Formatting a cell in currency, you can specify





  80. See answer
    The correct answer is (3)

    https://theinfobia.com

  81. To open a template in Word First go to file and





  82. See answer
    The correct answer is (1)

    https://theinfobia.com

  83. To move between the worksheets in a workbook in MS Excel, We can use which of the following shortcut





  84. See answer
    The correct answer is (4)

    https://theinfobia.com

  85. To change line height to 1.5 which is the following correct command





  86. See answer
    The correct answer is (4)

    https://theinfobia.com

  87. The contents of two or more consecutive cells, could be put together using





  88. See answer
    The correct answer is (3)

    https://theinfobia.com

  89. In MS Excel on the insert tab includes





  90. See answer
    The correct answer is (1)

    https://theinfobia.com

  91. Readymade templates are available under ___________ tab in now option





  92. See answer
    The correct answer is (2)

    https://theinfobia.com

  93. The distinguishing feature of a spreadsheet program is that it allows you to





  94. See answer
    The correct answer is (2)

    https://theinfobia.com

  95. maximum number of rows in MS Excel 2016 worksheet is





  96. See answer
    The correct answer is (3)

    https://theinfobia.com

  97. When you link data maintained in an excel workbook to a word document





  98. See answer
    The correct answer is (2)

    https://theinfobia.com

  99. In MS Excel 2016, = Now () is used





  100. See answer
    The correct answer is (4)

    https://theinfobia.com

  101. To insert blank embedded word object in excel





  102. See answer
    The correct answer is (1)

    https://theinfobia.com

  103. Comments put in cells are called





  104. See answer
    The correct answer is (2)

    https://theinfobia.com

  105. How many columns are there in MS Excel 2016





  106. See answer
    The correct answer is (2)

    https://theinfobia.com

  107. MS Excel uses the _________ function when creating a data table





  108. See answer
    The correct answer is (4)

    https://theinfobia.com

  109. A cell is defined as





  110. See answer
    The correct answer is (1)

    https://theinfobia.com

  111. Cell entry "July 16, 1982" will be considered a _____________ by excel sheet





  112. See answer
    The correct answer is (4)

    https://theinfobia.com

  113. In MS Excel 2016 we can go to cell A1 by pressing





  114. See answer
    The correct answer is (1)

    https://theinfobia.com

  115. The thin black cross shaped pointer in MS Excel is used to





  116. See answer
    The correct answer is (1)

    https://theinfobia.com

  117. When creating a new table which method can be used to choose fields from standard





  118. See answer
    The correct answer is (2)

    https://theinfobia.com

  119. Columns in MS Excel are labelled as





  120. See answer
    The correct answer is (2)

    https://theinfobia.com

  121. Which of the following is not on of excel "what-if" function





  122. See answer
    The correct answer is (4)

    https://theinfobia.com

  123. In order to tell excel that we are entering a formula in cell, we must begin with an operator such as





  124. See answer
    The correct answer is (3)

    https://theinfobia.com

  125. Working area of MS Excel is called





  126. See answer
    The correct answer is (1)

    https://theinfobia.com

  127. Getting data from a cell located in a different sheet is called





  128. See answer
    The correct answer is (2)

    https://theinfobia.com

  129. In Excel you can sort data in





  130. See answer
    The correct answer is (3)

    https://theinfobia.com

  131. Term chart wizard data in MS Excel refer to





  132. See answer
    The correct answer is (2)

    https://theinfobia.com

  133. In MS Excel Undo option will _________________ last action





  134. See answer
    The correct answer is (3)

    https://theinfobia.com

  135. In excel the rows of the table correspond to





  136. See answer
    The correct answer is (3)

    https://theinfobia.com

  137. The columns of a table corresponds to





  138. See answer
    The correct answer is (3)

    https://theinfobia.com

  139. You cannot link excel worksheet data to a word document





  140. See answer
    The correct answer is (4)

    https://theinfobia.com

  141. Where does display the address of the active cell





  142. See answer
    The correct answer is (1)

    https://theinfobia.com

  143. How to duplicate values in cell range in excel 2016





  144. See answer
    The correct answer is (1)

    https://theinfobia.com

  145. To prevent invalid data computer shows





  146. See answer
    The correct answer is (2)

    https://theinfobia.com

  147. Cells in MS Excel can be uniquely identified by





  148. See answer
    The correct answer is (1)

    https://theinfobia.com

  149. In MS Excel you can use the horizontal and vertical scroll bars to





  150. See answer
    The correct answer is (2)

    https://theinfobia.com

  151. _______________ function calculates the largest value in a set of numbers





  152. See answer
    The correct answer is (4)

    https://theinfobia.com

  153. MS Excel will not be able to calculate which of the following formula





  154. See answer
    The correct answer is (1)

    https://theinfobia.com

  155. Which key is used to minimize excel worksheet





  156. See answer
    The correct answer is (3)

    https://theinfobia.com

All Answers

  1. [3]
  2. [3]
  3. [2]
  4. [3]
  5. [3]
  6. [2]
  7. [1]
  8. [1]
  9. [1]
  10. [1]
  11. [3]
  12. [4]
  13. [4]
  14. [1]
  15. [1]
  16. [1]
  17. [3]
  18. [4]
  19. [4]
  20. [1]
  21. [4]
  22. [1]
  23. [4]
  24. [4]
  25. [4]
  26. [1]
  27. [3]
  28. [3]
  29. [3]
  30. [3]
  31. [2]
  32. [1]
  33. [2]
  34. [2]
  35. [4]
  36. [3]
  37. [2]
  38. [2]
  39. [2]
  40. [3]
  41. [1]
  42. [4]
  43. [4]
  44. [3]
  45. [1]
  46. [2]
  47. [2]
  48. [3]
  49. [2]
  50. [4]
  51. [1]
  52. [2]
  53. [2]
  54. [4]
  55. [1]
  56. [4]
  57. [1]
  58. [1]
  59. [2]
  60. [2]
  61. [4]
  62. [3]
  63. [1]
  64. [2]
  65. [3]
  66. [2]
  67. [3]
  68. [3]
  69. [3]
  70. [4]
  71. [1]
  72. [1]
  73. [2]
  74. [1]
  75. [2]
  76. [4]
  77. [1]
  78. [3]