KwickClips Course Topics · 44 sec · free
What is a cell reference?
Short answer. A cell address used inside a formula.
Why not type the number?
Answers would not update.
Cell reference
| Cell address in a formula |
| =B2+C2 uses their values |
| Change B2, answer updates |
Remember
| Use addresses, not numbers |
| Answers update by themselves |
Why write B2 in a formula, not 450? That is a cell reference. It is a cell address in a formula. Equals B2 plus C2 uses their values. Change B2, and the answer updates. Remember. Use addresses, not numbers. Answers then update.
This clip is from the full lesson: Cell referencing — relative, mixed and absolute referencing — 6 minutes, with the tables, the quick answers and the whole lesson in text.
Useful for: CBSE Class 9 Information Technology (402)
More KwickClips from this lesson
Voice-over is AI-generated; the script is written and checked by Kajal Ma'am. Confirm anything you plan around against your official board document. We never ask for a password or an OTP.