An environmental scientist collects temperature readings from weather stations across South America. The spreadsheet contains 5000 rows of data. She needs to quickly identify all readings above 40°C by highlighting these cells in red. Which spreadsheet feature is most efficient for this task?

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

An environmental scientist collects temperature readings from weather stations across South America. The spreadsheet contains 5000 rows of data. She needs to quickly identify all readings above 40°C by highlighting these cells in red. Which spreadsheet feature is most efficient for this task?

Accepted Answer

Conditional formatting — Award 1 mark for identifying conditional formatting, which automatically applies formatting to cells based on specified conditions. With 5000 rows, this is the most efficient method. D is incorrect because manual formatting of 5000 rows would be extremely time-consuming and error-prone. B is incorrect because find and replace changes cell content, not formatting based on conditions. C is incorrect because sorting rearranges data but does not highlight specific values.

Answer

Find and replace

Answer

Data sorting

Answer

Conditional formatting

Answer

Manual cell formatting

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

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