In order to Correct a #DIV/0! Error, the following steps are used. Arrange them in proper order.
(A) Enter a value other than zero in the cell used as a divisor.
(B) Prevent the error value from displaying by using the IF worksheet function.
(C) Change the cell reference to another cell.
(D) Enter the value #N/A into the cell referenced as the divisor, which changes the result of the formula to #N/A from #DIV/0!
Choose the correct answer from the options given below:
Answer & explanation
Correct answer: option 2
The correct answer is Option (2) → (C), (A), (D), (B)
The steps to correct a #DIV/0! error, in the order they are given:
(C) Change the cell reference to another cell.
(A) Enter a value other than zero in the cell used as a divisor.
(D) Enter the value #N/A into the cell referenced as the divisor, which changes the result of the formula to #N/A from #DIV/0!
(B) Prevent the error value from displaying by using the IF worksheet function.
NCERT (2026-27 edition):
|
