What error message is displayed in MS Excel when a cell contains a numeric formula that references its own cell address directly or indirectly? MCQ with Answer and Explanation
What error message is displayed in MS Excel when a cell contains a numeric formula that references its own cell address directly or indirectly?
A. #REF!
B. #NAME?
C. Circular Reference Warning
D. #VALUE!
Answer: Option C
Solution (By JKSSB Mock Tests)
When a formula references its own cell address, it creates a 'Circular Reference', prompting an alert window because the formula recalculates infinitely.
No comments yet. Be the first to start the discussion!