Microsoft Excel Excel MCQ 4

Question 1

What does a circular reference in Excel mean?

Accepted Answer

A formula that directly or indirectly refers to its own cell

Answer

A circular reference occurs when a formula refers back to its own cell, creating an endless calculation loop.

Question 2

Which function would you use to look up a value in the first column of a table and return a value from another column?

Accepted Answer

VLOOKUP

Answer

VLOOKUP searches vertically in the first column of a table and returns a value from a specified column.

Question 3

What is the default file extension for Excel workbooks saved in modern Excel versions?

Accepted Answer

.xlsx

Answer

.xlsx is the default Open XML format for Excel workbooks introduced in Excel 2007.

Question 4

Which Excel feature highlights cells based on their values using color scales or icons?

Accepted Answer

Conditional Formatting

Answer

Conditional Formatting applies visual formatting rules to cells based on their content or value.

Question 5

What does the AVERAGE function do when a cell in its range contains text?

Accepted Answer

Ignores the text cell

Answer

AVERAGE ignores text values and blank cells, calculating only from numeric values in the range.

Excel Practice Test