FORMULA FOUNDATIONS · ORIGINAL EXERCISE
The tax enchantment
Add 8% tax to the keyboard price in E2. Return the total price.
This quest practices Percentages using a fictional business dataset. Read the sheet below, then enter the interactive quest to write and check your formula.
| SKU | Item | Stock | Reorder at | Price |
|---|---|---|---|---|
| KB-01 | Keyboard | 24 | 10 | 60 |
| MS-02 | Mouse | 8 | 15 | 25 |
| MN-03 | Monitor | 6 | 8 | 250 |
| HC-04 | Headset | 18 | 12 | 80 |
| WB-05 | Webcam | 0 | 5 | 45 |
| DK-06 | Dock | 12 | 6 | 110 |
Hints to get you started
- 8% means 0.08.
- Multiply the original price by 1 plus the tax rate.
- Use E2*(1+8%) after the equals sign.
Show the worked solution
=E2*(1+8%)Multiplying by 1.08 keeps the original price and adds 8% of it.
Make the skill stick
After solving the task, explain what each reference does and why the formula answers the business question. Try the workbook download inside the quest to practice in your own spreadsheet app.
Explore the rest of this region →