← Back to the activity

Class 8 Computer Science — Copying formulas, and references that stay put

Work out what a formula points at once it has been copied, and use a dollar sign to stop a reference moving.

Name: ________________________

  1. 1.Cell L1 holds 80. Cell L2 holds =L1/2, and that formula is copied down into L3, L4 and L5. Put these cells in order of the value each one shows, smallest first.

    • L3
    • L4
    • L2
    • L5

  2. 2.Cell A2 holds =A1+B1. The formula is copied into C5, so it has moved both across and down. In the copy, which cell takes the place of A1?

  3. 3.A dollar sign fixes the part of a reference it stands in front of. Cell G4 holds =$G$1+G3, and is copied down into G5. In the copy, which cell is added to $G$1?

  4. 4.Cell M10 holds =M9-$A$1. The formula is copied upwards into M4. In the copy, which cell has $A$1 taken away from it?

  5. 5.Cell E2 holds =E1+5. The formula is copied across into F2. Which cell does the copy add 5 to?

  6. 6.Cell N3 holds =SUM(N1:N2). The formula is copied down into N5. In the copy, which cell is the last one in the range being added up?

  7. 7.A dollar sign fixes the part of a reference it stands in front of. Cell H2 holds =H1*$B$1, and is copied across into I2. In the copy, which cell is $B$1 multiplied by?

  8. 8.A times-table grid is being built. Column A holds the numbers going down and row 1 holds the numbers going across. One formula is written in B2 and then copied both across and down to fill the whole grid. Which formula belongs in B2?

    • a) =$A2*B$1
    • b) =$A$2*$B$1
    • c) =A$2*$B1
    • d) =A2*B1

Answer key — Class 8 Computer Science — Copying formulas, and references that stay put

  1. 1. 1. L5 2. L4 3. L3 4. L2
  2. 2. C4
  3. 3. G4
  4. 4. M3
  5. 5. F1
  6. 6. N4
  7. 7. I1
  8. 8. a) =$A2*B$1