sparklines
1 sub-question across 1 paper, 2 marks total.
Computer Applications Technology 2026
In the Summary sheet, insert a line sparkline in E2 showing the Quarterly totals for 2025 from B11:B14.
Show answerHide answer
Go to the Summary sheet and click E2.
Insert → Sparklines → Line.
Data Range:
B11:B14. Location Range:$E$2. OK.Save and close 4_Events.xlsx.
Why this earns the marks
one mark for the Line type, one for the correct data and location — Excel offers several sparkline types (Line, Column, Win/Loss), each visualising the same kind of data differently, so the type itself is a deliberate, checkable choice, not just a default. A sparkline sits inside a single cell as a miniature chart, so the Location Range must be E2 and not a range: unlike a normal chart (a separate floating object that can span any area), a sparkline is drawn as cell content, so it can only ever belong to exactly one cell.