---
title: "Excel Test for Job Interviews: Free Timed Practice Test | PracticeExcel"
description: "Prepare for an employer's Excel test with 20 timed tasks in a live grid. SUMIFS, COUNTIFS, IF, VLOOKUP and INDEX MATCH, scored instantly."
canonical_url: "https://practiceexcelonline.com/tests/excel-test-for-job-interview"
locale: en
meta:
"og:description": "Prepare for an employer's Excel test with 20 timed tasks in a live grid. SUMIFS, COUNTIFS, IF, VLOOKUP and INDEX MATCH, scored instantly."
"og:image": "https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_~RXhjZWwgVGVzdCBmb3IgSm9iIEludGVydmlld3M6IEZyZWUgVGltZWQgUHJhY3RpY2UgVGVzdA%2Cdescription_~UHJlcGFyZSBmb3IgYW4gZW1wbG95ZXIncyBFeGNlbCB0ZXN0IHdpdGggMjAgdGltZWQgdGFza3MgaW4gYSBsaXZlIGdyaWQuIFNVTUlGUywgQ09VTlRJRlMsIElGLCBWTE9PS1VQIGFuZCBJTkRFWCBNQVRDSCwgc2NvcmVkIGluc3RhbnRseS4%2Ceyebrow_Excel%2Btests%2Bfor%2Bjob%2Bapplications%2Csite_practiceexcel%2Cprops_eyJncmlkIjp7ImNvbHMiOlsiQSIsIkIiLCJEIl0sInJvd3MiOlt7Im4iOjEsImNlbGxzIjpbIlJlZ2lvbiIsIlNhbGVzIiwiQ2VudHJhbCBEZW5tYXJrIHNoYXJlIl19LHsibiI6MiwiY2VsbHMiOlsiQ2FwaXRhbCBSZWdpb24iLCI0ODIwMDAiLCIiXX0seyJuIjozLCJjZWxscyI6WyJaZWFsYW5kIiwiMTk2MDAwIiwiIl19LHsibiI6NCwiY2VsbHMiOlsiU291dGhlcm4gRGVubWFyayIsIjMxMTAwMCIsIiJdfSx7Im4iOjUsImNlbGxzIjpbIkNlbnRyYWwgRGVubWFyayIsIjM1NDAwMCIsIiJdfSx7Im4iOjYsImNlbGxzIjpbIk5vcnRoIERlbm1hcmsiLCIxNTcwMDAiLCIiXX1dLCJ0YXJnZXQiOlsxLDJdfX0%2Cp_Ii90ZXN0cy9leGNlbC10ZXN0LWZvci1qb2ItaW50ZXJ2aWV3Ig%2Cs_AWHMwZmh4U67Lz4Q.png"
"og:image:height": "600"
"og:image:type": image/png
"og:image:width": "1200"
"og:title": "Excel Test for Job Interviews: Free Timed Practice Test | PracticeExcel"
"twitter:image": "https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_~RXhjZWwgVGVzdCBmb3IgSm9iIEludGVydmlld3M6IEZyZWUgVGltZWQgUHJhY3RpY2UgVGVzdA%2Cdescription_~UHJlcGFyZSBmb3IgYW4gZW1wbG95ZXIncyBFeGNlbCB0ZXN0IHdpdGggMjAgdGltZWQgdGFza3MgaW4gYSBsaXZlIGdyaWQuIFNVTUlGUywgQ09VTlRJRlMsIElGLCBWTE9PS1VQIGFuZCBJTkRFWCBNQVRDSCwgc2NvcmVkIGluc3RhbnRseS4%2Ceyebrow_Excel%2Btests%2Bfor%2Bjob%2Bapplications%2Csite_practiceexcel%2Cprops_eyJncmlkIjp7ImNvbHMiOlsiQSIsIkIiLCJEIl0sInJvd3MiOlt7Im4iOjEsImNlbGxzIjpbIlJlZ2lvbiIsIlNhbGVzIiwiQ2VudHJhbCBEZW5tYXJrIHNoYXJlIl19LHsibiI6MiwiY2VsbHMiOlsiQ2FwaXRhbCBSZWdpb24iLCI0ODIwMDAiLCIiXX0seyJuIjozLCJjZWxscyI6WyJaZWFsYW5kIiwiMTk2MDAwIiwiIl19LHsibiI6NCwiY2VsbHMiOlsiU291dGhlcm4gRGVubWFyayIsIjMxMTAwMCIsIiJdfSx7Im4iOjUsImNlbGxzIjpbIkNlbnRyYWwgRGVubWFyayIsIjM1NDAwMCIsIiJdfSx7Im4iOjYsImNlbGxzIjpbIk5vcnRoIERlbm1hcmsiLCIxNTcwMDAiLCIiXX1dLCJ0YXJnZXQiOlsxLDJdfX0%2Cp_Ii90ZXN0cy9leGNlbC10ZXN0LWZvci1qb2ItaW50ZXJ2aWV3Ig%2Cs_AWHMwZmh4U67Lz4Q.png"
---
> Index of every page on this site: [llms.txt](https://practiceexcelonline.com/llms.txt)
# **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%
=
30:0070 %
**Question 1 of 20**
In D2, calculate Central Denmark's share of the total sales, as a decimal (0.25 is 25%).
D2fx
| | A | B | C | D | E | F |
| --- | --- | --- | --- | --- | --- | --- |
| 1 | Region | Sales | | Central Denmark share | | |
| 2 | Capital Region | 482000 | | | | |
| 3 | Zealand | 196000 | | | | |
| 4 | Southern Denmark | 311000 | | | | |
| 5 | Central Denmark | 354000 | | | | |
| 6 | North 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/month**](https://practiceexcelonline.com/pricing) [**Already premium? Sign in**](https://practiceexcelonline.com/login?next=/tests/excel-test-for-job-interview)
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. [**1****One region's share of the total**](https://practiceexcelonline.com/practice/sum/sum-a-column)
2. [**2****Total of all orders not canceled**](https://practiceexcelonline.com/practice/sumif/sumif-greater-than)
3. [**3****Count the Copenhagen offices**](https://practiceexcelonline.com/practice/countif/countif-text)
4. [**4****Sales for one region in one quarter**](https://practiceexcelonline.com/practice/sumifs/sumifs-two-conditions)
5. [**5****Count orders between 100 and 500**](https://practiceexcelonline.com/practice/countifs/countifs-between-two-numbers)
6. [**6****Average deal size for a region and product**](https://practiceexcelonline.com/functions/averageifs)
7. [**7****Large orders for one customer**](https://practiceexcelonline.com/practice/sumifs/sumifs-criteria-from-cells)
8. [**8****Three-level performance rating**](https://practiceexcelonline.com/practice/if/nested-if)
9. [**9****Bonus when both conditions hold**](https://practiceexcelonline.com/practice/logical/if-and)
10. [**10****Flag invoices for review**](https://practiceexcelonline.com/practice/logical/if-or)
11. [**11****Boxes needed for an order**](https://practiceexcelonline.com/practice/round/roundup-boxes-needed)
12. [**12****Third-largest deal**](https://practiceexcelonline.com/practice/minmax/large-second-highest)
13. [**13****Revenue from units and prices**](https://practiceexcelonline.com/functions/sumproduct)
14. [**14****Weighted average purchase price**](https://practiceexcelonline.com/functions/sumproduct)
15. [**15****First name from a full name**](https://practiceexcelonline.com/functions/left)
16. [**16****Tidy up a badly typed name**](https://practiceexcelonline.com/functions/proper)
17. [**17****Build a cost-center code**](https://practiceexcelonline.com/functions/left)
18. [**18****Find an ID to the left of a name**](https://practiceexcelonline.com/practice/index-match/index-match-left-lookup)
19. [**19****Commission from a rate table**](https://practiceexcelonline.com/practice/vlookup/vlookup-approximate-match)
20. [**20****Two-way lookup: product and month**](https://practiceexcelonline.com/practice/index-match/index-match)
## **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**
- [**Excel for job interviews: what gets tested and how to prepare**](https://practiceexcelonline.com/learn/excel-for-job-interviews)
- [**Free Excel course online: learn Excel from your first formula to job-ready**](https://practiceexcelonline.com/learn/how-to-learn-excel)
- [**VLOOKUP vs XLOOKUP vs INDEX MATCH: which lookup to use**](https://practiceexcelonline.com/learn/vlookup-vs-xlookup-vs-index-match)
- [**Pivot tables explained, and the formulas that do the same job**](https://practiceexcelonline.com/learn/pivot-tables)
- [**Excel for finance and accounting: the skills you actually use**](https://practiceexcelonline.com/learn/excel-for-finance)
- [**Excel IF formulas: from one condition to many**](https://practiceexcelonline.com/learn/excel-if-function)
- [**Dates in Excel: how they work and the formulas you need**](https://practiceexcelonline.com/learn/excel-dates)
- [**How to clean data in Excel with formulas**](https://practiceexcelonline.com/learn/clean-data-in-excel)
- [**Excel keyboard shortcuts worth learning, and how to make them stick**](https://practiceexcelonline.com/learn/excel-keyboard-shortcuts)
## **Other Excel tests**
- [**Indeed Excel assessment practice test**](https://practiceexcelonline.com/tests/indeed-excel-assessment)
- [**Kenexa Excel test practice**](https://practiceexcelonline.com/tests/kenexa-excel-test)
- [**SHL Excel test practice**](https://practiceexcelonline.com/tests/shl-excel-test)
- [**iMocha Excel test practice**](https://practiceexcelonline.com/tests/imocha-excel-test)
- [**TestGorilla Excel test practice**](https://practiceexcelonline.com/tests/testgorilla-excel-test)
- [**Excel test for finance jobs**](https://practiceexcelonline.com/tests/excel-test-for-finance)
- [**Excel test for accounting and bookkeeping**](https://practiceexcelonline.com/tests/excel-test-for-accountants)
- [**Excel test for budgeting and planning**](https://practiceexcelonline.com/tests/excel-test-for-budgeting)
- [**Excel test for admin jobs**](https://practiceexcelonline.com/tests/excel-test-for-admin-jobs)
- [**Excel test for data analysts**](https://practiceexcelonline.com/tests/excel-test-for-data-analysts)
```json
{"@context":"https://schema.org","@graph":[{"@id":"https://practiceexcelonline.com/#identity","@type":"Organization","name":"PracticeExcel","url":"https://practiceexcelonline.com/","logo":{"@id":"https://practiceexcelonline.com/#logo"}},{"@id":"https://practiceexcelonline.com/#website","@type":"WebSite","inLanguage":"en-US","name":"PracticeExcel","url":"https://practiceexcelonline.com/","alternateName":["Practice Excel Online","PracticeExcelOnline.com"],"publisher":{"@id":"https://practiceexcelonline.com/#identity"},"workTranslation":{"@id":"https://excelopgaver.dk/#website"}},{"@id":"https://practiceexcelonline.com/tests/excel-test-for-job-interview#webpage","description":"Prepare for an employer's Excel test with 20 timed tasks in a live grid. SUMIFS, COUNTIFS, IF, VLOOKUP and INDEX MATCH, scored instantly.","name":"Excel Test for Job Interviews: Free Timed Practice Test","url":"https://practiceexcelonline.com/tests/excel-test-for-job-interview","@type":["WebPage","FAQPage"],"breadcrumb":{"@id":"https://practiceexcelonline.com/tests/excel-test-for-job-interview#breadcrumb"},"isPartOf":{"@id":"https://practiceexcelonline.com/#website"},"mainEntity":[{"@id":"https://practiceexcelonline.com/tests/excel-test-for-job-interview#/schema/question/1"},{"@id":"https://practiceexcelonline.com/tests/excel-test-for-job-interview#/schema/question/2"},{"@id":"https://practiceexcelonline.com/tests/excel-test-for-job-interview#/schema/question/3"},{"@id":"https://practiceexcelonline.com/tests/excel-test-for-job-interview#/schema/question/4"},{"@id":"https://practiceexcelonline.com/tests/excel-test-for-job-interview#/schema/question/5"}],"potentialAction":[{"@type":"ReadAction","target":["https://practiceexcelonline.com/tests/excel-test-for-job-interview"]}],"primaryImageOfPage":{"@id":"https://practiceexcelonline.com/#logo"}},{"@id":"https://practiceexcelonline.com/tests/excel-test-for-job-interview#breadcrumb","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","name":"Home","item":"https://practiceexcelonline.com","position":1},{"@type":"ListItem","name":"Excel tests for job applications","item":"https://practiceexcelonline.com/tests","position":2},{"@type":"ListItem","name":"Excel Test for Job Interviews: Free Timed Practice Test","position":3}]},{"@id":"https://practiceexcelonline.com/tests/excel-test-for-job-interview#/schema/question/1","@type":"Question","inLanguage":"en-US","name":"What Excel skills do employers test?","acceptedAnswer":{"@type":"Answer","text":"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."}},{"@id":"https://practiceexcelonline.com/tests/excel-test-for-job-interview#/schema/question/2","@type":"Question","inLanguage":"en-US","name":"How long does an Excel test for a job take?","acceptedAnswer":{"@type":"Answer","text":"Usually 20 to 45 minutes. This practice test gives you 30 minutes for 20 questions, which is a similar pace."}},{"@id":"https://practiceexcelonline.com/tests/excel-test-for-job-interview#/schema/question/3","@type":"Question","inLanguage":"en-US","name":"What score should I aim for?","acceptedAnswer":{"@type":"Answer","text":"The passing score here is 70%, 14 of 20. If you reach 80% or more you are well prepared for most employer tests."}},{"@id":"https://practiceexcelonline.com/tests/excel-test-for-job-interview#/schema/question/4","@type":"Question","inLanguage":"en-US","name":"Does a typed number count as an answer?","acceptedAnswer":{"@type":"Answer","text":"No. Like many employer tests, each answer has to be a formula that gives the right result even when the data changes."}},{"@id":"https://practiceexcelonline.com/tests/excel-test-for-job-interview#/schema/question/5","@type":"Question","inLanguage":"en-US","name":"Do I get a certificate?","acceptedAnswer":{"@type":"Answer","text":"Yes. Pass the full test with a verified email and you get a certificate with a public link for your résumé or LinkedIn."}},{"@id":"https://practiceexcelonline.com/tests/excel-test-for-job-interview#/schema/course/1","@type":"Course","description":"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.","educationalLevel":"Intermediate","inLanguage":"en-US","name":"Excel test for job interviews","teaches":"SUM, SUMIF, COUNTIF, SUMIFS, COUNTIFS, AVERAGEIFS, IF, LOGICAL, ROUND, MINMAX, SUMPRODUCT, LEFT, PROPER, INDEX-MATCH, VLOOKUP","timeRequired":"PT30M","provider":{"@id":"https://practiceexcelonline.com/#identity"}},{"@id":"https://practiceexcelonline.com/#logo","@type":"ImageObject","caption":"PracticeExcel","contentUrl":"https://practiceexcelonline.com/brand/practiceexcel/icon-512.png","inLanguage":"en-US","url":"https://practiceexcelonline.com/brand/practiceexcel/icon-512.png"}]}
```
## Sitemap
See the full [sitemap](https://practiceexcelonline.com/sitemap.md) for all pages.