🎯 The Goal
I can write my own formulas using the equals sign (=) and math symbols (+, -, *, /) to make the spreadsheet calculate for me.
📖 The Walkthrough: The Magic Equals Sign
A spreadsheet is a “Super Calculator,” but it only works if you use the magic code. Every formula must start with an Equals Sign (=). If you don’t type =, the spreadsheet just thinks you are typing normal text.
The Math Symbols
On a computer, math symbols look a little different than in your notebook:
| Operation | Symbol | Example |
| Addition | + | =A1+B1 |
| Subtraction | - | =A1-B1 |
| Multiplication | * | =A1*B1 |
| Division | / | =A1/B1 |
📥 The Starter File
Download the “Tuck Shop Totals” spreadsheet below. You will see a list of snacks and how many were sold, but the “Total” column is empty!
✅ The Checklist: Your Task
Open the Tuck Shop file and follow these steps:
- Multiply: In cell D2, type the formula to multiply the Price by the Quantity.
- Hint: It should look something like
=B2*C2
- Hint: It should look something like
- The Fill Handle: Instead of typing the formula again, click the tiny blue square at the bottom-right of cell D2 and drag it down to the bottom of the list.
- Subtract: In the “Profit” column, subtract the “Cost to Make” from your “Total Income.”
- Example:
=D2-E2
- Example:
- Test it: Change the Quantity of one item. If your formulas are correct, the Total and Profit should change automatically!
🏆 Level Up! (Extension)
- The Grand Total: Can you find a way to add up the entire “Profit” column to see how much the Tuck Shop made in total?
- Tax Man: Create a new column that takes your profit and multiplies it by 0.2 to calculate 20% tax.
📤 Test Your Knowledge
Once you have completed the tasks click the button below to take the quiz for this skill.Remember to select Skill 3 in the first question !
🏁 Navigation
| ⇠ Previous: Skill 2 | Next Lesson: Skill 4 The “Big Four” Functions ➔ |