Here’s a look at Excel cell references in a formula and how they compare with houses on your street.
Infographic_Excel_Relative_Absolute_References