Practice exams 8 questions 30 minutes
Advanced test
Dynamic arrays, LET, SUMPRODUCT and finance functions, finishing with a commission report.
The paper
8 questions in 30 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 Filter a team and sort by points
- Q2 List each value once
- Q3 Weighted average with LET
- Q4 Total revenue in one formula
- Q5 Net present value of a project
- Q6 Monthly mortgage payment
- Q7 Rate of return with real dates
- Q8 Commission report