A(n) ..... circular reference occurs when a formula in a cell refers to another cell or cells that include a formula that refers back to the original cell.

ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL

Please wait while the activity loads.
If this activity does not load, try refreshing your browser. Also, this page requires javascript. Please visit using a browser with javascript enabled.

If loading fails, click here to try again

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]

A(n) ____ circular reference occurs when a formula in a cell refers to another cell or cells that include a formula that refers back to the original cell.

A	contiguous
B	indexed
C	direct
D	indirect

Explanation:

Detailed explanation-1: -An indirect circular reference occurs when a formula in a cell refers to another cell or cells that include a formula that refers back to the original cell.

Detailed explanation-2: -A circular reference refers to a formula, that visits its own or another cell more than once in its chain of calculations, creating an infinite loop which slows down your spreadsheet significantly.

Detailed explanation-3: -What are circular references in Excel? Circular references in Excel are situations where a formula refers to its own cell or refers to a cell that’s dependent on the formula’s result. While a circular reference usually returns a value of zero, it may also return the cell’s last successful calculation.

Detailed explanation-4: -A circular reference occurs when a formula refers to its own cell either directly or indirectly.

Detailed explanation-5: -An indirect circular reference occurs when a formula indirectly refers to the same cell as part of the execution of the formula.

There is 1 question to complete.

FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL