Explain what are the different methods of cell referencing in OOo Calc ?

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, $\text{\textdollar}$A$\text{\textdollar}$23, $\text{\textdollar}$Z$\text{\textdollar}$15 etc.
3. Mixed Referencing — Combination of relative and absolute referencing is called mixed referencing. For example, A$\text{\textdollar}$23, $\text{\textdollar}$Z15 etc.