Excel skills test
15 real tasks in a live spreadsheet, from a first SUM to lookups and dynamic arrays. Write the formulas the way you would at work: any formula that gets the right answer counts. It's free, takes about 15 minutes, and there's nothing to sign up for.
What it covers
- Basics
- References
- Logic
- Conditional sums and counts
- Text
- Lookups
- Dates
- Dynamic arrays
The tasks
- Basics (beginner): What were the total sales from January to June? Work it out in
B8with a formula. - Basics (beginner): What is the average score? Work it out in
B8. - References (beginner): Fill
C2:C5with each price plus tax, using the tax rate inF1. Write one formula inC2and copy it down: every row must use the rate inF1. - Logic (beginner): In
C2:C7, show Pass for a score of 50 or more and Fail for anything lower. - Conditional sums and counts (intermediate): How many orders were over 100? Count them in
E2with a formula. - Conditional sums and counts (intermediate): What are the total sales for the North region? Work it out in
F2. - Text (intermediate): Fill
B2:B6with each person's first name, taken from the full name in column A by a formula. - Lookups (intermediate): What is the price of the product whose code is in
F2? Put it inF3, so the answer changes when someone types another code inF2. - Dates (intermediate): How many working days (Monday to Friday) does the project run, counting both the start and the end date? Work it out in
C2. - Text (intermediate): The names in column A have stray spaces and odd capitals. In
B2:B4, show them tidy: no extra spaces, and a capital only at the start of each name, likeAna Silva. - Conditional sums and counts (advanced): What are Ana's total sales in the North region? Work it out in
F2. - Lookups (advanced): Find the sales for the rep in
G1in the month inG2. Put it inG3, so it updates when either one changes. - Logic (advanced): In
C2:C7, give each score a grade: A for 85 or more, B for 70 or more, C for 50 or more, and F below that. - Dynamic arrays (advanced): List each region once, starting in
C2, with one formula that fills the list by itself. - Dynamic arrays (advanced): List the reps with sales over 1,000, starting in
E2, with one formula that keeps up when the numbers change.
Your level
- Expert (14–15): Lookups, conditional maths, text, dates and dynamic arrays: you handle the lot.
- Advanced (10–13): You know your way around lookups and conditional formulas. A few advanced tools to go.
- Intermediate (6–9): The everyday formulas are there. Lookups and conditional sums are your next step.
- Beginner (0–5): A great place to start. The basics track will have you writing formulas with confidence.
It's a practice test to show you what to learn next, not an official certification. Missed a task? The results link to the lesson that teaches it.
Tests for particular jobs
- Excel test for accountants: Ten tasks from the working day of an accountant, bookkeeper or finance assistant, in a live spreadsheet: margins, a running balance, overdue invoices, a ledger to total, a loan and a net present value.
- Excel test for data analysts: Ten tasks an analyst gets asked before lunch, in a live spreadsheet: a median, shares and growth rates, counts and averages with conditions, a ranking, distinct customers, the top three, the best seller and a correlation.
- Excel test for office and admin jobs: Ten everyday tasks for an administrative assistant, office manager or coordinator, in a live spreadsheet: weekly hours, names and email addresses, an RSVP count, overdue tasks, a phone list, expense claims, deadlines and a sorted list.