ABSOLUTE and RELATIVE CELL REFERENCE in GOOGLE SHEETS

RELATIVE - When dragging functions, the location of the input cells change relative to the location of the function. ABSOLUTE - When dragging functions, the reference cell does NOT move as follows... $A$1: Column and Row do NOT change when copied. A$1: Row does NOT change when copied. $A1: Column does NOT change when copied. *** The $ placed before the letter or number of the cell creates an absolute reference.