Question

The value in cell a1 of a spreadsheet is needed to compute the value in cell e3. the value in cell e3 is needed to compute the value in cell e10. the value in cell e10 is needed to compute the value in cell a1. this spreadsheet contains a __________ reference.

Answer 1

This spreadsheet contains a circular reference. A circular reference occurs in Excel when: A formula contains a cell reference to the cell containing the formula itself. An example of this type of circular reference is shown in the image above where the formula in cell C1 contains a reference to that cell in the formula: = A1 + A2 + A3 + C1.