FinanceTier 015 minbeginner

Relative and Absolute References

Convert a column of foreign-currency amounts using one exchange-rate cell, locked so it survives being filled down.

What you will learn

• Lock a cell reference with $ so it stays fixed when a formula is filled down
• Explain why an unlocked reference hunts for a different cell on every row instead of always reading the same rate
• Distinguish which part of a formula should move with each row and which part should not

Excel skills

Absolute References ($) · Cell References

The task

Convert each month's EUR amount to ZAR using the single exchange rate in B1. In C4, write a formula that multiplies the month's EUR amount by that rate, with the rate cell locked so the formula still reads B1 correctly after being filled down through C9.

You work in a real spreadsheet in your browser, and your answer is checked against hidden traps the moment you submit.

Try this lesson free