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