Match List-I (Error message in MS Excel) with List-II (Error description) and choose the correct answer from the options given below.

List I

i.#####

ii.#VALUE!

iii.#REF!

iv.#DIV/0

List II

a.The formula contains a cell reference pointing to an invalid cell

b.Dividing a number by a cell that points to a blank cell

c.There is text in place of numbers in the arithmetic formula

d.The cell contains a number too large for the result to be displayed

Ai-a, ii-b, iii-c, iv-d

Bi-d, ii-c, iii-a, iv-b ✓ Correct

Ci-c, ii-d, iii-a, iv-b

Di-b, ii-a, iii-d, iv-c

Correct answer: (B) i-d, ii-c, iii-a, iv-b

Explanation

The ##### display appears when a cell holds a number too large for the column width to show.

A #VALUE! error arises when text sits where the formula expects a number.

A #REF! error means the formula points to an invalid or deleted cell reference.

A #DIV/0 error comes from dividing by zero or by a blank cell.

Each message signals a specific cause rather than a general failure.

Widening the column clears ##### without changing the underlying value.

Want more like this? Create a free account to practise a full test, track your progress, and get spaced-repetition review.