Online worksheet · 1 of 4

Copied references may move - Online practice 1

Read the information, then answer the questions. An adult may read the instructions aloud. Show your working where asked.

Read before answering

Fictional table: D2=6, D3=8, D4=10, D5=12, D6=14. A draft total in D7 is =SUM(D2:D5), but it should include rows 2 through 6. Elsewhere D2's row formula =B2*C2 is copied down one row using relative references. The total must not include its own cell.

Worksheet preview

This exercise is included in the paid course. Full-course fee: GBP 200.00 once. Register and enrol to complete all course exercises and download the course PDFs. Access begins after payment is confirmed.

Already registered? Sign in