PracticeExcelSign in
Excel tests for job applications

Excel test for job interviews

Many employers test Excel before they hire for finance, admin, sales and analyst roles, usually with a short timed task at the interview or online beforehand. This practice test gives you 20 tasks of the kind those tests use, from conditional sums and text formulas to INDEX and MATCH, in a live grid with a 30-minute clock.

20 questions · 30 minutes · passing score 70%

Question 1 of 20

In D2, calculate Central Denmark's share of the total sales, as a decimal (0.25 is 25%).

D2
ABCDEF
1Region Sales Central Denmark share
2Capital Region 482000
3Zealand 196000
4Southern Denmark 311000
5Central Denmark 354000
6North Denmark 157000
7
8

No tips during the test. I'm back with help when the clock stops.

The free preview is the first 10 questions in 15 minutes. It isn't saved.

Unlock the full test from $19/monthAlready premium? Sign in

Premium gets you the full 20-question test, your score history and a certificate when you pass.

What employers test

An employer's Excel test is rarely about obscure features. It checks the formulas people use every day at work: totals with conditions (SUMIF and SUMIFS), counts (COUNTIF and COUNTIFS), rounding prices and amounts, decisions with IF, AND and OR, tidying up text with LEFT, FIND, TRIM and PROPER, and lookups that pull a value from another table with VLOOKUP, INDEX and MATCH or XLOOKUP.

Most tests are timed, and many are set up so that a typed number scores nothing: the answer has to be a formula that still works when the data changes. This practice test checks your formulas the same way.

How this practice test works

You have 30 minutes for 20 questions, each with its own small sheet, written for this test only. Click the answer cell, type your formula and press Enter, the same keys as in Excel. Skip whatever you are unsure of and come back to it later. Your answers are marked when you hand in, or automatically when the time is up.

The result shows your score, which questions you missed and the lesson or function page that teaches each one, so you know exactly what to practice before the real test.

Who it is for

Anyone with an Excel test coming up for a job in finance, accounting, administration, sales operations, HR or data analysis. If you are not sure of the basics yet, start with the Indeed practice test, which begins with SUM and AVERAGE, and come back to this one afterwards.

What the test covers

Each question practices one of these skills. Follow a link to practice it before you start.

  1. 1One region's share of the total
  2. 2Total of all orders not canceled
  3. 3Count the Copenhagen offices
  4. 4Sales for one region in one quarter
  5. 5Count orders between 100 and 500
  6. 6Average deal size for a region and product
  7. 7Large orders for one customer
  8. 8Three-level performance rating
  9. 9Bonus when both conditions hold
  10. 10Flag invoices for review
  11. 11Boxes needed for an order
  12. 12Third-largest deal
  13. 13Revenue from units and prices
  14. 14Weighted average purchase price
  15. 15First name from a full name
  16. 16Tidy up a badly typed name
  17. 17Build a cost-center code
  18. 18Find an ID to the left of a name
  19. 19Commission from a rate table
  20. 20Two-way lookup: product and month

Questions

What Excel skills do employers test?

Conditional sums and counts (SUMIF, SUMIFS, COUNTIFS), rounding, IF with AND and OR, text clean-up, SUMPRODUCT and lookups with VLOOKUP, INDEX and MATCH or XLOOKUP. This practice test covers all of them.

How long does an Excel test for a job take?

Usually 20 to 45 minutes. This practice test gives you 30 minutes for 20 questions, which is a similar pace.

What score should I aim for?

The passing score here is 70%, 14 of 20. If you reach 80% or more you are well prepared for most employer tests.

Does a typed number count as an answer?

No. Like many employer tests, each answer has to be a formula that gives the right result even when the data changes.

Do I get a certificate?

Yes. Pass the full test with a verified email and you get a certificate with a public link for your résumé or LinkedIn.

Read the guide

Other Excel tests