Ó 2001 Prentice Hall
6.7
Spreadsheet Features
•Formulas can be relative, so they refer to different cells when they are copied
•Or absolute, so the formula references never change when they are copied
When the formula in column B is copied to column C, it changes relative to the new column.