Practice exams 10 questions 15 minutes
Beginner test
Totals, averages, simple decisions and text: the formulas every Excel user should manage without help.
The paper
10 questions in 15 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 Add up a column
- Q2 Average a column
- Q3 Pass or fail
- Q4 Highest minus lowest
- Q5 Count the replies
- Q6 Round to pence
- Q7 Join first and last names
- Q8 Either condition will do
- Q9 Check a length
- Q10 A week at the café