What is the key difference between a relative and an absolute cell reference in Excel?
- Relative changes with copy, absolute remains fixed
- Absolute changes with copy, relative remains fixed
- Relative is used only for text, absolute for numbers
- Absolute is used only for formulas, relatives for data
