One of the key things you’ll calculate in Excel are values in cells, the boxes you see in the grid of an Excel worksheet. Each cell is identified by its reference—the column letter and row number that intersect at the cell's location. For example, a cell in column D and row 5 is cell D5. When you use cell references in a formula, Excel calculates the answer automatically using the numbers in the referenced cells.

## Cell references

Watch this video to learn the basics. When you use cell references in a formula, Excel calculates the answer using the numbers in the referenced cells. When you change the value in a cell, the formula calculates the new result automatically. (1:44)

## Copying formulas

We just saw how to create a formula that adds two cells. Now let’s copy the formula down the column so it adds the other pairs of cells. (3:13)

A brief reminder of the key points in this course summary.

More courses available at Microsoft Office Training.