Excel Test Practice

An Excel test is a short skills assessment that checks whether you can read a spreadsheet, predict what a formula returns and pick the right tool for a data task. Employers send one before or after the first interview for roles where spreadsheets are daily work: administrative and office jobs, finance and accounting, data and business analysis, operations, logistics, sales support and HR. This free practice gives you twenty questions on small sheets in fifteen minutes, starting with SUM and AVERAGE and ending with lookups, mixed references and PivotTables. It scores every answer on our server, shows a percentile on our scale and then walks you through each mistake with the right answer and a one-line explanation.

Who uses Excel tests

Excel assessments are sold by several general testing platforms rather than by Microsoft. Indeed Assessments offers Excel skills tests that employers can attach to a job posting, and candidates can choose to show the result on their Indeed profile. eSkill, TestGorilla and Kenexa Prove It (Kenexa is now part of IBM) are other names candidates commonly report, alongside tests written in-house by recruitment agencies and finance teams. The exact questions differ, but the formats repeat: multiple-choice questions about a formula's result, "which formula would you use", screenshots of the ribbon, and on some platforms a live spreadsheet in which you have to type the formula yourself. Most are timed, usually somewhere between 10 and 40 minutes, and many come in a basic and an advanced level.

What a good score looks like

There is no universal pass mark. Platforms usually report a percentage or a percentile against other test takers, and the employer decides what is enough for the role. As a working rule, an office or admin role wants you comfortable with the basic functions and with sorting and filtering; an analyst or finance role expects lookups, conditional sums, absolute references and PivotTables without hesitation. On this practice, 15 out of 20 or more means you handle the everyday and the intermediate topics; 17 or more means lookups, mixed references and pivots are under control, which is roughly what "advanced" tests check. Our percentile comes from a fixed norm table, not from a live ranking against other players, and it is not any employer's benchmark.

The skills and functions to know

• Basic functions: SUM, AVERAGE, MIN, MAX, ROUND, and the difference between COUNT (numbers only) and COUNTA (anything that is not empty). Blank cells and text are where people lose easy marks.
• Conditional functions: COUNTIF, SUMIF and AVERAGEIF, including criteria such as ">=500", where the equals sign decides whether the boundary value is counted.
• Logic: IF, nested IF (tests are checked in order and the first true one wins), and AND / OR inside IF.
• Lookups: VLOOKUP with FALSE for an exact match and the right column number, XLOOKUP with its "if not found" argument, and INDEX with MATCH.
• References: what happens to A2, $B$1, $A2 and B$1 when a formula is copied. This is the most common topic on Excel tests and the one people guess most.
• Text and numbers: joining text with CONCAT or &, LEFT, TEXT with a number format, and percentage change, which is (new − old) / old.
• Data tools: what a sort or a two-column filter leaves on screen, what a PivotTable's "Sum of" shows, and which chart suits which data.

Tips for the test day

Read the range before the function: half the wrong answers on formula questions come from a range that starts or stops one row away from where you assumed. For copy-and-paste questions, count the columns and rows the formula moves and shift only the parts without a dollar sign in front of them. When a question asks which formula gives a result, work each option out quickly rather than trusting the one that looks familiar. If the test has a live spreadsheet, type formulas rather than clicking through menus, press F4 to cycle through reference types, and keep an eye on the clock: an unanswered question scores the same as a wrong one on most platforms, so never leave one blank.

How this practice differs from a real Excel test

Every question here is generated from a seed, so each run gives you new sheets, new numbers and new distractors, built from the mistakes people actually make: a relative reference left unshifted, AVERAGE taken for SUM, COUNT taken for COUNTA, a percentage divided by the wrong value. The answers are computed by our server, not typed in by hand. The practice is multiple choice and does not include a live spreadsheet, ribbon screenshots or macros, so pair it with some time in Excel itself if the job description mentions advanced work. Keep a timer in mind: fifteen minutes for twenty questions is roughly the pace real tests set.

GamePrep is independent and not affiliated with Microsoft, Indeed, eSkill, TestGorilla, IBM Kenexa or any other test publisher. Excel is a trademark of Microsoft. These questions are original practice items, not questions from any real test.