Great · 4.3 out of 5 · 441 reviews on Trustpilot
Independent test prep. Prepterminal is not affiliated with Microsoft, IBM Kenexa, SHL, eSkill, Indeed, TestGorilla, Wells Fargo or any bank.
Prepterminal on Trustpilot★★★★☆4.2 / 5 · 451 reviews (all Prepterminal courses, as of Nov 3, 2026)

Prepterminal › Skills tests › Excel

Excel Assessment Test 2026: What Employers Test at Each Level, and a Free Practice Check

An Excel assessment test checks whether you can do real spreadsheet work: formulas, references, lookups, conditional sums, sorting and filtering, charts and pivot tables. Most are interactive tasks in a spreadsheet-like screen, some are multiple choice. One widely used "Power User" test is reported to have 25 questions – about 10 basic, 5 intermediate and 10 advanced, with pivot tables among the main areas.[1]
Which test? Employers use Kenexa / IBM Prove It, SHL, eSkill, Indeed and others. Your invitation names the level (basic, intermediate, advanced or Power User).

Excel assessment – facts at a glance

Checked November 2026 against the sources below

Formatinteractive tasks; sometimes multiple choice
Power User example25 questions: ~10 basic, 5 intermediate, 10 advanced[1]
Advanced topicspivot tables, macros, lookups[1]
Basic topicsformatting, Save As, printing, simple formulas[1]
Scoretasks solved correctly
Pass markset by the employer

Free Excel check: 5 questions in 4 minutes

Original questions written for the course.

Free Excel practice check

5 questions · 4 minutes · hardest level · instant result with explanations · no sign-up

Original questionsOne question per screenNo going backClock runs out = check ends

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:

Fix exactly these points before test day

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)

Your answers with explanations

What each level tests

LevelTypical tasks
Basicenter and format data, SUM/AVERAGE/MIN/MAX/COUNT, sort, filter, freeze panes
Intermediate$ references, IF, SUMIF/COUNTIF/AVERAGEIF, ROUND, charts, conditional formatting
Advanced / Power UserVLOOKUP, INDEX/MATCH, XLOOKUP, COUNTIFS/SUMIFS, pivot tables, data validation, IFERROR[1]

See the spreadsheet simulator

Trailer: the spreadsheet simulator checks a lookup and copies it down.

Finance roles

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.

Practise in a real spreadsheet, not just read about it

Office Skills Assessments 2026

Spreadsheet, typing, data entry, 10-key, bank teller · $29 one-time · 90-day access · no subscription, no upgrades

  • A spreadsheet simulator that checks your formulas live: 36 tasks from basic to Power User
  • 24 spreadsheet knowledge questions in three levels: references, IF, SUMIF, lookups, pivot tables
  • Word processing and email quiz, a diagnostic and 2 simulations, 9 video lessons
Get the Office Skills course

Guarantee: 7-day money-back guarantee (terms). A refund policy is never a pass guarantee.

One price, everything included$29 once. No Basic, Advanced or Premium tiers, no upgrades, no subscription.
90 days of accessLong enough for a late invitation, a second attempt or a different role later.
Excel, typing and data entry togetherSpreadsheet simulator, typing, data entry, 10-key and bank teller practice in one course.
7-day money-back guaranteeNot what you expected? Ask for a refund within 7 days (terms apply). Runs in your browser – nothing to install.

All-Access 2026: all five courses for $79

One payment, 90 days, every course below – including the interview course for the step after the test.

  • Amazon & Big Tech Hiring 2026 · Work Style, Work Simulation, Area Manager, SDE, Financial Analyst, Google Hiring Assessment
  • Retail Assessments 2026 · CVS, Walmart, Home Depot, Target, Amazon warehouse
  • Office Skills Assessments 2026 · Excel, typing, data entry, 10-key, bank teller (this course)
  • US Civil Service Exam 2026 · clerical, NYC and NYS exams, office math, reading
  • Job Interview & HireVue Prep 2026 · STAR answers, story bank, video interview simulator

After the assessment comes the interview

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.

Excel assessment test: questions, answered

What is on an Excel assessment test?

Formulas, references, lookups, conditional functions, sorting and filtering, charts and pivot tables, depending on the level your employer chose.

How many questions are on the Excel test?

It depends on the provider; one Power User test is reported at 25 questions.[1]

Is the Excel test multiple choice?

Many are interactive tasks in a simulated spreadsheet; some are multiple choice. The course trains both.

Is your simulator Microsoft Excel?

No. It is our own spreadsheet simulator with the common functions; it runs in the browser.

Tasks, not trivia.

Type the formulas until they are automatic.

Get the Office Skills course

Sources

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.

  1. Test-prep provider – Kenexa Excel Power User test (prep provider: 25 questions, about 10 basic, 5 intermediate, 10 advanced; PivotTables and macros among the main areas) (read 2026-11-12)
Excel assessment prep · spreadsheet simulator · $29 · 90 days
Get the Office Skills course
92% pass on the first try · Money-back guarantee
Browse courses →