Skip to content

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

Lesson 7/7

Fixed references with $

Exercise 1 of 4

What do the $ signs in $B$1 do?

About this lesson

A $ sign keeps a reference fixed when you copy a formula. Learn what $B$1 means and when a fixed reference is what you need.

In this lesson

  1. What do the $ signs in $B$1 do?
  2. The exchange rate is in B1. In C4, convert the lamp price to euros: its dollar price times the rate. Write it so the formula could be copied down to the chair and desk.
  3. In C2, work out North's share of the total: its sales divided by the total in B6. Write it so it could be copied down.
  4. C4 holds =A4*$B$1. You copy it to C5. What does C5 hold?

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.