Spreadsheets — IGCSE Information And Communication Technology (0983) questions by topic
Building formulas to display named-range results, printing a completed spreadsheet in portrait with headings hidden, and constructing multi-step tasks worth up to 29 marks on data such as an animal sanctuary's income and expenditure are typical of the 38 spreadsheets questions from 2023 to 2025, where marks per task run from 1 right up to 46.
Complete, calculate and construct top the command words, with describe and show used for explaining a chosen formula or displaying results correctly formatted. Because a single wrong cell reference or missing print setting can cost marks across an entire task, work through these step-by-step builds and submit for instant marking, so a broken formula or incorrect print orientation is caught before the next dependent step is attempted.
May–June 2025, Paper 31
You will assist Tawara Racing to analyse performance data when testing their racing cars. Open and examine the file TRtest.csv Place, right-aligned in the header, the text Created…
Answer this question and get it marked →Enter the missing lap numbers in column A.
Answer this question and get it marked →Place a replicable formula in cell F14 to calculate the time in seconds taken for this lap. For example: if the minutes = 1, seconds = 14 and thousandths of a second = 484 this…
Answer this question and get it marked →Insert ten rows between rows 1 and 2. Move the contents of cells H13 to H20 into cells A3 to A10.
Answer this question and get it marked →Merge cells A1 to F1. Format this merged cell with a black 36-point sans-serif font on a yellow background. Merge cells A12 to F12. Format rows 1 to 13 of the spreadsheet to look…
Answer this question and get it marked →Place in cell B3 a formula to display the fastest lap time from the data displayed.
Answer this question and get it marked →Place in cell B4 a formula to display the slowest lap time.
Answer this question and get it marked →Place in cell B5 a formula to display the average lap time.
Answer this question and get it marked →Place in cell B6 a formula to display the number of laps where the Supercharger was On
Answer this question and get it marked →Place in cell B7 a formula to display the number of laps where the Supercharger was Off
Answer this question and get it marked →Place in cell B8 a formula to calculate the average lap time when the Supercharger was On
Answer this question and get it marked →Place in cell B9 a formula to calculate the average lap time when the Supercharger was Off
Answer this question and get it marked →Place in cell B10 a formula to display SC success if the average lap times were faster with the supercharger on or to display SC failed if not. Save your spreadsheet.
Answer this question and get it marked →Print your spreadsheet showing the formulae. Make sure that the: - printout is in landscape orientation - row and column headings are displayed - contents of all cells are fully…
Answer this question and get it marked →Print your spreadsheet showing the values. Make sure that the: - printout fits on a single page - printout is in portrait orientation - row and column headings are not displayed -…
Answer this question and get it marked →May–June 2025, Paper 32
Scenario: You are assisting Tawara Racing to analyse data about performance when testing its racing cars. You will also create a web page to advertise this racing team. Source…
Answer this question and get it marked →Step 2: 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…
Answer this question and get it marked →Step 3: 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 →Step 4: 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 →Step 5: Place in cell B5 a formula to display the slowest test time.
Answer this question and get it marked →Step 6: 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. Step 7: 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 →Step 8: 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 →Step 9: 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 →Tests are only acceptable if there is little or no following wind. Step 10: Place in cell F18 a replicable formula to check the wind adjustment for this test. If this value is…
Answer this question and get it marked →For the calculations for wind adjusted tests, the results will only count if the wind levels are acceptable. Step 11: Place in cell B12 a formula to display the average test time…
Answer this question and get it marked →Step 12: Place in cell B13 a formula to display the average test time for mix number 2 where the wind is at an acceptable level.
Answer this question and get it marked →Step 13: Place in cell B14 a formula to display the average test time for mix number 3 where the wind is at an acceptable level.
Answer this question and get it marked →Step 14: Place in cell B15 a formula to display the Fuel mix % for the fuel mix that gave the fastest wind-adjusted average test time. Format this cell to display as a percentage.
Answer this question and get it marked →Step 15: Format all test times to 4 decimal places. Save your spreadsheet.
Answer this question and get it marked →Step 16: Print your spreadsheet showing the formulae. Make sure that the printout is in landscape orientation, row and column headings are displayed, and the contents of all cells…
Answer this question and get it marked →Step 17: Print your spreadsheet showing the values. Make sure that the printout fits on a single page, the printout is in portrait orientation, row and column headings are not…
Answer this question and get it marked →May–June 2024, Paper 31
Task 2 – Spreadsheet (35 marks total) You are going to work with spreadsheet data about sightings of the splendid toadfish. Source files: j2431divers.csv, j2431splendid.csv. Steps…
Answer this question and get it marked →May–June 2024, Paper 32
Task 2 – Spreadsheet (41 marks total) You are going to work with spreadsheet data about giraffe sightings. Source files: j32giraffe.csv, j32sightings.csv. Steps 1–11 require…
Answer this question and get it marked →October–November 2024, Paper 03
Task 2 – Spreadsheet (46 marks total) You work for Tawara Web Developers, editing a spreadsheet analysing web page hits and advertising. Source file: n24hits.csv. Steps 1–12…
Answer this question and get it marked →May–June 2023, Paper 31
Task 2 – Spreadsheet (42 marks total) You are going to create a spreadsheet to calculate and display weather data about three towns called Amarta, Bingchen and Chelsmy. Source…
Answer this question and get it marked →May–June 2023, Paper 32
Task 4 – Spreadsheets (29 marks total) You are going to create a spreadsheet to show income and expenditure data for three projects at Tawara's Animal Sanctuary. Source file:…
Answer this question and get it marked →October–November 2023, Paper 03
Task 4 – Spreadsheet (30 marks total) You are going to create a spreadsheet to calculate the income and expenditure of the sanctuary for one year. All currency values must be…
Answer this question and get it marked →Other IGCSE Information And Communication Technology topics
- Website authoring (25)
- Document production (22)
- Presentations (20)
- Data manipulation (databases) (16)
- Types and components of computer systems (9)
- ICT applications (8)
- Safety and security (8)
- Input and output devices (7)
- The systems life cycle (7)
- The effects of using IT (health and safety) (6)
← All IGCSE Information And Communication Technology (0983) past papers