Question Simulator

IGCSE ICT (0417)

Spreadsheets Rare

2 questions · about 2% of the marks we indexed · examined in 2 of 9 sessions.

Questions by year

2026

  • 2026 May/June · Paper 12 · Q22 marksFormulas and functions

2022

  • 2022 May/June · Paper 12 · Q9 (a, c)10 marksFormulas and functions

References only, not question text. Open Official paper ↗ where Cambridge publishes the paper, or see the official Cambridge past-papers page; for other papers, ask your school. “Paper 42” means Paper 4, variant 2.

Practice questions

Original questions written by HomiLabs in the style of the exam, with answers and mark schemes. They are not Cambridge past paper questions and have not been reviewed by Cambridge. Try each one before opening the answer.

Q1Formulas and functions · Core · Paper 1 style · 4 marks
  1. (a) Explain the difference between a formula and a function in a spreadsheet. [2]
  2. (b) Give one example of each, using cell references. [2]
Show answer
  1. (a) A formula is a calculation entered by the user, using cell references, values and operators, e.g. =B2*C2. A function is a predefined/built-in named operation in the software that carries out a calculation on given arguments/a range, e.g. =SUM(B2:B10).
    1 mark: formula = user-written calculation with operators/cell references. 1 mark: function = built-in/predefined named routine. Examples alone not enough.
  2. (b) Formula e.g. =D4-E4 or =B3*1.17; function e.g. =AVERAGE(C2:C20) or =MAX(B2:B9).
    1 mark for a valid formula; 1 mark for a valid function.
Q2Formulas and functions · Core · Paper 3 style · 4 marks

A stationery shop in Karachi uses this spreadsheet.Row 1 headings: A Item | B Price (Rs) | C Quantity sold | D Takings (Rs)Row 2: Notebook | 120 | 45Row 3: Pen | 35 | 210Row 4: Geometry box | 450 | 18Row 5: Highlighter | 80 | 64

  1. (a) Write the formula that should be entered in D2 to calculate the total takings for notebooks. [1]
  2. (b) The formula in D2 is replicated down to D5. State the value displayed in D5. [1]
  3. (c) Write the function that should be entered in D6 to calculate the total takings for all four items, and state the value it displays. [2]
Show answer
  1. (a) =B2*C2
    1 mark. Accept =C2*B2.
  2. (b) 5120
    B1: 80 × 64 = 5120.
  3. (c) =SUM(D2:D5); 25 970
    1 mark: =SUM(D2:D5). B1: 5400 + 7350 + 8100 + 5120 = 25 970.
Q3Formulas and functions · Core · Paper 3 style · 5 marks

A weather enthusiast in Islamabad records the maximum temperature (°C) each day for a week in cells B2 to B8: 31, 34, 29, 36, 33, 30, 35.

  1. (a) Write the function in B9 to find the mean maximum temperature for the week. [1]
  2. (b) B9 is formatted to 1 decimal place. State the value displayed. [1]
  3. (c) Write functions for B10 and B11 to find the highest and lowest temperatures, and state the values they display. [2]
  4. (d) Write a formula for B12 that uses B10 and B11 to calculate the range of temperatures. [1]
Show answer
  1. (a) =AVERAGE(B2:B8)
    1 mark.
  2. (b) 32.6
    B1: 228 ÷ 7 = 32.571… → 32.6.
  3. (c) B10 =MAX(B2:B8) → 36; B11 =MIN(B2:B8) → 29
    1 mark: both functions correct. 1 mark: both values correct.
  4. (d) =B10-B11 (displays 7)
    1 mark.
Q4Formulas and functions · Core · Paper 3 style · 4 marks

A teacher in Hyderabad stores test marks for ten students in B2 to B11: 67, 45, 82, 50, 38, 91, 49, 73, 55, 29.

  1. (a) Write the function to count how many students scored 50 or more, and state the value it displays. [2]
  2. (b) Write the function to count how many students scored less than 40, and state the value it displays. [2]
Show answer
  1. (a) =COUNTIF(B2:B11,">=50"); 6
    1 mark: correct COUNTIF with range and criterion. B1: 6.
  2. (b) =COUNTIF(B2:B11,"<40"); 2
    1 mark: function. B1: 2 (38 and 29).
Q5Formulas and functions · Core · Paper 3 style · 4 marks
  1. (a) Write a formula in D2 that displays Pass if the mark in C2 is 40 or more, and Fail otherwise. [2]
  2. (b) The formula is replicated to D3 and D4. C2 contains 39, C3 contains 40 and C4 contains 72. State what is displayed in D2, D3 and D4. [2]
Show answer
  1. (a) =IF(C2>=40,"Pass","Fail")
    1 mark: IF with condition C2>=40. 1 mark: correct outputs "Pass" and "Fail" in the right order.
  2. (b) D2 Fail; D3 Pass; D4 Pass
    2 marks all three correct; 1 mark for two correct.
Q6Formulas and functions · Core · Paper 3 style · 3 marks

A club records the number of runs scored by a batter in B2 to B9. The cells contain: 12, absent, 15, (empty), 0, 18, absent, 9.

  1. (a) State the value displayed by(i) =COUNT(B2:B9)(ii) =COUNTA(B2:B9) [2]
  2. (b) Explain why the two values are different. [1]
Show answer
  1. (a) (i) 5 (ii) 7
    B1 each. COUNT counts the five numbers (12, 15, 0, 18, 9); COUNTA counts all seven non-empty cells.
  2. (b) COUNT only counts cells containing numbers; COUNTA counts every cell that is not empty, including text such as 'absent'.
    1 mark.
Q7Formulas and functions · Core · Paper 3 style · 4 marks
  1. (a) State the value displayed by(i) =2+3*4(ii) =(2+3)*4 [2]
  2. (b) B2 contains 60 and C2 contains 80. A student enters =B2+C2/2 to find the mean of the two cells. State the value displayed and write the correct formula. [2]
Show answer
  1. (a) (i) 14 (ii) 20
    1 mark each (multiplication before addition; brackets first).
  2. (b) 100; =(B2+C2)/2 (or =AVERAGE(B2:C2))
    B1: 60 + 40 = 100. 1 mark: correct formula.
Q8Formulas and functions · Core · Paper 3 style · 3 marks
  1. (a) A sheet calculates the cost per student of a club using =B2/C2, where B2 holds the total cost and C2 the number of students. When C2 is 0 the cell shows #DIV/0!. Explain why. [1]
  2. (b) Write a formula that displays No students when C2 is 0 and otherwise shows the cost per student. [2]
Show answer
  1. (a) The formula is trying to divide by zero, which cannot be calculated.
    1 mark.
  2. (b) =IF(C2=0,"No students",B2/C2)
    1 mark: IF testing C2=0 with "No students". 1 mark: B2/C2 as false value.
Q9Formulas and functions · Core · Paper 3 style · 4 marks

A student records the daily rainfall (mm) in Murree for 10 days in B2:B11: 0, 4.5, 0, 12, 0, 0, 7.2, 1.1, 0, 3.

  1. (a) Write a function to count the number of days on which some rain fell, and state its value. [2]
  2. (b) Write a formula to calculate the proportion of days with rain, using COUNTIF and COUNT, and state the result as a percentage. [2]
Show answer
  1. (a) =COUNTIF(B2:B11,">0"); 5
    1 mark function; B1: 5.
  2. (b) =COUNTIF(B2:B11,">0")/COUNT(B2:B11); 50%
    1 mark formula; B1: 5 ÷ 10 = 50%.
Q10Formulas and functions · Core · Paper 1 style · 4 marks
  1. (a) A sports coach keeps players' sprint times in a spreadsheet. Name the most suitable function for each task.(i) Find the fastest (lowest) time.(ii) Find how many times have been entered.(iii) Find how many players are in the 'Under 16' group.(iv) Show 'Selected' if a time is below 12 seconds, otherwise 'Not selected'. [4]
Show answer
  1. (a) (i) MIN (ii) COUNT (iii) COUNTIF (iv) IF
    1 mark each.
Q11Formulas and functions · Standard · Paper 3 style · 6 marks

An electronics shop stores the sales tax rate, 17%, in cell F1. Prices of items (Rs) are in B2 to B20.

  1. (a) Write the formula in C2 to calculate the sales tax on the item in B2. It must give correct results when replicated down to C20. [2]
  2. (b) Explain why an absolute reference is needed in this formula. [2]
  3. (c) B2 contains 2400 and B5 contains 1850. State the values displayed in C2 and C5. [2]
Show answer
  1. (a) =B2*$F$1
    1 mark: B2 multiplied by F1. 1 mark: F1 made absolute ($F$1). Accept =B2*F$1.
  2. (b) When the formula is replicated, relative references change (B2 becomes B3, B4…) but the tax rate is always in F1, so the reference to F1 must not change; otherwise the formula would point to F2, F3… which are empty.
    1 mark: relative references change when copied. 1 mark: F1 must stay fixed / would refer to empty cells.
  3. (c) C2 408; C5 314.5
    B1 each: 2400 × 0.17 = 408; 1850 × 0.17 = 314.5.
Q12Formulas and functions · Standard · Paper 3 style · 4 marks

A soft-drinks distributor records sales (cartons). Column A holds the region and column B the sales.Row 2: North | 1200Row 3: South | 950Row 4: North | 780Row 5: East | 1430Row 6: North | 610Row 7: South | 1100

  1. (a) Write the function to calculate the total sales for the North region. [2]
  2. (b) State the values that would be displayed for the total sales of North and of South. [2]
Show answer
  1. (a) =SUMIF(A2:A7,"North",B2:B7)
    1 mark: SUMIF with criteria range A2:A7 and "North". 1 mark: sum range B2:B7.
  2. (b) North 2590; South 2050
    B1: 1200 + 780 + 610 = 2590. B1: 950 + 1100 = 2050.
Q13Formulas and functions · Standard · Paper 3 style · 4 marks

A spreadsheet holds quiz scores. Column A holds the class and column B the score.Row 2: 10A | 72Row 3: 10B | 65Row 4: 10A | 88Row 5: 10B | 59Row 6: 10A | 64Row 7: 10B | 81

  1. (a) Write the function to calculate the mean score of class 10A. [2]
  2. (b) The result is rounded using =ROUND(AVERAGEIF(A2:A7,"10A",B2:B7),1). State the value displayed. [1]
  3. (c) State the mean score of class 10B correct to 1 decimal place. [1]
Show answer
  1. (a) =AVERAGEIF(A2:A7,"10A",B2:B7)
    1 mark: AVERAGEIF with criteria range and "10A". 1 mark: average range B2:B7.
  2. (b) 74.7
    B1: (72 + 88 + 64) ÷ 3 = 74.666… → 74.7.
  3. (c) 68.3
    B1: (65 + 59 + 81) ÷ 3 = 68.33… → 68.3.
Q14Formulas and functions · Standard · Paper 3 style · 6 marks

A weather station's spreadsheet holds months in row 1 and rainfall (mm) in row 2.B1:G1: Jan, Feb, Mar, Apr, May, JunB2:G2: 23, 29, 41, 20, 22, 79

  1. (a) Write a function that looks up and displays the rainfall for March from this table. [3]
  2. (b) State the value displayed. [1]
  3. (c) Write a function to find the total rainfall for the six months and state its value. [2]
Show answer
  1. (a) =HLOOKUP("Mar",B1:G2,2,FALSE)
    1 mark: HLOOKUP with "Mar" (or a cell containing Mar). 1 mark: range B1:G2. 1 mark: row 2 and FALSE.
  2. (b) 41
    B1.
  3. (c) =SUM(B2:G2); 214
    1 mark function; B1: 23 + 29 + 41 + 20 + 22 + 79 = 214.
Q15Formulas and functions · Standard · Paper 3 style · 4 marks
  1. (a) Cell A1 contains 47.3681. State the value displayed by each formula.(i) =ROUND(A1,2)(ii) =ROUNDUP(A1,1)(iii) =ROUNDDOWN(A1,2)(iv) =INT(A1) [4]
Show answer
  1. (a) (i) 47.37 (ii) 47.4 (iii) 47.36 (iv) 47
    1 mark each.
Q16Formulas and functions · Standard · Paper 3 style · 5 marks
  1. (a) A school in Faisalabad is taking 263 students on a trip. Each bus holds 45 students. The number of students is in B1 and the bus capacity in B2. Write a formula to calculate the number of buses needed, and state its value. [2]
  2. (b) An egg farm collects 1000 eggs (in C1). A tray holds 30 eggs (in C2). Write a formula to calculate the number of full trays and state its value. [2]
  3. (c) Write a formula to calculate the number of eggs left over, using C1 and C2, and state its value. [1]
Show answer
  1. (a) =ROUNDUP(B1/B2,0); 6
    1 mark: ROUNDUP of B1/B2 to 0 places. B1: 263 ÷ 45 = 5.84… → 6.
  2. (b) =ROUNDDOWN(C1/C2,0) (or =INT(C1/C2)); 33
    1 mark: ROUNDDOWN or INT. B1: 33.
  3. (c) =C1-ROUNDDOWN(C1/C2,0)*C2; 10
    1 mark: valid formula with 10. Accept =MOD(C1,C2).
Q17Formulas and functions · Standard · Paper 3 style · 4 marks
  1. (a) Cell B1 contains the exchange rate 278.50 (rupees per US dollar). The cell is given the name Rate. Write the formula in C5 to convert the dollar amount in B5 to rupees using the named cell. [1]
  2. (b) B5 contains 40. State the value displayed in C5. [1]
  3. (c) Give two advantages of using a named range rather than the cell reference $B$1. [2]
Show answer
  1. (a) =B5*Rate
    1 mark.
  2. (b) 11140
    B1: 40 × 278.5 = 11 140.
  3. (c) Any two: formulas are easier to read/understand; easier to enter without errors; the name acts as an absolute reference so it does not change when the formula is replicated; the range can be found/edited easily.
    1 mark each.
Q18Formulas and functions · Standard · Paper 1 style · 4 marks
  1. (a) Cell D2 contains the formula =B2*C2. It is replicated down to D5. Write the formula that will be in D5. [1]
  2. (b) Cell E2 contains =D2*$G$1. It is replicated down to E5. Write the formula that will be in E5. [1]
  3. (c) Explain the difference between relative and absolute cell referencing. [2]
Show answer
  1. (a) =B5*C5
    1 mark.
  2. (b) =D5*$G$1
    1 mark.
  3. (c) A relative reference changes to match its new position when the formula is copied/replicated. An absolute reference (with $ signs) always refers to the same cell however it is copied.
    1 mark each.
Q19Formulas and functions · Standard · Paper 3 style · 4 marks

A museum spreadsheet: column B holds visitors in 2024 and column C in 2025.Row 2: Science gallery | 12500 | 14250Row 3: Textile gallery | 8400 | 7980

  1. (a) Write the formula for D2 to calculate the percentage change in visitors from 2024 to 2025. [2]
  2. (b) D2 and D3 are formatted as percentages to 1 decimal place. State the values displayed. [2]
Show answer
  1. (a) =(C2-B2)/B2 (cell formatted as a percentage)
    1 mark: (C2−B2) with brackets. 1 mark: divided by B2. Accept *100 if not formatted as percentage.
  2. (b) D2 14.0%; D3 −5.0%
    B1: (14 250 − 12 500) ÷ 12 500 = 0.14. B1: (7980 − 8400) ÷ 8400 = −0.05.
Q20Formulas and functions · Standard · Paper 3 style · 4 marks
  1. (a) B2 contains the population 1284567 and B3 contains 739421. State the value displayed by(i) =ROUND(B2,-3)(ii) =ROUND(B3,-3)(iii) =ROUND(B2,-5) [3]
  2. (b) Explain what the negative number in =ROUND(B2,-3) does. [1]
Show answer
  1. (a) (i) 1285000 (ii) 739000 (iii) 1300000
    1 mark each.
  2. (b) It rounds to the left of the decimal point, here to the nearest thousand.
    1 mark.
Q21Formulas and functions · Challenge · Paper 3 style · 6 marks
  1. (a) Write a single formula for C2 that displays the grade for the percentage in B2, using these boundaries: 80 or more A; 65 or more B; 50 or more C; below 50 U. [4]
  2. (b) State the grades shown for the percentages 80, 79, 65, 50 and 49.5. [2]
Show answer
  1. (a) =IF(B2>=80,"A",IF(B2>=65,"B",IF(B2>=50,"C","U")))
    1 mark: first IF with B2>=80 → "A". 1 mark: nested IF for B. 1 mark: nested IF for C. 1 mark: "U" as final false value and correct brackets. Accept testing from lowest boundary with < in correct order.
  2. (b) A, B, B, C, U
    2 marks all correct; 1 mark for three or four correct.
Q22Formulas and functions · Challenge · Paper 3 style · 6 marks

A courier company stores a lookup table in H2:J6.Column H code | Column I city | Column J charge (Rs)KHI | Karachi | 250LHE | Lahore | 300ISB | Islamabad | 350PEW | Peshawar | 400QTA | Quetta | 450Orders are in rows 2 to 50; column B holds each order's city code.

  1. (a) Write the formula in C2 to look up the delivery charge for the city code in B2. It must work when replicated down column C. [3]
  2. (b) B2 contains ISB. State the value displayed in C2. [1]
  3. (c) B5 contains MUX. State what is displayed in C5 and explain why. [2]
Show answer
  1. (a) =VLOOKUP(B2,$H$2:$J$6,3,FALSE)
    1 mark: VLOOKUP with B2 as lookup value. 1 mark: absolute range $H$2:$J$6. 1 mark: column 3 and FALSE (exact match). Accept 0 for FALSE; accept a named range.
  2. (b) 350
    B1.
  3. (c) #N/A (an error); MUX is not in the first column of the lookup table and an exact match was requested.
    1 mark: #N/A / error. 1 mark: reason.
Q23Formulas and functions · Challenge · Paper 3 style · 6 marks

A wholesaler gives a discount based on the order value. The table in F2:G5 is:F (order value from, Rs) | G (discount)0 | 0%5000 | 5%10000 | 8%20000 | 12%

  1. (a) Write the formula in C2 to find the discount rate for the order value in B2, using the table, so that it works when replicated. [2]
  2. (b) State the discount rate given for order values of Rs 4999, Rs 10 000, Rs 17 500 and Rs 25 000. [2]
  3. (c) Calculate the discount, in rupees, on an order of Rs 17 500. [1]
  4. (d) Explain why the values in column F must be in ascending order. [1]
Show answer
  1. (a) =VLOOKUP(B2,$F$2:$G$5,2,TRUE)
    1 mark: VLOOKUP with B2 and absolute $F$2:$G$5. 1 mark: column 2 with TRUE (approximate match); accept TRUE omitted.
  2. (b) 0%, 8%, 8%, 12%
    2 marks all four; 1 mark for two or three.
  3. (c) Rs 1400
    B1: 17 500 × 0.08 = 1400.
  4. (d) An approximate-match lookup searches for the largest value that is less than or equal to the lookup value, which only works correctly if the first column is sorted in ascending order.
    1 mark.
Q24Formulas and functions · Challenge · Paper 3 style · 4 marks

A pharmacy stock sheet has product codes in A2:A9, product names in B2:B9, prices in C2:C9 and stock levels in D2:D9.

  1. (a) Write a formula in H3 using XLOOKUP that displays the stock level for the product code typed in H2. If the code is not found, the cell must display Not found. [3]
  2. (b) State one advantage of XLOOKUP compared with VLOOKUP. [1]
Show answer
  1. (a) =XLOOKUP(H2,A2:A9,D2:D9,"Not found")
    1 mark: XLOOKUP with H2 as lookup value. 1 mark: lookup array A2:A9 and return array D2:D9. 1 mark: "Not found" as the if-not-found argument.
  2. (b) e.g. the return column can be to the left of the lookup column; it does not break if columns are inserted (no column number); exact match is the default; it has a built-in 'not found' value.
    1 mark.
Q25Formulas and functions · Challenge · Paper 3 style · 5 marks

A mixed-reference times table: B1:D1 contain 5, 6, 7 and A2:A4 contain 2, 3, 4. B2 contains =$A2*B$1 and is replicated to fill B2:D4.

  1. (a) Write the formula in D4 after replication. [1]
  2. (b) State the values displayed in C3 and D4. [2]
  3. (c) Explain why the formula would give wrong answers if it had been entered as =A2*B1 before being replicated. [2]
Show answer
  1. (a) =$A4*D$1
    1 mark.
  2. (b) C3 18; D4 28
    B1: 3 × 6. B1: 4 × 7.
  3. (c) Both references would change in both directions, e.g. in D4 it would become =C4*D3, which multiplies results instead of the row and column headings; the $ before A keeps the column fixed and the $ before 1 keeps the row fixed.
    1 mark: relative references move in both directions / point to wrong cells. 1 mark: explanation of what $A and $1 lock.
Q26Formulas and functions · Challenge · Paper 3 style · 7 marks
  1. (a) Write a formula for F2 to calculate the delivery charge. Delivery is free if the order total in D2 is more than Rs 5000. Otherwise it is Rs 500 if E2 contains Express and Rs 250 for any other delivery type. [4]
  2. (b) State the charge for: (i) D2 = 6200, E2 = Express (ii) D2 = 3100, E2 = Express (iii) D2 = 5000, E2 = Standard. [3]
Show answer
  1. (a) =IF(D2>5000,0,IF(E2="Express",500,250))
    1 mark: IF(D2>5000,0,… ). 1 mark: nested IF testing E2="Express". 1 mark: 500 and 250 in the correct positions. 1 mark: correct syntax/brackets.
  2. (b) (i) 0 (ii) 500 (iii) 250
    1 mark each. (iii): 5000 is not more than 5000.
Q27Formulas and functions · Challenge · Paper 3 style · 4 marks

A family in Rawalpindi records monthly electricity bills (Rs) in B2:B13 for January to December. The bills for November and December have not arrived, so B12 and B13 are empty. B2:B11 contain 8450, 7920, 9310, 11240, 13680, 15020, 14760, 12890, 10330, 9050.

  1. (a) State the value displayed by =AVERAGE(B2:B13). [1]
  2. (b) State the value displayed by =SUM(B2:B13)/12. [1]
  3. (c) Explain why the two results are different and state which one gives the correct mean bill so far. [2]
Show answer
  1. (a) 11265
    B1: 112 650 ÷ 10 = 11 265 (blank cells ignored).
  2. (b) 9387.5
    B1: 112 650 ÷ 12 = 9387.5.
  3. (c) AVERAGE ignores the two empty cells and divides by 10 (the number of bills); SUM/12 divides by 12 including the months with no bill. AVERAGE gives the correct mean of the bills received.
    1 mark: AVERAGE ignores blanks / divides by 10. 1 mark: AVERAGE is correct.
Q28Formulas and functions · Challenge · Paper 3 style · 5 marks

A student's bank transactions (Rs) are in B2:B9. Deposits are positive and withdrawals negative: 5000, −1200, −350, 2500, −800, 1500, −2000, 700.

  1. (a) Write a function to calculate the total of all the withdrawals (negative values) and state its value. [2]
  2. (b) Write a formula using SUMIF and COUNTIF to calculate the mean deposit (positive values) and state its value. [2]
  3. (c) Write a single function that gives the same result as the formula in (b). [1]
Show answer
  1. (a) =SUMIF(B2:B9,"<0"); −4350
    1 mark function; B1: −1200 − 350 − 800 − 2000 = −4350.
  2. (b) =SUMIF(B2:B9,">0")/COUNTIF(B2:B9,">0"); 2425
    1 mark formula; B1: 9700 ÷ 4 = 2425.
  3. (c) =AVERAGEIF(B2:B9,">0")
    1 mark.
Q29Formulas and functions · Challenge · Paper 3 style · 5 marks

A garden centre's sheet has a named range Prices covering a table: column 1 product code, column 2 product name, column 3 unit price (Rs). The discount rate for loyal customers is in cell H1.

  1. (a) Write the formula in C2 to calculate the cost of the order: look up the unit price of the product code in A2 from the Prices range, multiply by the quantity in B2 and apply the discount in H1. It must work when replicated. [4]
  2. (b) A2 contains F07, whose unit price is Rs 1240. B2 contains 3 and H1 contains 10%. State the value displayed in C2. [1]
Show answer
  1. (a) =VLOOKUP(A2,Prices,3,FALSE)*B2*(1-$H$1)
    1 mark: VLOOKUP(A2,Prices,…). 1 mark: column 3, FALSE. 1 mark: ×B2. 1 mark: ×(1−$H$1) with absolute reference. Accept equivalent e.g. −…*$H$1.
  2. (b) 3348
    B1: 1240 × 3 × 0.9 = 3348.
Q30Formulas and functions · Challenge · Paper 3 style · 5 marks
  1. (a) A teacher wants C2 to show Pass when the mark in B2 is 50 or more. She has entered =IF(B2>50,"Pass","Fail"). Give a test value for B2 that would show the formula is wrong, and state the output it gives and the output expected. [2]
  2. (b) Write the corrected formula. [1]
  3. (c) Marks are whole numbers from 0 to 100. Give two further test values, other than your answer to (a), that test the corrected formula on each side of the boundary, with the expected output for each. [2]
Show answer
  1. (a) 50; it displays Fail but Pass is expected.
    1 mark: 50 (the boundary). 1 mark: Fail given, Pass expected.
  2. (b) =IF(B2>=50,"Pass","Fail")
    1 mark. Accept =IF(B2<50,"Fail","Pass").
  3. (c) 49 → Fail; 51 → Pass (accept e.g. 0 → Fail, 100 → Pass with explanation as extreme data).
    1 mark each: value with correct expected output.

Similar questions

Questions that test the same subtopic in different years, grouped so you can work on one skill at a time.

References only: find each question in its paper (official link where available, otherwise through your school).

Formulas and functions Rare2 questions · 2/9 sessions

Subtopics

Our analysis of how often each subtopic was examined and how many marks it carried, 2022 to May/June 2026.

SubtopicMarks indexedSessions
Formulas and functions Rare122/9

← All ICT topics