Spreadsheet Tool : OO Calc I — Question 13

Cell referencing in OOo Calc are of three types :

1. Relative referencing — Cell referencing in which the cells are referred by their relative position in the worksheet — relative to a particular cell is known as Relative referencing. For example, A23, BZ15 etc.
2. Absolute referencing — Cell referencing in which the cells are referred by their fixed position (absolute position) in the worksheet is known as Absolute referencing. For example, $A$23, $Z$15 etc.
3. Mixed Referencing — Combination of relative and absolute referencing is called mixed referencing. For example, A$23, $Z15 etc.