# How to Prepare for an Excel Test in a Job Interview
Administrative, finance, operations and analyst roles often include an Excel test. They range from basic formatting to modelling, and they are very learnable in a week or two of focused practice.
## Ask what level to expect
Recruiters will usually tell you whether it's basic, intermediate or advanced, how long it is, and whether it's done online or on a provided laptop.
## Skills most tests cover
- **Basics**: formatting, sorting, filtering, freezing panes, simple formulas (SUM, AVERAGE, COUNT).
- **Intermediate**: absolute vs relative references, IF, SUMIF/COUNTIF, XLOOKUP or VLOOKUP, text functions, conditional formatting, basic charts.
- **Advanced**: pivot tables, INDEX/MATCH, nested logic, data validation, simple macros or Power Query, and building a small model.
## Practice approach
Download a sample dataset, such as public sales or transport data, and set yourself tasks: total by region, top 10 products, a monthly trend chart, a pivot by category. Time yourself.
## Keyboard shortcuts
Ctrl+Arrow to jump, Ctrl+Shift+Arrow to select, F4 to lock references, Alt+= for AutoSum. Speed matters in timed tests.
## During the test
Read all questions first, do the ones you're sure of, and label your work clearly. Leaving a short note explaining an assumption helps the reviewer.
## Afterwards
Interviewers may ask you to explain your approach; practise that with [Linkjob AI](https://www.linkjob.ai/).