Microsoft Excel MCQ Questions and Answers 2

Question 1

Which tab on the Excel ribbon contains the Sort and Filter commands?

Accepted Answer

Data

Answer

The Data tab contains Sort and Filter commands along with other data management tools like Data Validation, Text to Columns, and Remove Duplicates.

Question 2

What file extension does a macro-enabled Excel workbook use?

Accepted Answer

.xlsm

Answer

The .xlsm extension indicates a macro-enabled workbook that can contain VBA macros, while .xlsx files cannot store macros.

Question 3

How many worksheets does a new Excel workbook contain by default in Excel 2016 and later?

Accepted Answer

1

Answer

Starting with Excel 2013, new workbooks default to 1 worksheet. Earlier versions defaulted to 3 worksheets.

Question 4

Which of the following is NOT a valid Excel chart type?

Accepted Answer

Matrix Chart

Answer

Matrix Chart is not a built-in Excel chart type. Waterfall, Treemap, and Sunburst charts were all added in Excel 2016.

Question 5

What does pressing F2 do when a cell is selected in Excel?

Accepted Answer

Enters edit mode for the active cell

Answer

F2 puts the active cell into edit mode, placing the cursor in the cell so you can modify its contents without overwriting them.

Excel Practice Test