--- title: "SHL Excel Test Practice: 20 Timed Questions | PracticeExcel" description: "Practice for the SHL Microsoft Excel test with 20 timed tasks in a live grid. Type real formulas, get your score at once and see what to study next." canonical_url: "https://practiceexcelonline.com/tests/shl-excel-test" locale: en meta: "og:description": "Practice for the SHL Microsoft Excel test with 20 timed tasks in a live grid. Type real formulas, get your score at once and see what to study next." "og:image": "https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_~U0hMIEV4Y2VsIFRlc3QgUHJhY3RpY2U6IDIwIFRpbWVkIFF1ZXN0aW9ucw%2Cdescription_~UHJhY3RpY2UgZm9yIHRoZSBTSEwgTWljcm9zb2Z0IEV4Y2VsIHRlc3Qgd2l0aCAyMCB0aW1lZCB0YXNrcyBpbiBhIGxpdmUgZ3JpZC4gVHlwZSByZWFsIGZvcm11bGFzLCBnZXQgeW91ciBzY29yZSBhdCBvbmNlIGFuZCBzZWUgd2hhdCB0byBzdHVkeSBuZXh0Lg%2Ceyebrow_Excel%2Btests%2Bfor%2Bjob%2Bapplications%2Csite_practiceexcel%2Cprops_eyJncmlkIjp7ImNvbHMiOlsiQSIsIkIiLCJDIiwiRSJdLCJyb3dzIjpbeyJuIjoxLCJjZWxscyI6WyJNb250aCIsIkJ1ZGdldCIsIkFjdHVhbCIsIkFjdHVhbCBtaW51cyBidWRnZXQiXX0seyJuIjoyLCJjZWxscyI6WyJKYW4iLCI1MDAwMCIsIjQ4MjAwIiwiIl19LHsibiI6MywiY2VsbHMiOlsiRmViIiwiNTAwMDAiLCI1MzEwMCIsIiJdfSx7Im4iOjQsImNlbGxzIjpbIk1hciIsIjU1MDAwIiwiNTQ2MDAiLCIiXX0seyJuIjo1LCJjZWxscyI6WyJBcHIiLCI1NTAwMCIsIjU4OTAwIiwiIl19LHsibiI6NiwiY2VsbHMiOlsiTWF5IiwiNjAwMDAiLCI1NzQwMCIsIiJdfV0sInRhcmdldCI6WzEsM119fQ%2Cp_Ii90ZXN0cy9zaGwtZXhjZWwtdGVzdCI%2Cs_7qOg7QTxN7TSa4AV.png" "og:image:height": "600" "og:image:type": image/png "og:image:width": "1200" "og:title": "SHL Excel Test Practice: 20 Timed Questions | PracticeExcel" "twitter:image": "https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_~U0hMIEV4Y2VsIFRlc3QgUHJhY3RpY2U6IDIwIFRpbWVkIFF1ZXN0aW9ucw%2Cdescription_~UHJhY3RpY2UgZm9yIHRoZSBTSEwgTWljcm9zb2Z0IEV4Y2VsIHRlc3Qgd2l0aCAyMCB0aW1lZCB0YXNrcyBpbiBhIGxpdmUgZ3JpZC4gVHlwZSByZWFsIGZvcm11bGFzLCBnZXQgeW91ciBzY29yZSBhdCBvbmNlIGFuZCBzZWUgd2hhdCB0byBzdHVkeSBuZXh0Lg%2Ceyebrow_Excel%2Btests%2Bfor%2Bjob%2Bapplications%2Csite_practiceexcel%2Cprops_eyJncmlkIjp7ImNvbHMiOlsiQSIsIkIiLCJDIiwiRSJdLCJyb3dzIjpbeyJuIjoxLCJjZWxscyI6WyJNb250aCIsIkJ1ZGdldCIsIkFjdHVhbCIsIkFjdHVhbCBtaW51cyBidWRnZXQiXX0seyJuIjoyLCJjZWxscyI6WyJKYW4iLCI1MDAwMCIsIjQ4MjAwIiwiIl19LHsibiI6MywiY2VsbHMiOlsiRmViIiwiNTAwMDAiLCI1MzEwMCIsIiJdfSx7Im4iOjQsImNlbGxzIjpbIk1hciIsIjU1MDAwIiwiNTQ2MDAiLCIiXX0seyJuIjo1LCJjZWxscyI6WyJBcHIiLCI1NTAwMCIsIjU4OTAwIiwiIl19LHsibiI6NiwiY2VsbHMiOlsiTWF5IiwiNjAwMDAiLCI1NzQwMCIsIiJdfV0sInRhcmdldCI6WzEsM119fQ%2Cp_Ii90ZXN0cy9zaGwtZXhjZWwtdGVzdCI%2Cs_7qOg7QTxN7TSa4AV.png" --- > Index of every page on this site: [llms.txt](https://practiceexcelonline.com/llms.txt) # **SHL Excel test practice** SHL's catalog of skills tests includes Microsoft Excel, and employers often add it to an online assessment next to numerical or verbal reasoning. This practice test gives you 20 spreadsheet tasks in 25 minutes, typed as real formulas in a live grid, so you can find out how quick and accurate you are before the real assessment. 20 questions · 25 minutes · passing score 70% = 25:0070 % **Question 1 of 20** In E2, calculate how far the actual total for the six months is above the budget total (a negative result means under budget). E2fx | | A | B | C | D | E | F | | --- | --- | --- | --- | --- | --- | --- | | 1 | Month | Budget | Actual | | Actual minus budget | | | 2 | Jan | 50000 | 48200 | | | | | 3 | Feb | 50000 | 53100 | | | | | 4 | Mar | 55000 | 54600 | | | | | 5 | Apr | 55000 | 58900 | | | | | 6 | May | 60000 | 57400 | | | | | 7 | Jun | 60000 | 61800 | | | | | 8 | | | | | | | No tips during the test. I'm back with help when the clock stops. The free preview is the first 10 questions in 13 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/shl-excel-test) Premium gets you the full 20-question test, your score history and a certificate when you pass. ## **What the SHL Excel test checks** SHL's Excel tests are about using a spreadsheet at work, not about knowing menu names by heart. The employer picks the test and its level, so the exact questions and the time limit vary from one assessment to the next. If the job involves numbers, expect the Excel part to look like the data you would handle in it: budgets against actuals, shares of a total, averages that should leave something out, conditional sums with two or three conditions and lookups that return a value or a name. This practice test is built from that kind of task. ## **How this practice test works** You have 25 minutes for 20 questions, a slightly faster pace than our other tests, because SHL assessments are often taken in one sitting with several tests in a row. Each question has its own small sheet, written for this test only. Click the answer cell, type your formula and press Enter, as in Excel. You can skip a question and come back to it. Nothing is marked until you hand in, and every answer must be a formula that still works when the data changes. The result shows your score, the questions you missed and where to practice each one. ## **How to prepare** Start with the free preview of the first 10 questions. If you run out of time rather than knowledge, practice the same kind of task until the formula comes without thinking: SUMIFS, AVERAGEIF and INDEX with MATCH are the ones that slow most people down. If the assessment also has a numerical reasoning part, practice percentages and ratios by hand too. ## **Not affiliated with SHL** PracticeExcel is not affiliated with SHL, and this is not SHL's test. We wrote every question ourselves to practice the same skills, so a good score here means you know the formulas, not that you have seen the real questions. ## **What the test covers** Each question practices one of these skills. Follow a link to practice it before you start. 1. [**1****Over or under budget for the half year**](https://practiceexcelonline.com/practice/sum/sum-separate-ranges) 2. [**2****Share of the sales target**](https://practiceexcelonline.com/practice/first-formulas/multiply-two-cells) 3. [**3****Count the orders over 1,000**](https://practiceexcelonline.com/practice/countif/countif-greater-than) 4. [**4****Sales for the rep named in a cell**](https://practiceexcelonline.com/practice/sumif/sumif-criteria-from-a-cell) 5. [**5****Average salary in one department**](https://practiceexcelonline.com/practice/averageif/averageif) 6. [**6****Second-lowest bid**](https://practiceexcelonline.com/functions/small) 7. [**7****Average without the zero days**](https://practiceexcelonline.com/practice/averageif/averageif) 8. [**8****Paid hours from minutes worked**](https://practiceexcelonline.com/functions/rounddown) 9. [**9****Shipping price by weight band**](https://practiceexcelonline.com/functions/ifs) 10. [**10****Three-level performance rating**](https://practiceexcelonline.com/practice/if/nested-if) 11. [**11****Sales for one region in one quarter**](https://practiceexcelonline.com/practice/sumifs/sumifs-two-conditions) 12. [**12****Average deal size for a region and product**](https://practiceexcelonline.com/functions/averageifs) 13. [**13****Show "Not found" for a missing code**](https://practiceexcelonline.com/practice/iferror/iferror-vlookup) 14. [**14****Find an ID to the left of a name**](https://practiceexcelonline.com/practice/index-match/index-match-left-lookup) 15. [**15****Count the months above average**](https://practiceexcelonline.com/practice/countif/countif-criteria-from-a-cell) 16. [**16****Sales with three conditions**](https://practiceexcelonline.com/practice/sumifs/sumifs-two-conditions) 17. [**17****One category's share of costs**](https://practiceexcelonline.com/practice/sumif/sumif-with-sum-range) 18. [**18****Weighted average purchase price**](https://practiceexcelonline.com/functions/sumproduct) 19. [**19****Order line total from a price list**](https://practiceexcelonline.com/practice/vlookup/vlookup-exact-match) 20. [**20****Name of the top seller**](https://practiceexcelonline.com/practice/index-match/index-match) ## **Questions**
### What does the SHL Excel test cover? Practical spreadsheet work at the level the employer chooses, such as totals and shares, conditional sums and averages, IF and lookups. This practice test covers those with 20 questions.
### How long is the SHL Excel test? That depends on the test and level the employer picks. Our practice test gives you 25 minutes for 20 questions, a brisk pace that gets you used to working against the clock.
### Is the free preview timed? Yes. The preview is the first 10 questions in 13 minutes, the same pace as the full test.
### What score should I aim for? The passing score here is 70%, 14 of 20. Aim for 80% or more before the real assessment.
### 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) - [**Excel for finance and accounting: the skills you actually use**](https://practiceexcelonline.com/learn/excel-for-finance) ## **Other Excel tests** - [**Indeed Excel assessment practice test**](https://practiceexcelonline.com/tests/indeed-excel-assessment) - [**Excel test for job interviews**](https://practiceexcelonline.com/tests/excel-test-for-job-interview) - [**Kenexa Excel test practice**](https://practiceexcelonline.com/tests/kenexa-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/shl-excel-test#webpage","description":"Practice for the SHL Microsoft Excel test with 20 timed tasks in a live grid. Type real formulas, get your score at once and see what to study next.","name":"SHL Excel Test Practice: 20 Timed Questions","url":"https://practiceexcelonline.com/tests/shl-excel-test","@type":["WebPage","FAQPage"],"breadcrumb":{"@id":"https://practiceexcelonline.com/tests/shl-excel-test#breadcrumb"},"isPartOf":{"@id":"https://practiceexcelonline.com/#website"},"mainEntity":[{"@id":"https://practiceexcelonline.com/tests/shl-excel-test#/schema/question/1"},{"@id":"https://practiceexcelonline.com/tests/shl-excel-test#/schema/question/2"},{"@id":"https://practiceexcelonline.com/tests/shl-excel-test#/schema/question/3"},{"@id":"https://practiceexcelonline.com/tests/shl-excel-test#/schema/question/4"},{"@id":"https://practiceexcelonline.com/tests/shl-excel-test#/schema/question/5"}],"potentialAction":[{"@type":"ReadAction","target":["https://practiceexcelonline.com/tests/shl-excel-test"]}],"primaryImageOfPage":{"@id":"https://practiceexcelonline.com/#logo"}},{"@id":"https://practiceexcelonline.com/tests/shl-excel-test#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":"SHL Excel Test Practice: 20 Timed Questions","position":3}]},{"@id":"https://practiceexcelonline.com/tests/shl-excel-test#/schema/question/1","@type":"Question","inLanguage":"en-US","name":"What does the SHL Excel test cover?","acceptedAnswer":{"@type":"Answer","text":"Practical spreadsheet work at the level the employer chooses, such as totals and shares, conditional sums and averages, IF and lookups. This practice test covers those with 20 questions."}},{"@id":"https://practiceexcelonline.com/tests/shl-excel-test#/schema/question/2","@type":"Question","inLanguage":"en-US","name":"How long is the SHL Excel test?","acceptedAnswer":{"@type":"Answer","text":"That depends on the test and level the employer picks. Our practice test gives you 25 minutes for 20 questions, a brisk pace that gets you used to working against the clock."}},{"@id":"https://practiceexcelonline.com/tests/shl-excel-test#/schema/question/3","@type":"Question","inLanguage":"en-US","name":"Is the free preview timed?","acceptedAnswer":{"@type":"Answer","text":"Yes. The preview is the first 10 questions in 13 minutes, the same pace as the full test."}},{"@id":"https://practiceexcelonline.com/tests/shl-excel-test#/schema/question/4","@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. Aim for 80% or more before the real assessment."}},{"@id":"https://practiceexcelonline.com/tests/shl-excel-test#/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/shl-excel-test#/schema/course/1","@type":"Course","description":"SHL's catalog of skills tests includes Microsoft Excel, and employers often add it to an online assessment next to numerical or verbal reasoning. This practice test gives you 20 spreadsheet tasks in 25 minutes, typed as real formulas in a live grid, so you can find out how quick and accurate you are before the real assessment.","educationalLevel":"Intermediate","inLanguage":"en-US","name":"SHL Excel test practice","teaches":"SUM, FIRST-FORMULAS, COUNTIF, SUMIF, AVERAGEIF, SMALL, ROUNDDOWN, IFS, IF, SUMIFS, AVERAGEIFS, IFERROR, INDEX-MATCH, SUMPRODUCT, VLOOKUP","timeRequired":"PT25M","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.