MS EXCEL MCQ Questions and Answers Quiz

81. Which of the following you can paste selectively using Paste Special command ?

  1. Formats
  2. Validation
  3. Formulas
  4. All of the above

82. You can check the conditions against …………………………….when applying conditional formatting

  1. Formula
  2. Cell value
  3. Both (A) and (B)
  4. None of the above

83. A features that displays only the data in column (s) according to specified criteria

  1. Formula
  2. Sorting
  3. Filtering
  4. Pivot

84. What do you mean by a Workspace?

  1. Group of Columns
  2. Group of Worksheets
  3. Group of Rows
  4. Group of Workbooks

85. Which of the following function will use to find the highest number in a series of number ?

  1. HIGH (B1:B3)
  2. MAXIMUM (B1:B3)
  3. MAX(B1:B3)
  4. None of the above

86. How to restrict to run a macro automatically when starting Microsoft Excel?

  1. Hold down the SHIFT key during startup
  2. Hold down the CTRL key during startup
  3. Hold down the ESC key during startup
  4. Hold down the ALT key during startup

87. Which of the following is not an option of the spelling dialog box?

  1. Ignore
  2. Ignore all
  3. Edit
  4. Change

88. The spelling dialog box can be involved by choosing spelling from ……………………

  1. insert
  2. file
  3. tools
  4. view

89. You accidentally erased a record in the sheet. What command can be used to restore it immediately?

  1. Insert
  2. Copy
  3. Undo
  4. Replace

90. The active cell:

  1. is defined by a bold border around the cell.
  2. Receives the data the user enters.
  3. It is the formula bar.
  4. Only A and B.

MCQ Multiple Choice Questions and Answers on MS EXCEL

MS EXCEL Trivia Questions and Answers PDF

MS EXCEL Question and Answer

Spreading Knowledge Across the World

USA - United States of America  Canada  United Kingdom  Australia  New Zealand  South America  Brazil  Portugal  Netherland  South Africa  Ethiopia  Zambia  Singapore  Malaysia  India  China  UAE - Saudi Arabia  Qatar  Oman  Kuwait  Bahrain  Dubai  Israil  England  Scotland  Norway  Ireland  Denmark  France  Spain  Poland  and many more....