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

The tasks

  1. Basics (beginner): What were the total sales from January to June? Work it out in B8 with a formula.
  2. Basics (beginner): What is the average score? Work it out in B8.
  3. References (beginner): Fill C2:C5 with each price plus tax, using the tax rate in F1. Write one formula in C2 and copy it down: every row must use the rate in F1.
  4. Logic (beginner): In C2:C7, show Pass for a score of 50 or more and Fail for anything lower.
  5. Conditional sums and counts (intermediate): How many orders were over 100? Count them in E2 with a formula.
  6. Conditional sums and counts (intermediate): What are the total sales for the North region? Work it out in F2.
  7. Text (intermediate): Fill B2:B6 with each person's first name, taken from the full name in column A by a formula.
  8. Lookups (intermediate): What is the price of the product whose code is in F2? Put it in F3, so the answer changes when someone types another code in F2.
  9. 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.
  10. 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, like Ana Silva.
  11. Conditional sums and counts (advanced): What are Ana's total sales in the North region? Work it out in F2.
  12. Lookups (advanced): Find the sales for the rep in G1 in the month in G2. Put it in G3, so it updates when either one changes.
  13. 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.
  14. Dynamic arrays (advanced): List each region once, starting in C2, with one formula that fills the list by itself.
  15. 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

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

Browse the course