Absolute and mixed references
Open the practice in the trainer →
A classic of the book: tables filled with a single formula. The trick is mixed references:
$A2 — the column is locked, the row changes (take the number from the left column);
B$1 — the row is locked, the column changes (take the number from the top row).
Multiplication table: =$A2*B$1 in B2, copied over the whole square.
Tasks in the trainer
- Fill the multiplication table B2:J10 with one formula copied over the whole range.
- In M4:M6 convert the prices to euros at the rate in M1.
- In P6 calculate total sales.
- In Q2:Q5 — each department’s share of the total.
- Table of powers: in B13:F15 raise the number in column A to the power in row 12 with one formula.
Solve the tasks in the trainer →