Job ads ask for basic, intermediate, or advanced Excel without saying what those words mean. Try the checks below in a blank workbook. The first place you get stuck is your level, and the next step shows where to spend your practice time.
Basic Excel test for entry-level jobs
A basic Excel test for entry-level jobs checks that you can enter and format data, sort and filter a list, write SUM, AVERAGE, MIN, MAX, and COUNT formulas, fill a formula down a column, and make a simple chart. Try this: type 20 rows of sales, total them, find the average, and chart the result, all in under five minutes.
If that feels slow, start your practice here. Most admin, reception, and junior office roles stop at this level.
Intermediate Excel skills: lookups, pivot tables, conditional logic
Intermediate is the level most Excel assessment tests for jobs are built around. At this level you can pull a price from a second sheet with XLOOKUP or VLOOKUP, total sales by region with SUMIFS, flag late orders with IF, lock a cell reference with a dollar sign, and turn a raw list into a pivot table without looking up the steps. Here's the self-check: if lookups feel easy but pivot tables still send you to a tutorial, you're low intermediate.
Put your hours into pivot tables and mixed references. Together they cover a large share of what analyst and operations tests ask.
Advanced Excel skills: Power Query, dynamic arrays, macros
Advanced means you can clean a messy import with Power Query, write dynamic array formulas such as FILTER, UNIQUE, and SORT that spill results into many cells, build a model someone else can follow, and record or edit a simple macro. If pivot tables are second nature but you've never used FILTER or Power Query, you're upper intermediate, and those two tools are your gap.
Finance, FP&A, and data roles test at this level. Most other roles don't.
Try a 9-question Excel mini-test
Work through these in order. Cover the answers, give yourself 15 minutes, and count how many you get right.
- Basic. Cells B2 to B11 hold prices and C1 holds a tax rate. What do you type in D2 so you can fill it down? Answer:=B2*$C$1. The dollar signs lock the tax cell, so it doesn't shift when you copy the formula.
- Basic. Total B2 to B11. Answer:=SUM(B2:B11). Typing the range beats clicking each cell.
- Basic. Show "Pass" if C2 is 70 or more, otherwise "Fail". Answer:=IF(C2>=70,"Pass","Fail"). IF checks one condition and returns one of two results.
- Intermediate. Find the price for the product code in A2 from a table on Sheet2 (codes in column A, prices in column C). Answer:=XLOOKUP(A2,Sheet2!A:A,Sheet2!C:C). XLOOKUP looks in one column and returns from another, without VLOOKUP's column number.
- Intermediate. Total sales in column C where the region in column A is "East" and the month in column B is "March". Answer:=SUMIFS(C:C,A:A,"East",B:B,"March"). The sum range comes first, then each range and its rule.
- Intermediate. Grade a score in C2: 90 or more is A, 80 or more is B, anything else is C. Answer:=IF(C2>=90,"A",IF(C2>=80,"B","C")). Nested IFs check the highest bar first.
- Intermediate. Show total sales by region and month from a raw list. Answer: Insert a pivot table, put Region in Rows, Month in Columns, and Sales in Values as a Sum. Check the source range covers every row first.
- Advanced. List every order over $500 and, separately, each customer name once. Answer:=FILTER(A2:D100,D2:D100>500) and =UNIQUE(B2:B100). Both spill their results into the cells below.
- Advanced. A lookup returns #N/A for a code you can see in the table. Why? Answer: Most often a stray space or a number stored as text. Wrap the lookup value in TRIM, or convert the column to numbers, and it matches.
Score key: 0 to 3 right means basic, so start with formulas and references. 4 to 6 means intermediate, so drill lookups, SUMIFS, and pivot tables.
7 to 8 means upper intermediate, so add dynamic arrays and error fixing. All 9 means you're ready for an advanced test.
With AI tools, is Excel proficiency still important?
It still matters. Excel still appears in a huge number of job ads. It sits on O*NET's hot technology list of the software employers ask for most.
AI has shifted what gets tested, though. Copilot in Excel can write a formula from a plain-English request, so newer tests lean less on remembering syntax and more on setting data up cleanly and spotting an answer that looks wrong. A simulated test window usually has no Copilot button, so you still need the formulas yourself.
And someone has to check what the AI wrote. That person needs to know Excel.