Question

Write down the differences between Relative and mixed Reference
( Give 5 marks answer )

Answer 1

relative cell reference is a formula is based on the relative position of cell

contained in formula by default ,a spreadsheet reference is relative.

A mixed cell reference to a cell when you want to copy a part of it absolute and part relative