Currency conversion with absolute references
BeginnerWhen one value needs to stay the same across many formulas, an absolute reference keeps it anchored. This is useful in real work when a team applies one exchange rate, tax rate, or markup across a whole list of prices.
In this exercise, you'll convert product prices from USD to EUR using the single exchange rate stored in cell B1.
What you need to do
- Look at cell B1, which contains the USD to EUR exchange rate.
- Click cell C4, the first empty cell in the Price (EUR) column.
- Enter a formula that uses the USD price from the same row and the exchange rate in B1.
- Make the reference to B1 absolute so it stays fixed when you copy the formula down the column.
- Press Enter.
- Copy the formula down through C9.
As you fill the column, each row should use that row's USD price, but the exchange rate should keep pointing to the same cell.
For example, an absolute reference looks like $A$1.
Need some help?
Hint 1
If copying the formula changes which exchange-rate cell is used, the rate reference is still relative. That is the part that needs dollar signs.
Hint 2
Your formula should use two kinds of references at once: the USD price should change as you move down the rows, but the exchange-rate cell should stay locked on B1 the whole time.
Currency conversion with absolute references
BeginnerWhen one value needs to stay the same across many formulas, an absolute reference keeps it anchored. This is useful in real work when a team applies one exchange rate, tax rate, or markup across a whole list of prices.
In this exercise, you'll convert product prices from USD to EUR using the single exchange rate stored in cell B1.
What you need to do
- Look at cell B1, which contains the USD to EUR exchange rate.
- Click cell C4, the first empty cell in the Price (EUR) column.
- Enter a formula that uses the USD price from the same row and the exchange rate in B1.
- Make the reference to B1 absolute so it stays fixed when you copy the formula down the column.
- Press Enter.
- Copy the formula down through C9.
As you fill the column, each row should use that row's USD price, but the exchange rate should keep pointing to the same cell.
For example, an absolute reference looks like $A$1.
Need some help?
Hint 1
If copying the formula changes which exchange-rate cell is used, the rate reference is still relative. That is the part that needs dollar signs.
Hint 2
Your formula should use two kinds of references at once: the USD price should change as you move down the rows, but the exchange-rate cell should stay locked on B1 the whole time.