IGCSE Information And Communication Technology (0417) — May–June 2025, Paper 32

9 questions · every question answerable online with instant point-by-point AI marking against the official mark scheme.

Start with Question 1 →
Question 1 · 3 marks · Spreadsheets - headers and footers

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 →
Question 2 · 8 marks · Spreadsheets - cell formatting

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 →
Question 3 · 1 mark · Spreadsheets - named ranges

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 →
Question 4 · 2 marks · Spreadsheets - functions (MIN)

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 →
Question 5 · 1 mark · Spreadsheets - functions (MAX)

Place in cell B5 a formula to display the slowest test time.

Answer this question and get it marked →
Question 6 · 1 mark · Spreadsheets - functions (AVERAGE)

Place in cell B6 a formula to display the average test time.

Answer this question and get it marked →
Question 7 · 4 marks · Spreadsheets - conditional functions (AVERAGEIF)

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 →
Question 8 · 1 mark · Spreadsheets - conditional functions (AVERAGEIF)

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 →
Question 9 · 1 mark · Spreadsheets - conditional functions (AVERAGEIF)

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 11 · May–June 2025 Paper 31 →

← All IGCSE Information And Communication Technology (0417) past papers