Practice exams 6 questions 35 minutes
Analyst screening test
Six realistic tasks on real-looking data, two of them across several sheets, in the style of a test set before an interview.
The paper
6 questions in 35 minutes. Answer them in any order.
Exam conditions
No hints, and nothing is marked until you hand the paper in or the time runs out.
Marking
A question is right when every answer cell is right and still right when the data changes. Any working formula counts.
Loading spreadsheet…
What is on the paper
- Q1 Questions about a staff list
- Q2 Stock check
- Q3 A quarter of spending
- Q4 Orders and a price list
- Q5 Who are the biggest customers?
- Q6 Payroll from two sheets