Question

4.
Explain circular reference with an example.​

Answer 1

Answer:

A formula in a cell that directly or indirectly refers to its own cell is called a circular reference. ... For example, the formula in cell A3 below directly refers to its own cell. This is not possible. Note: Excel returns a 0 if you accept this circular reference.

Answer 2

Answer:

Circular references also occur in spreadsheets when two cells require each other's result. For example, if the value in Cell A1 is to be obtained by adding 5 to the value in Cell B1, and the value in Cell B1 is to be obtained by adding 3 to the value in Cell A1, no values can be computed.