Online worksheet ยท 3 of 4
Copied references may move - Online practice 3
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=9, D3=4, D4=7, D5=6, D6=8. 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