Confident Cells

Excel test for a job interview: what to expect and how to practise

20 November 2026 · 2 min read

Most Excel tests for office, admin, finance and HR jobs check the same handful of skills: adding up and averaging, IF, lookups such as VLOOKUP or XLOOKUP, SUMIFS and COUNTIFS, $ references, percentages, sorting and filtering, and sometimes a pivot table. Practise those on realistic data and you'll be ready for most of them.

How the tests work

Ask the recruiter which version of Excel the test uses. If it's older than Excel 2021, XLOOKUP may not be there, so know VLOOKUP as well.

What usually comes up

SkillTypical questionPractise it
SUM, AVERAGE, MAX, MIN, COUNTTotal and average of a columnPractice
$ referencesCopy a formula down that uses one rate or target cellPractice · guide
PercentagesShare of a total, percentage changePractice · guide
IFShow "Over budget" or "OK" on each rowPractice · guide
COUNTIF and COUNTIFSHow many orders are from London?Practice · guide
SUMIF and SUMIFSTotal sales for one region, or one region in one monthPractice · guide
VLOOKUP or XLOOKUPBring each customer's town in from another tablePractice · guide
TextJoin first name and surname; tidy pasted dataPractice · guide
DatesDays between two dates, working days, agePractice · guide
Sorting, filtering, pivot tablesShow the top 5; summarise sales by regionSorting and filtering lesson · Pivot tables lesson

A typical question, worked through

"The sheet lists orders, with the region in column B and the value in column C. In G2, total the orders for the region in G1."

  1. You want to add up only some rows, the ones for one region: that's SUMIF.
  2. Where to look for the region: B2:B9. What to look for: G1. What to add up: C2:C9.
  3. =SUMIF(B2:B9,G1,C2:C9). For North that's £120 + £95 + £210 = £425.
ABCDEFG
1OrderRegionValueRegionNorth
21001North£120.00Total£425.00
31002South£80.00
41003North£95.00
51004East£150.00
61005South£60.00
71006North£210.00
81007East£45.00
91008South£130.00
G2 holds =SUMIF(B2:B9,G1,C2:C9). Change G1 to South and the total changes to £270.

Pointing at G1 rather than typing "North" into the formula is what testers look for: the answer updates when the question changes.

On the day

Try it now

Your turn

A typical test question: in G2, total the orders for the region in G1. Point at G1 rather than typing the region into the formula.

ABCDEFG
1OrderRegionValueRegionSouth
21001North£120.00Total
31002South£80.00
41003North£95.00
51004East£150.00
61005South£60.00
71006North£210.00
81007East£45.00
91008South£130.00

For a full run-through, the practice pages cover every skill in the table above, each marked as you type.