Question

which type of reference is represented by the formula '=A1 + $A$2'​

Answer 1

Cell references typed in as A1, B4, etc. are relative references (unless they refer to cells outside the worksheet). When you copy or fill a formula containing a relative reference, the row numbers and column letters change, reflecting the same offset or relation that was in the original cell.24-Jul-2018