Online worksheet · 4 of 4

Copied references may move - Online practice 4

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=12, D3=18, D4=6, D5=24, D6=30. 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