What is a circular reference? How do you know if your workbook has a circular reference?
What will be an ideal response?
A circular reference is when a single formula references itself or multiple formulas reference each other. It means that the formulas are both precedents and dependents of each other, which makes it impossible to calculate. When you open a workbook with a circular reference, Excel shows a warning dialog box as well as a message in the status bar with the words Circular Reference and the cell reference where it is located.
Computer Science & Information Technology
You might also like to view...
The prefix ____ is used when naming a RequiredFieldValidator object on a web form
A. rfv B. fld C. rfl D. flv
Computer Science & Information Technology
The third line of a header in multiple page letters and memos contain the ____________________ .
Fill in the blank(s) with the appropriate word(s).
Computer Science & Information Technology