DATABASE FUNDAMENTALS
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Geometric modeling tool
|
|
|
A cell that points to a drawing object
|
|
|
A formula that either directly or indirectly depends on itself
|
|
|
Always erroneous
|
Detailed explanation-1: -A circular reference occurs when a formula directly or indirectly refers to its own cell. This causes the formula to use its result in the calculation, which can create errors.
Detailed explanation-2: -A circular reference is just a formula that depends on its own value. A circular reference is created if you enter a formula into a cell that links directly or indirectly to itself. There should not be any circular references in your workbooks unless you specifically want them to be there.
Detailed explanation-3: -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-4: -An indirect circular reference occurs when a formula indirectly refers to the same cell as part of the execution of the formula. Squared numbers in diagonal. In the above example, we consecutively square the numbers in the diagonal.
Detailed explanation-5: -You can move between cells in a circular reference by double-clicking the tracer arrow. The arrow indicates the cell that affects the value of the currently selected cell. You show the tracer arrow by clicking Formulas, and then click either Trace Precedents or Trace Dependents.