Question

differentiate between mixed and absolute referencing by giving suitable example in ooo calc

Answer 1

relative and absolute references behave differently when copied and filled to other cells.
...relative reference changes when formula is copied to the other cell.
...absolute references on the other hand, remains constant no matters where they are copied.
...in relative references....for example if we copy the formula =A1+B1from row 1 to row 2 the formula become A2+B2
in absolute references the columns and rows don't change when copied