KnowledgeBoat Logo
|

Computer Applications

Differentiate between mixed referencing and absolute referencing by giving suitable examples.

OOo Calc

32 Likes

Answer

Mixed referencingAbsolute referencing
Mixed referencing fixes either the row or column while allowing the other to change.In absolute referencing, both the row and column references are fixed.
When a formula with mixed references is copied to another cell, the absolute part of the reference remains fixed while the relative part of the reference changes.When a formula with absolute references is copied to another cell, the references remain unchanged.
For example, C$\text{\textdollar}6 is a mixed reference where column is relative and row is absolute. $\text{\textdollar}C6 is also a mixed reference but here column is absolute and row is relative.For example, $\text{\textdollar}C$\text{\textdollar}6 is an absolute reference where both row and column are fixed.

Answered By

10 Likes

Related Questions