5 views
# 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/).