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%
Question 1 of 20
In B8, calculate the total revenue for January to June.
| 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.
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.
- 1Total revenue for six months
- 2Average test score
- 3Highest store sales
- 4Lowest supplier price
- 5Gap between the highest and lowest price
- 6Free shipping over 500
- 7Flag items to reorder
- 8One region's share of the total
- 9Overtime hours over 37
- 10Order price with a bulk discount
- 11Price per unit without #DIV/0!
- 12Share of yes answers
- 13Discount rate by quantity
- 14Hours for one project and one person
- 15Bonus when both conditions hold
- 16Find a SKU to the left with XLOOKUP
- 17Large orders for one customer
- 18Domain from an email address
- 19Two-way lookup: product and month
- 20Revenue for one region from units and prices
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.