Google News
logo
Microsoft Excel - Quiz(MCQ)
A circular reference is _________
A)
Geometric modeling tool
B)
A cell that points to a drawing object
C)
Always erroneous
D)
A formula that either directly or indirectly depends on itself

Correct Answer : Option (D) :   A formula that either directly or indirectly depends on itself


Explanation : 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.

Advertisement