Written
Spreadsheet theory for the written test
Compare references, functions, charts and data tools by their resulting behaviour.
Fix reference behaviour first
Use a small grid to see how relative, absolute and mixed references move when copied.
Classify functions by input and output
Compare condition, lookup, date, text and statistical functions, including blank, error and approximate-match behaviour.
60 items · 60 min90 minutesFloors + average
Check prerequisites for data tools
Sorting, filtering, subtotals, pivots and validation depend on headers, ranges and criteria.
Choose charts from the communication goal
Decide whether the task is comparison, trend or composition before choosing chart, axis and series settings.