Exercises / Foundations · 7 of 12
Copy one formula down a column
When you copy a formula down, Excel moves its references with it: =B2*C2 in row 2 becomes =B3*C3 in row 3. These are relative references, and they are why one formula can fill a whole column.
Your taskWrite one formula in D2 that multiplies price by quantity. It will be copied down to D7, so it must work on every row.
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 | Price | Qty | Total | ||
| 2 | Notebook | $3.50 | 20 | |||
| 3 | Pen set | $6.00 | 15 | |||
| 4 | Stapler | $12.90 | 4 | |||
| 5 | Desk lamp | $24.00 | 6 | |||
| 6 | Backpack | $39.99 | 2 | |||
| 7 | Monitor arm | $58.00 | 3 | |||
| 8 | ||||||
| 9 |