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

Home

Answer

View

Answer

Insert

Question 2

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

Accepted Answer

.xlsm

Answer

.xlsx

Answer

.xlsb

Answer

.xltm

Question 3

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

Accepted Answer

1

Answer

3

Answer

5

Answer

10

Question 4

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

Accepted Answer

Matrix Chart

Answer

Waterfall Chart

Answer

Treemap Chart

Answer

Sunburst Chart

Question 5

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

Accepted Answer

Enters edit mode for the active cell

Answer

Opens the Save As dialog

Answer

Copies the cell content

Answer

Inserts a new row

Question 6

Which feature allows you to restrict what values users can enter into specific cells?

Accepted Answer

Data Validation

Answer

Cell Protection

Answer

Input Mask

Answer

Format Cells