Microsoft Excel Excel MCQ 3

Question 1

Which Excel feature allows you to automatically fill a series of data (e.g., Jan, Feb, Mar) by dragging?

Accepted Answer

AutoFill

Answer

AutoFill recognizes patterns and extends a series when you drag the fill handle.

Question 2

What is the purpose of the IFERROR function?

Accepted Answer

Returns a specified value if a formula produces an error

Answer

IFERROR evaluates a formula and returns a custom value instead of displaying an error message.

Question 3

Which Excel function combines text from multiple cells into one?

Accepted Answer

CONCATENATE

Answer

CONCATENATE (or & operator / CONCAT in newer versions) joins text strings from multiple cells.

Question 4

What does pressing Ctrl + Z do in Excel?

Accepted Answer

Undo the last action

Answer

Ctrl + Z undoes the most recent action in Excel.

Question 5

Which function returns the largest value in a set of values?

Accepted Answer

MAX

Answer

MAX returns the maximum (largest) value from a list of numbers or a range.

Excel Practice Test