A school administrator in Singapore creates a spreadsheet to track student attendance. Cell D5 contains the formula =$B$1*C5. When this formula is copied from D5 to D10, which formula will appear in cell D10?

Q: How do I try a free CIE Information and Communication Technology question?

Just tap any of the four options on this page — no signup, no card, nothing to install. You'll see the correct answer and a full mark-scheme-style explanation within a second. Each visit shows a fresh randomly-picked question from the live CIE IGCSE Information and Communication Technology bank, so you can keep refreshing to try different ones before deciding whether to create a free account for daily access.

Q: Is Kramizo really free for CIE Information and Communication Technology students?

Yes — completely free. Every student gets 45 questions a day on the free plan, across any board and any subject, with no card required and no trial countdown. Kramizo's optional Pro plan removes the daily cap and adds analytics, but the free plan is genuinely free forever. We make money from the small percentage of students who choose to upgrade — not from selling data or ads.

Q: Are the Information and Communication Technology questions aligned to the CIE IGCSE syllabus?

Every question is written against the published CIE IGCSE Information and Communication Technology syllabus and reviewed for accuracy before being added to the bank. We match the command words (state, describe, explain, evaluate), mark allocations, and difficulty tier you'll see on real CIE past papers. Explanations are written in the style of official examiner mark schemes so students learn exactly what marks are being awarded for.

Question

A school administrator in Singapore creates a spreadsheet to track student attendance. Cell D5 contains the formula =$B$1*C5. When this formula is copied from D5 to D10, which formula will appear in cell D10?

Accepted Answer

=$B$1*C10 — Award 1 mark for identifying that $B$1 is an absolute reference (remains unchanged when copied) while C5 is a relative reference (adjusts to C10 when copied down 5 rows). B is incorrect because $B$1 uses absolute referencing and will not change. C is incorrect because the relative reference C5 will adjust. D is incorrect because it shows both references changing incorrectly.

Answer

=$B$1*C5

Answer

=$B$6*C10

Answer

=$B$6*C5

Answer

=$B$1*C10

One real Information and Communication Technology question.No signup. 30 seconds.

One real Information and Communication Technology question.
No signup. 30 seconds.