Course contents · Problem book

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:

Multiplication table: =$A2*B$1 in B2, copied over the whole square.

Tasks in the trainer

  1. Fill the multiplication table B2:J10 with one formula copied over the whole range.
  2. In M4:M6 convert the prices to euros at the rate in M1.
  3. In P6 calculate total sales.
  4. In Q2:Q5 — each department’s share of the total.
  5. 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 →