How to use the Excel Interview Flashcards
- 1. Choose topicsPick one topic or all of them, a round size, and whether to skip cards you already know.
- 2. Flip and gradeRead the question, answer aloud, then reveal the answer and mark it known or still learning.
- 3. Review your resultsMissed cards come back later in the round. At the end see your score by topic and download the cards to revise.
What the deck covers
Excel tests in interviews often start with questions like these before a practical task, so the deck covers both the 'what' and the 'when'. The 21 cards are grouped into 9 topics: Lookup, References, Functions, Dynamic arrays, Pivot tables, Data, Analysis, Shortcuts, Charts. Answers are short on purpose: one or two sentences you can say out loud, which you then back up with an example from your own projects.
A card from the deck
Q: VLOOKUP vs XLOOKUP?
A: VLOOKUP searches the first column and returns a column to the right by index; it defaults to approximate match. XLOOKUP searches any range, returns from any direction, matches exactly by default and has an if-not-found argument.
If you're asked which you prefer, say XLOOKUP where it's available and INDEX-MATCH for compatibility with older Excel versions.
How to study with it
- Practise each formula card in a real sheet; interviews often include a live Excel task.
- Learn five shortcuts well rather than twenty badly.
- In the Excel deck, cards you mark "still learning" come back three cards later in the same round, and the results screen lists them so you can download a revision sheet.
More questions from this deck
Other Excel questions you'll meet include:
- How does INDEX-MATCH work?
- SUMIF vs SUMIFS?
- What does a #REF! error mean?
- What are dynamic array functions?
- How do you remove duplicates?
Frequently asked questions
Which Excel version?
Microsoft 365 and Excel 2021, where XLOOKUP and dynamic arrays are available.
Does it cover VBA?
No. The cards focus on formulas, data tools and pivots.
Are the Excel interview flashcards free?
Yes. You can flip through every card of the Excel interview flashcards without signing up. When you open your results for the first time, we ask once for your name and WhatsApp number; after that the Excel interview flashcards and every other Uncodemy tool open straight away.