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]