Be able to create formulae using cell references
Topic: 20 Spreadsheets
Objective: Be able to create formulae using cell references
In a spreadsheet, a cell reference is like a name tag that tells the computer which cell you want to use in a calculation. Think of it as giving a friend a note that says, “Hey, grab the number from the box next to the red apple!” 📊
What is a Cell Reference?
A cell reference is written as a letter (column) followed by a number (row). For example, A1 means column A, row 1. You can also use absolute references like $A$1 which never change when you copy a formula.
Basic Formula Examples
- Sum of two cells:
=A1 + B1➕ - Average of a range:
=AVERAGE(A1:A5)📈 - Reference to another sheet:
=Sheet2!C3🔗 - Absolute reference:
=$A$1 * 2📌
Using Cell References in Practice
| Cell | Content | Formula |
|---|---|---|
| A1 | 5 | — |
| B1 | 10 | — |
| C1 | — | =A1 + B1 |
| D1 | — | =AVERAGE(A1:B1) |
Exam Tips Box
🔍 Key Points to Remember
- Use = to start every formula.
- Absolute references ($) keep the cell fixed when copying.
- Check that ranges (e.g., A1:A5) are correct; a typo can give wrong results.
- When referencing another sheet, include the sheet name followed by an exclamation mark (!).
- Always double‑check that your formula returns the expected result before submitting.
Good luck! Remember, practice makes perfect. 🚀
Revision
Log in to practice.
3 views
0 suggestions