---
title: "TestGorilla Excel Test Practice: 20 Questions in 20 Minutes | PracticeExcel"
description: "Practice for the TestGorilla Excel test against the clock. 20 real formula tasks in a live grid, scored instantly, with a free 10-question preview."
canonical_url: "https://practiceexcelonline.com/tests/testgorilla-excel-test"
locale: en
meta:
"og:description": "Practice for the TestGorilla Excel test against the clock. 20 real formula tasks in a live grid, scored instantly, with a free 10-question preview."
"og:image": "https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_~VGVzdEdvcmlsbGEgRXhjZWwgVGVzdCBQcmFjdGljZTogMjAgUXVlc3Rpb25zIGluIDIwIE1pbnV0ZXM%2Cdescription_~UHJhY3RpY2UgZm9yIHRoZSBUZXN0R29yaWxsYSBFeGNlbCB0ZXN0IGFnYWluc3QgdGhlIGNsb2NrLiAyMCByZWFsIGZvcm11bGEgdGFza3MgaW4gYSBsaXZlIGdyaWQsIHNjb3JlZCBpbnN0YW50bHksIHdpdGggYSBmcmVlIDEwLXF1ZXN0aW9uIHByZXZpZXcu%2Ceyebrow_Excel%2Btests%2Bfor%2Bjob%2Bapplications%2Csite_practiceexcel%2Cprops_eyJncmlkIjp7ImNvbHMiOlsiQSIsIkIiXSwicm93cyI6W3sibiI6MSwiY2VsbHMiOlsiTW9udGgiLCJSZXZlbnVlIl19LHsibiI6MiwiY2VsbHMiOlsiSmFuIiwiMTI0MDAiXX0seyJuIjozLCJjZWxscyI6WyJGZWIiLCI5ODUwIl19LHsibiI6NCwiY2VsbHMiOlsiTWFyIiwiMTEzMDAiXX0seyJuIjo1LCJjZWxscyI6WyJBcHIiLCIxMzc1MCJdfSx7Im4iOjgsImNlbGxzIjpbIlRvdGFsIiwiIl19XSwidGFyZ2V0IjpbNSwxXX19%2Cp_Ii90ZXN0cy90ZXN0Z29yaWxsYS1leGNlbC10ZXN0Ig%2Cs_1NiJkgam2_rZva60.png"
"og:image:height": "600"
"og:image:type": image/png
"og:image:width": "1200"
"og:title": "TestGorilla Excel Test Practice: 20 Questions in 20 Minutes | PracticeExcel"
"twitter:image": "https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_~VGVzdEdvcmlsbGEgRXhjZWwgVGVzdCBQcmFjdGljZTogMjAgUXVlc3Rpb25zIGluIDIwIE1pbnV0ZXM%2Cdescription_~UHJhY3RpY2UgZm9yIHRoZSBUZXN0R29yaWxsYSBFeGNlbCB0ZXN0IGFnYWluc3QgdGhlIGNsb2NrLiAyMCByZWFsIGZvcm11bGEgdGFza3MgaW4gYSBsaXZlIGdyaWQsIHNjb3JlZCBpbnN0YW50bHksIHdpdGggYSBmcmVlIDEwLXF1ZXN0aW9uIHByZXZpZXcu%2Ceyebrow_Excel%2Btests%2Bfor%2Bjob%2Bapplications%2Csite_practiceexcel%2Cprops_eyJncmlkIjp7ImNvbHMiOlsiQSIsIkIiXSwicm93cyI6W3sibiI6MSwiY2VsbHMiOlsiTW9udGgiLCJSZXZlbnVlIl19LHsibiI6MiwiY2VsbHMiOlsiSmFuIiwiMTI0MDAiXX0seyJuIjozLCJjZWxscyI6WyJGZWIiLCI5ODUwIl19LHsibiI6NCwiY2VsbHMiOlsiTWFyIiwiMTEzMDAiXX0seyJuIjo1LCJjZWxscyI6WyJBcHIiLCIxMzc1MCJdfSx7Im4iOjgsImNlbGxzIjpbIlRvdGFsIiwiIl19XSwidGFyZ2V0IjpbNSwxXX19%2Cp_Ii90ZXN0cy90ZXN0Z29yaWxsYS1leGNlbC10ZXN0Ig%2Cs_1NiJkgam2_rZva60.png"
---
> Index of every page on this site: [llms.txt](https://practiceexcelonline.com/llms.txt)
# **TestGorilla Excel test practice**
TestGorilla is a screening platform where employers combine several short, timed skills tests into one assessment, and Microsoft Excel is among them. This practice test gives you 20 tasks in 20 minutes, typed as real formulas in a live grid, to get you used to working fast and accurately when every minute counts.
20 questions · 20 minutes · passing score 70%
=
20: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 10 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/testgorilla-excel-test)
Premium gets you the full 20-question test, your score history and a certificate when you pass.
## **What the TestGorilla Excel test checks**
On TestGorilla the employer builds the assessment from a library of tests, so the Excel part sits next to other tests, such as cognitive ability or another software skill. Each test is short and has its own timer, which means there is little time to think twice about a formula.
The Excel questions range from basic totals and averages to conditional logic and lookups, and harder versions go on to multi-condition formulas and data that has to be combined before it can be summed. This practice test follows that range.
## **How this practice test works**
You have 20 minutes for 20 questions, so a minute each. The first questions are quick ones on SUM, AVERAGE, MAX and MIN; the last few need XLOOKUP, a two-way INDEX and MATCH, SUMIFS with a limit in a cell and a SUMPRODUCT with a condition. 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. Skip anything that takes too long and come back to it. Nothing is marked until you hand in, and the result shows your score, the questions you missed and where to practice each one.
## **How to prepare**
Speed matters more here than on most tests, so practice until the everyday formulas take seconds: SUM, AVERAGE, IF, COUNTIF and SUMIFS. Then take the free preview of the first 10 questions in 10 minutes. If you finish with time to spare, take the full test; if not, practice the basics again first.
## **Not affiliated with TestGorilla**
PracticeExcel is not affiliated with TestGorilla, and this is not TestGorilla'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****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****Highest store sales**](https://practiceexcelonline.com/practice/minmax/max-function)
4. [**4****Lowest supplier price**](https://practiceexcelonline.com/practice/minmax/min-function)
5. [**5****Gap between the highest and lowest price**](https://practiceexcelonline.com/practice/minmax/max-function)
6. [**6****Free shipping over 500**](https://practiceexcelonline.com/practice/if/if-calculate-bonus)
7. [**7****Flag items to reorder**](https://practiceexcelonline.com/practice/if/if-pass-fail)
8. [**8****One region's share of the total**](https://practiceexcelonline.com/practice/sum/sum-a-column)
9. [**9****Overtime hours over 37**](https://practiceexcelonline.com/practice/minmax/max-function)
10. [**10****Order price with a bulk discount**](https://practiceexcelonline.com/practice/if/if-calculate-bonus)
11. [**11****Price per unit without #DIV/0!**](https://practiceexcelonline.com/practice/iferror/iferror-vlookup)
12. [**12****Share of yes answers**](https://practiceexcelonline.com/practice/countif/countif-text)
13. [**13****Discount rate by quantity**](https://practiceexcelonline.com/practice/vlookup/vlookup-approximate-match)
14. [**14****Hours for one project and one person**](https://practiceexcelonline.com/practice/sumifs/sumifs-criteria-from-cells)
15. [**15****Bonus when both conditions hold**](https://practiceexcelonline.com/practice/logical/if-and)
16. [**16****Find a SKU to the left with XLOOKUP**](https://practiceexcelonline.com/practice/xlookup/xlookup)
17. [**17****Large orders for one customer**](https://practiceexcelonline.com/practice/sumifs/sumifs-criteria-from-cells)
18. [**18****Domain from an email address**](https://practiceexcelonline.com/functions/find)
19. [**19****Two-way lookup: product and month**](https://practiceexcelonline.com/practice/index-match/index-match)
20. [**20****Revenue for one region from units and prices**](https://practiceexcelonline.com/functions/sumproduct)
## **Questions**
### What is on the TestGorilla Excel test?
Spreadsheet tasks from basic totals and averages to IF, conditional sums and lookups, at the level the employer picks. This practice test covers that range with 20 questions.
### Why is this practice test so short?
TestGorilla tests are short and each has its own timer, so speed counts. 20 minutes for 20 questions trains the same pace.
### Is there a free version?
Yes. The free preview is the first 10 questions in 10 minutes, with your score at the end.
### What score should I aim for?
The passing score here is 70%, 14 of 20. Aim for 80% or more before the real test.
### 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**
- [**Pivot tables explained, and the formulas that do the same job**](https://practiceexcelonline.com/learn/pivot-tables)
## **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)
- [**SHL Excel test practice**](https://practiceexcelonline.com/tests/shl-excel-test)
- [**iMocha Excel test practice**](https://practiceexcelonline.com/tests/imocha-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/testgorilla-excel-test#webpage","description":"Practice for the TestGorilla Excel test against the clock. 20 real formula tasks in a live grid, scored instantly, with a free 10-question preview.","name":"TestGorilla Excel Test Practice: 20 Questions in 20 Minutes","url":"https://practiceexcelonline.com/tests/testgorilla-excel-test","@type":["WebPage","FAQPage"],"breadcrumb":{"@id":"https://practiceexcelonline.com/tests/testgorilla-excel-test#breadcrumb"},"isPartOf":{"@id":"https://practiceexcelonline.com/#website"},"mainEntity":[{"@id":"https://practiceexcelonline.com/tests/testgorilla-excel-test#/schema/question/1"},{"@id":"https://practiceexcelonline.com/tests/testgorilla-excel-test#/schema/question/2"},{"@id":"https://practiceexcelonline.com/tests/testgorilla-excel-test#/schema/question/3"},{"@id":"https://practiceexcelonline.com/tests/testgorilla-excel-test#/schema/question/4"},{"@id":"https://practiceexcelonline.com/tests/testgorilla-excel-test#/schema/question/5"}],"potentialAction":[{"@type":"ReadAction","target":["https://practiceexcelonline.com/tests/testgorilla-excel-test"]}],"primaryImageOfPage":{"@id":"https://practiceexcelonline.com/#logo"}},{"@id":"https://practiceexcelonline.com/tests/testgorilla-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":"TestGorilla Excel Test Practice: 20 Questions in 20 Minutes","position":3}]},{"@id":"https://practiceexcelonline.com/tests/testgorilla-excel-test#/schema/question/1","@type":"Question","inLanguage":"en-US","name":"What is on the TestGorilla Excel test?","acceptedAnswer":{"@type":"Answer","text":"Spreadsheet tasks from basic totals and averages to IF, conditional sums and lookups, at the level the employer picks. This practice test covers that range with 20 questions."}},{"@id":"https://practiceexcelonline.com/tests/testgorilla-excel-test#/schema/question/2","@type":"Question","inLanguage":"en-US","name":"Why is this practice test so short?","acceptedAnswer":{"@type":"Answer","text":"TestGorilla tests are short and each has its own timer, so speed counts. 20 minutes for 20 questions trains the same pace."}},{"@id":"https://practiceexcelonline.com/tests/testgorilla-excel-test#/schema/question/3","@type":"Question","inLanguage":"en-US","name":"Is there a free version?","acceptedAnswer":{"@type":"Answer","text":"Yes. The free preview is the first 10 questions in 10 minutes, with your score at the end."}},{"@id":"https://practiceexcelonline.com/tests/testgorilla-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 test."}},{"@id":"https://practiceexcelonline.com/tests/testgorilla-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/testgorilla-excel-test#/schema/course/1","@type":"Course","description":"TestGorilla is a screening platform where employers combine several short, timed skills tests into one assessment, and Microsoft Excel is among them. This practice test gives you 20 tasks in 20 minutes, typed as real formulas in a live grid, to get you used to working fast and accurately when every minute counts.","educationalLevel":"Intermediate","inLanguage":"en-US","name":"TestGorilla Excel test practice","teaches":"SUM, AVERAGE, MINMAX, IF, IFERROR, COUNTIF, VLOOKUP, SUMIFS, LOGICAL, XLOOKUP, FIND, INDEX-MATCH, SUMPRODUCT","timeRequired":"PT20M","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.