Computer science · University
Formulas and cell references · revision notes
An expression in a spreadsheet cell that calculates a result.
Key ideas and conditions
Formula
An expression in a spreadsheet cell that calculates a result.
Cell reference
An address identifying a worksheet cell.
Relative reference
A reference that adjusts when a formula is copied.
Absolute reference
A reference fixed to a location when copied, often marked with dollar signs.
Explain without looking
- Give a short example showing how Relative reference would be used in practice.
- Summarize why Absolute reference matters in the lesson “Formulas and cell references”.
Further reading and review references
These are reference links, not copied exercises, institutional endorsement or proof of independent review.
AI-assisted preview; independent educational review required. Level labels describe prerequisites, not accreditation or official curriculum alignment.