Question

differentiate absolute and relative cell addresing

Answer 1

Relative References. No dollar signs at all! If you copy this bad boy from place to place, the formula will move with it.

Absolutely Absolute. All dollar signs,

Absolute Columns.

Absolute Rows. Conversely, you can make the rows but not the columns absolute.