Exercises / Foundations · 1 of 12
Work out a line total
Every formula starts with =. After that you can use cells like numbers: + adds, - subtracts, * multiplies, / divides. When a cell changes, the formula updates by itself.
Your taskIn D2, multiply the unit price in B2 by the quantity in C2.
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 |
|---|---|---|---|---|---|---|
| 1 | Item | Unit price | Qty | Total | ||
| 2 | Desk chair | $149.00 | 4 | |||
| 3 | ||||||
| 4 | ||||||
| 5 | ||||||
| 6 | ||||||
| 7 | ||||||
| 8 | ||||||
| 9 |