Absolute and relative references
IntermediateBeginner
12 questions, about 19 minutes
Why your formula breaks when you fill it down, and how $ fixes that.
What we'll do
- How references move
- Fixing cells with $
- Using F4
What you'll use
SUM
How it works
In an example you watch and don't need to fill anything in. You answer a question yourself. If it goes wrong, you get a tip, then a hint and finally the solution.
2examplesYou watch
12questionsYou do it yourself