Exercises / Foundations · 8 of 12
Lock the tax rate with $
A $ in a reference stops it from moving when you copy the formula. $F$1 always points at F1. In Excel, F4 adds the $ signs for you while you edit a reference.
Your taskIn C2, work out the sales tax: the price in B2 times the tax rate in F1. The formula will be copied down to C7, and every row must use the rate in F1.
I'll check your formula on this sheet and on changed versions of it, so it has to work in general. Stuck? Ask for a hint, one step at a time.
Answer cell
Type in a cell, or double-click it to edit
| Row | A | B | C | D | E | F | G |
|---|---|---|---|---|---|---|---|
| 1 | Item | Price | Tax | Tax rate | 8% | ||
| 2 | Coffee maker | $89.00 | |||||
| 3 | Kettle | $34.50 | |||||
| 4 | Toaster | $42.00 | |||||
| 5 | Blender | $129.90 | |||||
| 6 | Rice cooker | $74.00 | |||||
| 7 | Air fryer | $159.00 | |||||
| 8 | |||||||
| 9 |