Match List - I with List - II.
|
List - I |
List - II |
||
|
(A) |
##### |
(I) |
When the formula contains a cell reference that is pointing to an invalid cell |
|
(B) |
#VALUE! |
(II) |
When you divide a number by a cell that points to an empty cell |
|
(C) |
#REF! |
(III) |
When the arithmetic formula contains text instead of a number |
|
(D) |
#DIV/O |
(IV) |
When the cell contains a number that is too wide for the result to be displayed |
Choose the correct answer from the options given below:
1
(A) - (III), (B) - (IV), (C) - (II), (D) - (I)
2
(A) - (IV), (B) - (III), (C) - (I), (D) - (II)
3
(A) - (I), (B) - (IV), (C) - (II), (D) - (III)
4
(A) - (IV), (B) - (I), (C) - (III), (D) - (II)