/en-tutor-prep-s1-ict-spreadsheet-basics-formulas-charts-practice-4/
/en-tutor-prep-s1-ict-spreadsheet-basics-formulas-charts-practice-4/
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 4: Common mistakes corrected

Paper 4: Common mistakes corrected

  • 2026-11-21

Paper 4: Common mistakes corrected

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

Paper 4 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 Retry

02 Questions (10 items)

  1. FoundationAn entry =A1+A2 is typed without the leading equals sign. What happens?
  2. FoundationA1 holds 12 and A2 holds 8. What does =A1&A2 return?
  3. FoundationA formula copied from C1 to D1 gives a wrong result. What is the usual cause?
  4. FoundationA pie chart is used to show marks over five years. What is wrong?
  5. IntermediateWhat does the value #DIV/0! mean?
  6. IntermediateThree cells hold 10, 20 and 60 while two are blank. What divisor does AVERAGE use?
  7. ChallengeA cell holds 0.5 and is formatted as a percentage. What value is stored?
  8. ChallengeOnly one column is selected before sorting. What is the risk?
  9. Error redoHow do merged cells affect later work?
  10. Error redoA row is added at the end of a table but the chart ignores it. Why?

03 Answers and one-line notes

# Answer One-line note
1 It becomes text and nothing is calculated. The equals sign starts a formula; without it the entry is plain text.
2 The text 128 The ampersand joins text, so the two values are glued rather than added.
3 Relative references shift with the position and point at the wrong cells. Columns or rows that must stay put need dollar signs.
4 A pie chart does not show trends. Trends belong in a line chart; a pie chart only shows shares.
5 The divisor is zero or blank. Check that the divisor cell actually holds a number.
6 3 AVERAGE divides by the number of numeric cells, so 90 over 3 gives 30.
7 0.5 Percentage formatting changes the display only, not the stored value.
8 Rows are broken up and values no longer match their records. Select the whole table before sorting.
9 They block sorting and fill operations. Only the top left cell of a merged block keeps its value.
10 The chart range does not include the new row. Reset the chart range or convert the data into a table.

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 →