Relative, absolute and mixed cell references and range names; copying formulae; sorting and filtering data; pivot tables; and creating, labelling and linking charts and sheets.
6 narrated scenes. Press play, listen and read along — the points appear as they are explained. Use ‹ Prev / Next › or the scene bar to jump to any scene.
The dollar sign is one of the most examined symbols in the course. This lesson shows when a reference must stay fixed, and how to turn a table into a pivot table or a chart.
Narration uses your device’s built-in voice. No sound? Switch to “Captions only” — the captions advance on their own.
Copy a formula down and compare relative and absolute references.
Copy these into your notebook in your own words — that is how they stick.
B2 changes when copied.
$B$1 stays fixed; F4 toggles.
$B1 or B$1 fixes only column or row.
A name given to a cell or range, e.g. TaxRate.
Ascending/descending, one or more levels.
Shows rows meeting a condition; others hidden.
Summarises data by group.
Column/bar, line, pie; title, axes, legend.
3 quick games on this lesson. Earn XP and badges as you play — your best score for each game is saved. Games are for practice and do not change your exam readiness. More games in the Information Technology Arcade.
8 items modelled on real CSEC Paper 1 questions. Choose one answer for each, then check. Aim for 80% or better. Work each item on paper first.
Write full answers, then reveal the mark scheme and tick the points you earned (13 marks in total). Show all your working — method marks count. Your answers are saved on this device.
Question 1 [13 marks]
A shop owner keeps a price list in Sheet1 with the VAT rate typed once in cell B1. Prices are in A5:A12 and VAT amounts are calculated in column B.
(a) (a) Write the formula for B5 that can be copied down to B12 and always uses the rate in B1. [3]
(b) (b) Explain why the formula must use an absolute reference. [2]
(c) (c) Describe how the owner can show only the items costing more than $50. [3]
(d) (d) State one situation where a pivot table would help the owner. [2]
(e) (e) Name a suitable chart for showing each category’s share of total sales and state two items that must be added to it. [3]
Find these in your own past-paper booklets for extra timed practice. Items above are written in the style of these papers; any adapted from a specific question say so.