Kramizo
Log inSign up free
Home › CIE IGCSE Information and Communication Technology › Spreadsheets and Data Handling
CIE · IGCSE · Information and Communication Technology

Spreadsheets and Data Handling
Practice Questions

20 CIE IGCSE Information and Communication Technology questions on Spreadsheets and Data Handling, each with instant feedback and a full examiner-style mark scheme.

⚡ Start Quiz on Spreadsheets and Data Handling →📖 Read Revision Notes
✨ Revision guide includes key terms, worked examples and exam technique for Spreadsheets and Data Handling.

Try 2 sample questions on Spreadsheets and Data Handling

Question 1 · 1 mark · Difficulty 2/3

A sales manager at an international electronics company uses a spreadsheet to calculate monthly commission payments. The formula =IF(B2>5000,B2*0.1,B2*0.05) is entered in cell C2. What does this formula calculate?

  1. A fixed commission of 5000 multiplied by sales
  2. 10% commission if sales exceed 5000, otherwise 5% commission
  3. 5% commission if sales exceed 5000, otherwise 10% commission
  4. 10% commission on all sales over 5000 only
Show answer & explanation
✓ Answer: B — 10% commission if sales exceed 5000, otherwise 5% commission
Award 1 mark for understanding that the IF function tests the condition B2>5000, and if TRUE returns B2*0.1 (10%), if FALSE returns B2*0.05 (5%). C is incorrect because it reverses the commission percentages. D is incorrect because commission is calculated on total sales, not just the amount over 5000. A is incorrect because 5000 is the threshold value, not a multiplier.
Question 2 · 1 mark · Difficulty 2/3

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?

  1. =$B$1*C10
  2. =$B$6*C10
  3. =$B$1*C5
  4. =$B$6*C5
Show answer & explanation
✓ Answer: A — =$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.
⚡ Start a Quiz on Spreadsheets and Data Handling →
20 questions · 25 min · free

CIE IGCSE Information and Communication Technology: Spreadsheets and Data Handling FAQ

Is Kramizo free for CIE IGCSE students preparing for Information and Communication Technology?
Yes — completely free. Every student gets 45 questions a day on the free plan, with no card required and no trial countdown. That free quota works across every subject and every topic in our bank, so you can mix Spreadsheets and Data Handling practice with other Information and Communication Technology topics or even switch to a totally different CIE subject without paying anything. Kramizo's optional Pro plan removes the daily cap and adds detailed progress analytics, but the free tier is the real product — used by thousands of GCSE, IGCSE and CSEC students.
Are the Spreadsheets and Data Handling questions aligned to the official CIE IGCSE Information and Communication Technology syllabus?
Every question is written against the published CIE IGCSE Information and Communication Technology specification, including the exact command words (state, describe, explain, calculate, evaluate, etc.), mark allocations, and difficulty tier you'd see on a real CIE paper. Explanations are written in the style of official examiner mark schemes — they tell you what is being awarded marks and why distractors are wrong, not just whether you got it right. The bank is continually refined to match the latest syllabus updates from CIE.
How is Spreadsheets and Data Handling typically tested on CIE IGCSE Information and Communication Technology papers?
Spreadsheets and Data Handling appears across multiple question types on real CIE IGCSE Information and Communication Technology papers — most commonly as multiple-choice questions in the objective section, structured short-answer questions in the main paper, and occasionally as part of an extended response. Kramizo's practice bank reflects that mix: 4-option MCQs, true/false statements, fill-in-the-blank key terms, multi-select questions, and ordering questions. Working through the bank gives you exposure to every question style examiners actually use.

Lock in Spreadsheets and Data Handling before exam day.

Start practising in 30 seconds — no card required.

⚡ Start Quiz Free →