Address modes

When constructing spreadsheets using drag and drop techniques you need to be aware of the two difference address modes. Relative and absolute addressing. The following two examples will highlight the difference.