What TestGorilla says
- Microsoft Excel (General) is listed at 12 minutes.[1] The page names four areas: sheet basics, working with tables, managing data in worksheets, and formulas and functions, with "practical and theoretical questions".[1] Its label says intermediate, while the text calls it entry-level.[1]
- Microsoft Excel (Advanced) is listed at 10 minutes.[2] Its areas: organizing data, writing advanced formulas, building reports and charts, and advanced features; the page also mentions Power Query and conditional formatting.[2] It refers to its preview questions as multiple choice.[2]
- Both have a free preview linked from their pages, so you can see the question style before an employer sends you the real one.[1][2]
- Results go to the employer in a PDF report, alongside any other tests in the same assessment.[1]
- Neither page says which version of Excel the questions are based on.[1][2]
An employer usually combines a test like this with others (a role test, a personality or reasoning test) in one assessment, so the Excel part can be short.
What that means for practice
- Speed counts. Ten or twelve minutes leaves little time to work a formula out from scratch. You want the common ones to be automatic.
- Expect to read formulas, not only write them. A question may show a formula and ask what it returns, or show a result and ask which formula gives it. Writing the formula yourself, many times, is what makes reading one quick.
- Do the free preview. It is the honest way to see the format. Practice packs sold under a test's name are not the real questions.
- The Advanced test goes past formulas. Charts, Power Query and conditional formatting have no challenge on this site yet; use Excel itself for those.
Skills to have ready
Each is a free challenge that takes a few minutes. For the full list by role, see what Excel tests check.
Add up with two conditionsCount with two conditionsXLOOKUP, the modern wayINDEX and MATCH togetherLock it with $Pass or fail?Catch the error, not the bugUp or down by how much?