Vidyalelo
Computer Fundamentals · Q142

Microsoft Excel

Computer Related · Computer Fundamentals · question 142

Q142

A circular reference is

A.
Geometric modeling tool
B.
A cell that points to a drawing object
C.
A formula that either directly or indirectly depends on itself
Answer
D.
Always erroneous

Answer: Option C

Solution

Answer: Option C
Solution:
A circular reference occurs when a formula directly or indirectly refers to its own cell. This causes the formula to use its result in the calculation, which can create errors.