--- title: "Indeed Excel Assessment Practice Test: 20 Timed Questions | PracticeExcel" description: "Practice for the Indeed Excel assessment with a free timed mock test. Type real formulas in a live grid, get scored instantly and see what to study next." canonical_url: "https://practiceexcelonline.com/tests/indeed-excel-assessment" locale: en meta: "og:description": "Practice for the Indeed Excel assessment with a free timed mock test. Type real formulas in a live grid, get scored instantly and see what to study next." "og:image": "https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_~SW5kZWVkIEV4Y2VsIEFzc2Vzc21lbnQgUHJhY3RpY2UgVGVzdDogMjAgVGltZWQgUXVlc3Rpb25z%2Cdescription_~UHJhY3RpY2UgZm9yIHRoZSBJbmRlZWQgRXhjZWwgYXNzZXNzbWVudCB3aXRoIGEgZnJlZSB0aW1lZCBtb2NrIHRlc3QuIFR5cGUgcmVhbCBmb3JtdWxhcyBpbiBhIGxpdmUgZ3JpZCwgZ2V0IHNjb3JlZCBpbnN0YW50bHkgYW5kIHNlZSB3aGF0IHRvIHN0dWR5IG5leHQu%2Ceyebrow_Excel%2Btests%2Bfor%2Bjob%2Bapplications%2Csite_practiceexcel%2Cprops_eyJncmlkIjp7ImNvbHMiOlsiQSIsIkIiXSwicm93cyI6W3sibiI6MSwiY2VsbHMiOlsiTW9udGgiLCJSZXZlbnVlIl19LHsibiI6MiwiY2VsbHMiOlsiSmFuIiwiMTI0MDAiXX0seyJuIjozLCJjZWxscyI6WyJGZWIiLCI5ODUwIl19LHsibiI6NCwiY2VsbHMiOlsiTWFyIiwiMTEzMDAiXX0seyJuIjo1LCJjZWxscyI6WyJBcHIiLCIxMzc1MCJdfSx7Im4iOjgsImNlbGxzIjpbIlRvdGFsIiwiIl19XSwidGFyZ2V0IjpbNSwxXX19%2Cp_Ii90ZXN0cy9pbmRlZWQtZXhjZWwtYXNzZXNzbWVudCI%2Cs_5IzV0EG5OmuC8fCV.png" "og:image:height": "600" "og:image:type": image/png "og:image:width": "1200" "og:title": "Indeed Excel Assessment Practice Test: 20 Timed Questions | PracticeExcel" "twitter:image": "https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_~SW5kZWVkIEV4Y2VsIEFzc2Vzc21lbnQgUHJhY3RpY2UgVGVzdDogMjAgVGltZWQgUXVlc3Rpb25z%2Cdescription_~UHJhY3RpY2UgZm9yIHRoZSBJbmRlZWQgRXhjZWwgYXNzZXNzbWVudCB3aXRoIGEgZnJlZSB0aW1lZCBtb2NrIHRlc3QuIFR5cGUgcmVhbCBmb3JtdWxhcyBpbiBhIGxpdmUgZ3JpZCwgZ2V0IHNjb3JlZCBpbnN0YW50bHkgYW5kIHNlZSB3aGF0IHRvIHN0dWR5IG5leHQu%2Ceyebrow_Excel%2Btests%2Bfor%2Bjob%2Bapplications%2Csite_practiceexcel%2Cprops_eyJncmlkIjp7ImNvbHMiOlsiQSIsIkIiXSwicm93cyI6W3sibiI6MSwiY2VsbHMiOlsiTW9udGgiLCJSZXZlbnVlIl19LHsibiI6MiwiY2VsbHMiOlsiSmFuIiwiMTI0MDAiXX0seyJuIjozLCJjZWxscyI6WyJGZWIiLCI5ODUwIl19LHsibiI6NCwiY2VsbHMiOlsiTWFyIiwiMTEzMDAiXX0seyJuIjo1LCJjZWxscyI6WyJBcHIiLCIxMzc1MCJdfSx7Im4iOjgsImNlbGxzIjpbIlRvdGFsIiwiIl19XSwidGFyZ2V0IjpbNSwxXX19%2Cp_Ii90ZXN0cy9pbmRlZWQtZXhjZWwtYXNzZXNzbWVudCI%2Cs_5IzV0EG5OmuC8fCV.png" --- > Index of every page on this site: [llms.txt](https://practiceexcelonline.com/llms.txt) # **Indeed Excel assessment practice test** Employers who hire through Indeed often ask candidates to take an Excel skills assessment before the interview. This mock test gives you 20 real spreadsheet tasks against the clock: you type each formula into a live grid, and every answer is checked the way Excel would calculate it. Pass 14 of the 20 and you are ready for the real thing. 20 questions · 30 minutes · passing score 70% = 30:0070 % **Question 1 of 20** In B8, calculate the total revenue for January to June. B8fx | | A | B | C | D | E | F | | --- | --- | --- | --- | --- | --- | --- | | 1 | Month | Revenue | | | | | | 2 | Jan | 12400 | | | | | | 3 | Feb | 9850 | | | | | | 4 | Mar | 11300 | | | | | | 5 | Apr | 13750 | | | | | | 6 | May | 10900 | | | | | | 7 | Jun | 14200 | | | | | | 8 | Total | | | | | | | 9 | | | | | | | 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/indeed-excel-assessment) Premium gets you the full 20-question test, your score history and a certificate when you pass. ## **What the Indeed Excel assessment checks** Indeed's skills tests are short, timed and practical. For Excel they look at whether you can work with a spreadsheet without help: add up and average a column, count what matches a condition, round a result, make a decision with IF and pull a value out of a table with a lookup. You are not asked to recite definitions. You are given a small table and a question, and you are expected to find the answer with the right formula, quickly. ## **How this practice test works** You get 30 minutes for 20 questions, in the order the topics usually build up: SUM and AVERAGE first, then COUNT, MAX and MIN, ROUND and simple percentage formulas, IF, COUNTIF, SUMIF and AVERAGEIF, and finally VLOOKUP, IFERROR and XLOOKUP. Each question has its own small sheet, written for this test only, so you cannot have practiced the exact task before. Click the answer cell, type your formula and press Enter, exactly as you would in Excel. You can skip a question and come back to it. Nothing is marked until you hand in, so you get the same pressure as the real test. When you finish, or when the time runs out, you see your score, which questions you got wrong and where to practice each one. ## **How to prepare in a week** Take the test once cold to see where you stand. Then work through the lessons for every question you missed; they have hints that point at the usual mistakes, such as a missing FALSE at the end of VLOOKUP or a criterion without quotes. Take the test again two or three days later. Most people who pass the mock test with 80% or more are comfortable on the day. ## **Not affiliated with Indeed** PracticeExcel is not affiliated with Indeed, and this is not Indeed's own test. The questions are written by us to practice the same skills, so a good score here means you know the formulas, not that you have seen the exact questions. ## **What the test covers** Each question practices one of these skills. Follow a link to practice it before you start. 1. [**1****Total revenue for six months**](https://practiceexcelonline.com/practice/sum/sum-a-column) 2. [**2****Average test score**](https://practiceexcelonline.com/practice/average/average-function) 3. [**3****Count the orders with an amount**](https://practiceexcelonline.com/practice/count/count-numbers) 4. [**4****Count the sign-ups**](https://practiceexcelonline.com/practice/count/counta-non-empty-cells) 5. [**5****Highest store sales**](https://practiceexcelonline.com/practice/minmax/max-function) 6. [**6****Lowest supplier price**](https://practiceexcelonline.com/practice/minmax/min-function) 7. [**7****Average delivery time to one decimal**](https://practiceexcelonline.com/practice/round/round-two-decimals) 8. [**8****Price including VAT**](https://practiceexcelonline.com/practice/first-formulas/multiply-two-cells) 9. [**9****Share of the sales target**](https://practiceexcelonline.com/practice/first-formulas/multiply-two-cells) 10. [**10****Bonus or no bonus**](https://practiceexcelonline.com/practice/if/if-pass-fail) 11. [**11****Free shipping over 500**](https://practiceexcelonline.com/practice/if/if-calculate-bonus) 12. [**12****Count the paid invoices**](https://practiceexcelonline.com/practice/countif/countif-text) 13. [**13****Count the orders over 1,000**](https://practiceexcelonline.com/practice/countif/countif-greater-than) 14. [**14****Total travel expenses**](https://practiceexcelonline.com/practice/sumif/sumif-with-sum-range) 15. [**15****Sales for the rep named in a cell**](https://practiceexcelonline.com/practice/sumif/sumif-criteria-from-a-cell) 16. [**16****Average salary in one department**](https://practiceexcelonline.com/practice/averageif/averageif) 17. [**17****Look up a price by product code**](https://practiceexcelonline.com/practice/vlookup/vlookup-exact-match) 18. [**18****Look up a department by employee ID**](https://practiceexcelonline.com/practice/vlookup/vlookup-number-id) 19. [**19****Show "Not found" for a missing code**](https://practiceexcelonline.com/practice/iferror/iferror-vlookup) 20. [**20****Find a SKU to the left with XLOOKUP**](https://practiceexcelonline.com/practice/xlookup/xlookup) ## **Questions**
### What is on the Indeed Excel assessment? Practical spreadsheet tasks: totals and averages, counting with conditions, rounding, IF, and lookups such as VLOOKUP. This mock test covers the same ground with 20 questions.
### How long is the practice test? 30 minutes for 20 questions. The free preview has the first 10 questions in 15 minutes.
### What score do I need to pass? 70%, which is 14 of the 20 questions. Aim for 80% or more before the real assessment.
### Can I use the Danish or English function names? Use English names here. On ExcelOpgaver, the Danish site, both Danish names such as LOPSLAG and English names are accepted.
### Do I get a certificate? Yes. Pass the full test with a verified email and you get a certificate with a public link you can add to 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 IF formulas: from one condition to many**](https://practiceexcelonline.com/learn/excel-if-function) - [**Excel keyboard shortcuts worth learning, and how to make them stick**](https://practiceexcelonline.com/learn/excel-keyboard-shortcuts) ## **Other Excel tests** - [**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) - [**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/indeed-excel-assessment#webpage","description":"Practice for the Indeed Excel assessment with a free timed mock test. Type real formulas in a live grid, get scored instantly and see what to study next.","name":"Indeed Excel Assessment Practice Test: 20 Timed Questions","url":"https://practiceexcelonline.com/tests/indeed-excel-assessment","@type":["WebPage","FAQPage"],"breadcrumb":{"@id":"https://practiceexcelonline.com/tests/indeed-excel-assessment#breadcrumb"},"isPartOf":{"@id":"https://practiceexcelonline.com/#website"},"mainEntity":[{"@id":"https://practiceexcelonline.com/tests/indeed-excel-assessment#/schema/question/1"},{"@id":"https://practiceexcelonline.com/tests/indeed-excel-assessment#/schema/question/2"},{"@id":"https://practiceexcelonline.com/tests/indeed-excel-assessment#/schema/question/3"},{"@id":"https://practiceexcelonline.com/tests/indeed-excel-assessment#/schema/question/4"},{"@id":"https://practiceexcelonline.com/tests/indeed-excel-assessment#/schema/question/5"}],"potentialAction":[{"@type":"ReadAction","target":["https://practiceexcelonline.com/tests/indeed-excel-assessment"]}],"primaryImageOfPage":{"@id":"https://practiceexcelonline.com/#logo"}},{"@id":"https://practiceexcelonline.com/tests/indeed-excel-assessment#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":"Indeed Excel Assessment Practice Test: 20 Timed Questions","position":3}]},{"@id":"https://practiceexcelonline.com/tests/indeed-excel-assessment#/schema/question/1","@type":"Question","inLanguage":"en-US","name":"What is on the Indeed Excel assessment?","acceptedAnswer":{"@type":"Answer","text":"Practical spreadsheet tasks: totals and averages, counting with conditions, rounding, IF, and lookups such as VLOOKUP. This mock test covers the same ground with 20 questions."}},{"@id":"https://practiceexcelonline.com/tests/indeed-excel-assessment#/schema/question/2","@type":"Question","inLanguage":"en-US","name":"How long is the practice test?","acceptedAnswer":{"@type":"Answer","text":"30 minutes for 20 questions. The free preview has the first 10 questions in 15 minutes."}},{"@id":"https://practiceexcelonline.com/tests/indeed-excel-assessment#/schema/question/3","@type":"Question","inLanguage":"en-US","name":"What score do I need to pass?","acceptedAnswer":{"@type":"Answer","text":"70%, which is 14 of the 20 questions. Aim for 80% or more before the real assessment."}},{"@id":"https://practiceexcelonline.com/tests/indeed-excel-assessment#/schema/question/4","@type":"Question","inLanguage":"en-US","name":"Can I use the Danish or English function names?","acceptedAnswer":{"@type":"Answer","text":"Use English names here. On ExcelOpgaver, the Danish site, both Danish names such as LOPSLAG and English names are accepted."}},{"@id":"https://practiceexcelonline.com/tests/indeed-excel-assessment#/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 you can add to your résumé or LinkedIn."}},{"@id":"https://practiceexcelonline.com/tests/indeed-excel-assessment#/schema/course/1","@type":"Course","description":"Employers who hire through Indeed often ask candidates to take an Excel skills assessment before the interview. This mock test gives you 20 real spreadsheet tasks against the clock: you type each formula into a live grid, and every answer is checked the way Excel would calculate it. Pass 14 of the 20 and you are ready for the real thing.","educationalLevel":"Intermediate","inLanguage":"en-US","name":"Indeed Excel assessment practice test","teaches":"SUM, AVERAGE, COUNT, MINMAX, ROUND, FIRST-FORMULAS, IF, COUNTIF, SUMIF, AVERAGEIF, VLOOKUP, IFERROR, XLOOKUP","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.