A basic sum calculation using relative references might be entered as "=SUM (C4:C6)" in cell C7 to add the numbers in the three cells to the left of C7. Copying this formula to cell D7 with the ...

Because it’s easier to copy formulas than re-enter formulas, use the Absolute/Relative Reference function key F4 to hardcode the B (absolute) in this formula so it never changes when it’s copied.

Cells in Excel are referred to using relative or absolute references. A formula with relative references changes when the cell's position does.