/en-tutor-prep-s1-ict-spreadsheet-basics-formulas-charts-practice-3/
/en-tutor-prep-s1-ict-spreadsheet-basics-formulas-charts-practice-3/
General Inquiry: info@TutorZone.com.hk
Office Hours: Monday to Saturday - 9:00 AM to 6:00 PM
WhatsApp Monday to Sunday - 24 hours
Hotline: +852 6828 1809
Instant Support: +852 9061 3106

Paper 3: Multi-step calculations

Paper 3: Multi-step calculations

  • 2026-11-21

Paper 3: Multi-step calculations

Chapter practice with ten items, answers and a one-line note for each, about 25 minutes.

Paper 3 Ten items on this chapter with answers for immediate marking.

01 Paper details (check answers afterwards)

Item Detail
Questions 10
Suggested time 25
Difficulty mix Foundation 4 · Intermediate 2 · Challenge 2 · Error redo 2
Chapter Chapter: Spreadsheet basics: formulas and charts
Level Challenge

02 Questions (10 items)

  1. FoundationUnit price is 12.5 dollars for 240 items, then a 15 percent discount applies. What is the amount payable?
  2. FoundationA2 holds 800 and B1 holds 0.05. What does =A2*(1+$B$1) return?
  3. FoundationThree monthly expenses are 1,250, 1,480 and 1,320. What is the average per month?
  4. FoundationSpending rises from 3,600 dollars to 4,050 dollars. What is the percentage increase?
  5. IntermediateC2 holds 58. What does =IF(C2>=60,”pass”,”fail”) show?
  6. IntermediateOne slice of a pie chart is 25 percent. What angle does it take?
  7. ChallengeA yearly budget of 48,000 dollars means 4,000 a month, but actual spending is 4,320 a month. What is the overspend?
  8. ChallengeSix subjects average 68 marks. How many marks must be added to reach an average of 72?
  9. Error redoA filter leaves 87 of 250 rows. What share of the rows is hidden?
  10. Error redoWhat happens to a chart after its source range is changed?

03 Answers and one-line notes

# Answer One-line note
1 2,550 dollars 12.5 times 240 gives 3,000, and 3,000 times 0.85 gives 2,550.
2 840 The absolute reference keeps B1 fixed, and 800 times 1.05 gives 840.
3 1,350 dollars The total of 4,050 divided by three gives 1,350.
4 12.5 percent The rise of 450 divided by the original 3,600 gives 0.125.
5 fail 58 is below 60, so the test fails and IF returns the second result.
6 90 degrees 360 degrees times 0.25 gives 90 degrees.
7 8 percent The extra 320 divided by 4,000 gives 0.08.
8 24 marks 68 times 6 is 408 and 72 times 6 is 432, a gap of 24.
9 65.2 percent 163 hidden rows divided by 250 rows is about 0.652.
10 The chart is redrawn from the new range. A chart is linked to its range, so edits show up immediately.

04 What to do after marking

  • After marking, redo only the wrong items and write down which step went wrong (formula, unit, or misread number).
  • Repeat the same item two days later; move to the next paper only when both attempts are correct.
  • Parents only need the answer and note columns; there is no need to explain every item.

Want the whole chapter? See all four difficulty papers on the chapter page.Tutor Registration →

Questions and answers are written originally by the TutorZone team and are not taken from any school, publisher or examination authority paper. Every value is checked by computer.

Join as a tutor or coach — academic, music, sports, arts, STEM. Free to register. See how it works →