What type of special validation error alert is thrown by MS Excel if a formula attempts to divide a numeric value by zero or references an unpopulated empty cell as a divisor? MCQ with Answer and Explanation
What type of special validation error alert is thrown by MS Excel if a formula attempts to divide a numeric value by zero or references an unpopulated empty cell as a divisor?
A. #REF!
B. #DIV/0!
C. #VALUE!
D. #NUM!
Answer: Option B
Solution (By JKSSB Mock Tests)
The #DIV/0! error is thrown by Excel whenever a formula attempts to divide a number by zero or by a cell that contains no value.
No comments yet. Be the first to start the discussion!