Written
Spreadsheet theory for the written test
Compare references, functions, charts and data tools through their results.
Draw reference movement
Use a small grid to see how relative, absolute and mixed references change when copied.
Group functions by input and output
Compare logical, date, text, statistical and lookup functions, including blanks and error values.
40 items · 40 min40 minutesFloors + 70
Check prerequisites for data tools
Sorting, filtering, subtotals, pivots and validation depend on headers, ranges and blank rows.
Choose charts from the communication goal
Decide whether the task is comparison, trend or composition before choosing chart, axis and series.