Skip to content

Lessons in your language are coming soon. Formulas already work in your Excel language.

Lesson 6/7

Use cell references

Exercise 1 of 3

Why is =B1*B2 better than typing =38*15?

About this lesson

Point formulas at cells instead of typing the numbers, so the result updates when the data changes.

In this lesson

  1. Why is =B1*B2 better than typing =38*15?
  2. Hours are in B1 and the hourly rate in B2. In B3, multiply them to get the pay. Use the cell addresses, not 38 and 15, so the pay updates when the hours change.
  3. Tape is in row 5. In D5, work out its total: the price times the quantity, using the cells in that row.

Use the arrow keys to move between cells; each cell is read out as you go. Type a formula and press Enter. The sheet is also available as a table below.

fx

Try it out: type a formula in any free cell or change a value. What you type on the sheet isn’t graded.