Understand and use cell references

Understand and use cell references

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.

Level:
Length:
Rating:
Applies to:
File Size:

Inside this course:

Cell references (1:44)
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.

Copying formulas (3:13)
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.

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


More courses available at Microsoft Office Training.