Prepterminal › Skills tests › Excel
By the Prepterminal test research team · Updated November 13, 2026 · Sources checked November 12, 2026
Checked November 2026 against the sources below
Original questions written for the course.
5 questions · 4 minutes · hardest level · instant result with explanations · no sign-up
Five advanced and intermediate questions: lookups, INDEX/MATCH, COUNTIFS, SUMIF, XLOOKUP. 4 minutes.
Question 1 of 5 · Spreadsheet
=VLOOKUP(E2,A2:C50,3,FALSE) returns:
Question 2 of 5 · Spreadsheet
=INDEX(C2:C50,MATCH(F1,A2:A50,0)) does what?
Question 3 of 5 · Spreadsheet
=COUNTIFS(A:A,"West",C:C,">500") counts:
Question 4 of 5 · Spreadsheet
Which formula adds the amounts in C2:C100 only where A2:A100 is "East"?
Question 5 of 5 · Spreadsheet
=XLOOKUP(F2,A:A,D:D,"none") returns "none" when:
The course has a spreadsheet simulator with 36 tasks and 24 knowledge questions.
Get the Office Skills course$29 one-time · 90-day access · 7-day money-back guarantee (terms)
| Level | Typical tasks |
|---|---|
| Basic | enter and format data, SUM/AVERAGE/MIN/MAX/COUNT, sort, filter, freeze panes |
| Intermediate | $ references, IF, SUMIF/COUNTIF/AVERAGEIF, ROUND, charts, conditional formatting |
| Advanced / Power User | VLOOKUP, INDEX/MATCH, XLOOKUP, COUNTIFS/SUMIFS, pivot tables, data validation, IFERROR[1] |
Trailer: the spreadsheet simulator checks a lookup and copies it down.
Analyst tests add business logic: growth rates, variance to budget, weighted averages, shares of a total. The course has a finance unit and the same simulator.
Spreadsheet, typing, data entry, 10-key, bank teller · $29 one-time · 90-day access · no subscription, no upgrades
Guarantee: 7-day money-back guarantee (terms). A refund policy is never a pass guarantee.
One payment, 90 days, every course below – including the interview course for the step after the test.
Our interview course covers STAR answers, a story bank and a one-way video interview simulator – $29 on its own, or included in All-Access.
Formulas, references, lookups, conditional functions, sorting and filtering, charts and pivot tables, depending on the level your employer chose.
It depends on the provider; one Power User test is reported at 25 questions.[1]
Many are interactive tasks in a simulated spreadsheet; some are multiple choice. The course trains both.
No. It is our own spreadsheet simulator with the common functions; it runs in the browser.
Sources checked November 12, 2026. Where the employer publishes nothing, we say what kind of source a claim comes from (test-prep providers, candidate reports) and label it.
Independence notice. Microsoft, Excel, IBM, Kenexa, Prove It, SHL, eSkill, Indeed, TestGorilla, ModernHire, Wells Fargo, Bank of America and Chase are names of their owners. Prepterminal is an independent test-prep company and is not affiliated with, endorsed by or connected to any of them. All practice questions on this page are original questions written by Prepterminal in the style of the tests; no real test items are shown, and there are no real "answers" to these assessments.
Facts about the tests come from the sources listed above (checked November 12, 2026). Formats differ by employer, role and year and can change – the instructions in your own invitation decide. A money-back guarantee is a refund policy, not a pass guarantee.