ICSE Class 8 Computer Studies Question 4 of 6

Spreadsheet - Formulas and Functions — Question 4

Back to all questions
4
Question

Question 4

Explain circular reference with an example.

Answer

A circular reference occurs when a formula in a cell refers to its own cell value directly or indirectly. For example, if you enter the formula =A1+A2*3 in cell A2, you are making the formula to refer to its own cell value, which creates a circular reference.