What type of special validation error alert is thrown by MS Excel if a formula includes an invalid numeric argument or out-of-bounds parameter, such as finding the square root of a negative number via =SQRT(-9)? MCQ with Answer and Explanation
What type of special validation error alert is thrown by MS Excel if a formula includes an invalid numeric argument or out-of-bounds parameter, such as finding the square root of a negative number via =SQRT(-9)?
A. #DIV/0!
B. #NAME?
C. #NUM!
D. #VALUE!
Answer: Option C
Solution (By JKSSB Mock Tests)
The #NUM! error indicates a problem with a number in a formula, such as an argument that falls outside a function's supported domain (e.g., performing a square root on a negative number).
Explanation:
Transitions control the cinematic visual effects that execute during movement between slides, while Animations control motions inside a single slide.
No comments yet. Be the first to start the discussion!