CBSE Class 9 Computer Applications
Question 42 of 53
Spreadsheet Tool : OO Calc I — Question 14
Back to all questions 14
Question Question 15
Differentiate between mixed referencing and absolute referencing by giving suitable examples.
| Mixed referencing | Absolute 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$6 is a mixed reference where column is relative and row is absolute. $C6 is also a mixed reference but here column is absolute and row is relative. | For example, $C$6 is an absolute reference where both row and column are fixed. |