← My dashboard
SHEET 002
Prices with tax
Excel · Module 1 · $ absolute+75 XP
Professor Owl · Treasury
A cell that must not move.
The Academy shop publishes its prices with tax. The percentage lives in a single cell (G1) and every formula must use it.
Goal · cells C2:C6
In C2:C6 calculate the price with tax, always using cell G1.
Key facts
- Price with tax = Price × (1 + Tax)
- $G$1 doesn't change when copied
C2fx
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | Product | Price | With tax | Tax | 0.21 | ||
| 2 | Notebook | 3.5 | |||||
| 3 | Calculator | 24.9 | |||||
| 4 | Backpack | 39 | |||||
| 5 | Pens | 4.2 | |||||
| 6 | Ruler | 1.2 |
The cells with a dotted border are the ones you must fill in. Separate arguments with , or ;
🎯 Each marked cell has to be a formula that calculates the correct result.