MS EXCEL MCQ Questions and Answers Quiz

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

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

82. What do you mean by a Workspace?

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

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

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

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

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

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

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

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

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

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

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

88. The active cell:

  1. Receives the data the user enters.
  2. It is the formula bar.
  3. Only A and B.
  4. 4

89. What is the AutoComplete feature of Excel?

  1. It completes text entries that match an existing entry in the same column
  2. It completes text and numeric entries that match an existing entry in the same column
  3. It completes text entries that match an existing entry in the same worksheet
  4. 2

90. What does the NOW() function return?

  1. It returns the serial number of the current date
  2. It returns the serial number of the current time
  3. None of the above
  4. 4
Tags

MCQ Multiple Choice Questions and Answers on MS EXCEL

MS EXCEL Question and Answer