Copying a formula to other cells automatically updates cell references to reflect the new location.You can use a similar technique when you add a formula to an Excel table column. If the
sale price and rate data were in an Excel table and you created the formula =B4*C4 in
cell D4, Excel would apply the formula to every other cell in the column. Because you
used relative references in the formula, the formulas would change to reflect each cell’s
distance from the original cell.Creating Formulas to Calculate Values 293