Level 1Formulas & ReferencesPractice, 3 min
Lock a cell with $
The task
C2 already holds
=B2*(1+$E$2). In C3, write the same calculation for the rug, keeping the tax rate locked with $E$2.The data
The starting sheet. Cells outlined in green are where your formulas go.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Product | Price | With tax | Tax rate | |
| 2 | Lamp | 40 | =B2*(1+$E$2) | 0.08 | |
| 3 | Rug | 120 |