Home › Practice questions
Excel Practice Questions with Answers
Real Excel questions with a small data table, a clear task and a worked answer. Pick a formula below, try the question yourself, then open the live spreadsheet to check your result. New questions are added every week, most popular formulas first.
Choose a formula
- SUM practice questions (12)
- AVERAGE practice questions (11)
- COUNT practice questions (10)
- COUNTA practice questions (8)
- MAX practice questions (9)
- MIN practice questions (9)
- ROUND practice questions (11)
- IF practice questions (13)
- IFS practice questions (9)
- AND practice questions (9)
- OR practice questions (8)
- IFERROR practice questions (9)
- VLOOKUP practice questions (13)
- HLOOKUP practice questions (9)
- XLOOKUP practice questions (11)
- INDEX practice questions (13)
- MATCH practice questions (10)
- SUMIF practice questions (1)
Preparing for a job? See Excel interview questions and practical tests.
Frequently asked questions
Are these Excel practice questions free?
Yes. Every question is free to read, and you can solve it in the live spreadsheet without signing up.
How do I check my answer?
Each page has a Show answer button with the result and an explanation. For instant checking, open the question in the live sheet.
Which formulas should I practise first?
Start with SUM, IF, COUNTIF and SUMIFS, then lookups like VLOOKUP, XLOOKUP, INDEX and MATCH. These are the formulas most used at work and asked in interviews.