Spreadsheets — IGCSE Information And Communication Technology (0417) questions by topic
Spreadsheet questions require working formulas built to a precise specification: displaying a fastest time using a named range, averaging results for a specific mix number, or building a replicable lookup formula from imported data. Produce, use and complete direct the formula-building steps, while explain and state cover short written answers about what a formula or setting does.
17 real questions from 2023 to 2025 sit here, worth from 1 to as many as 46 marks for the longer build tasks. Because one wrong cell reference in a named range can break several dependent formulas, checking each submission against instant marking catches that single error before it silently affects every later step relying on the same reference.
May–June 2025, Paper 13
A spreadsheet uses both functions and formulas. Explain the differences between a function and a formula.
Answer this question and get it marked →May–June 2025, Paper 31
Task 5 - Spreadsheet (Steps 10-24). You will assist Tawara Racing to analyse performance data when testing their racing cars. Step 10 [3 marks]: Open and examine the file…
Answer this question and get it marked →May–June 2025, Paper 32
Open and examine the file j25fuelmix.csv Place in the header the text Tests performed on: followed by a space, the automated date, a space then the text at followed by a space…
Answer this question and get it marked →Merge cells A1 to F1. Format this merged cell with a black 40-point serif font on a yellow background. Merge cells A3 to B3 and A11 to B11. Format these merged cells with a light…
Answer this question and get it marked →Create, using cells D18:D77, a named range called TTime Place in your Evidence Document a screenshot showing the name and the range of cells.
Answer this question and get it marked →Place in cell B4 a formula to display the fastest test time, using the named range created in Step 3.
Answer this question and get it marked →Place in cell B5 a formula to display the slowest test time.
Answer this question and get it marked →Place in cell B6 a formula to display the average test time.
Answer this question and get it marked →Three different fuel mixes are being tested. Place in cell B7 a formula, using the named range created in Step 3, to display the average test time for mix number 1
Answer this question and get it marked →Place in cell B8 a formula, using the named range created in Step 3, to display the average test time for mix number 2
Answer this question and get it marked →Place in cell B9 a formula, using the named range created in Step 3, to display the average test time for mix number 3
Answer this question and get it marked →May–June 2024, Paper 31
Task 2 - Spreadsheet (Steps 1-10). Analyse the splendid toadfish sightings data (j2431divers.csv). Steps: (1) open and examine the file; (2) replicable lookup formula in C35 to…
Answer this question and get it marked →May–June 2024, Paper 32
Task 2 - Spreadsheet (Steps 1-12). Analyse the giraffe sightings data (j32giraffe.csv). Steps: (1) open and examine the file; (2) replicable lookup formula in D28 to display the…
Answer this question and get it marked →October–November 2024, Paper 03
Task 2 - Spreadsheet (Steps 1-12). Analyse the web-page hits data (n24hits.csv). Steps: (1) header with ID details left aligned and 'Created on' with automated date right aligned;…
Answer this question and get it marked →May–June 2023, Paper 31
Task 2 - Spreadsheet (Steps 1-11). Create a weather-data spreadsheet from j31weather.csv (saved as Weather...). Steps: (1) open and save; (2) format rows 1-17 (merge/centre rows 1…
Answer this question and get it marked →May–June 2023, Paper 32
Task 4 - Spreadsheets (Steps 8-15). Edit the Tawara Animal Sanctuary income/expenditure spreadsheet (j2332project.csv, saved as project<centre<candidate). Steps: (8) copy A4 to…
Answer this question and get it marked →October–November 2023, Paper 03
Task 4 - Spreadsheet (Steps 9-20). Create an income/expenditure spreadsheet for the sanctuary from n23tgs.csv (saved as tgs<centre<candidate). Steps: (9) open and save; (10)…
Answer this question and get it marked →Other IGCSE Information And Communication Technology topics
- ICT applications (40)
- Document production (35)
- The systems life cycle (27)
- Types and components of computer systems (26)
- Safety and security (22)
- Data manipulation (databases) (20)
- Presentations (15)
- Website authoring (15)
- The effects of using IT (health and safety) (14)
- Storage devices and media (12)
- Input and output devices (11)
- Networks (10)
← All IGCSE Information And Communication Technology (0417) past papers