Practice exams 10 questions 25 minutes
Intermediate test
Conditional sums and counts, lookups, text and dates: what most office jobs mean by good at Excel.
The paper
10 questions in 25 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 Total sales for one region
- Q2 Count orders that meet three conditions
- Q3 Look up a price by product code
- Q4 Look to the left with INDEX and MATCH
- Q5 Grade the scores
- Q6 Handle a divide by zero
- Q7 Take the first characters
- Q8 Work out ages
- Q9 Rank a list
- Q10 Sales by region