Exercises / Foundations · 12 of 12
Fill a price grid with one formula
$A2 locks only the column, B$1 locks only the row. Mixed references let one formula fill a whole table: copied right it keeps reading column A, copied down it keeps reading row 1. Press F4 repeatedly in Excel to cycle through A1, $A$1, A$1 and $A1.
Your taskEach cell of B2:E7 is a quantity (column A) times a unit price (row 1). Write one formula in B2 that fills the whole grid when copied across and down.
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 | Qty \ Price | $2.50 | $4.00 | $6.75 | $9.90 | |
| 2 | 10 | |||||
| 3 | 20 | |||||
| 4 | 50 | |||||
| 5 | 100 | |||||
| 6 | 250 | |||||
| 7 | 500 | |||||
| 8 | ||||||
| 9 |