Mixed reference and circular reference! Flashcards
1
Q
What is mixed cell reference a combination of?
A
Mixed cell reference is a combination of Relative and Absolute cell reference.
2
Q
What has to be fixed in mixed cell reference with example?
A
In mixed cell reference, either row or column has to be fixed.Example is =$A1+A$2
3
Q
When does a circular reference occur?
A
A circular reference occurs when a formula in a cell refers to its own cell directly or indirectly.
