Read basic formulas
Work with SUM, AVERAGE, COUNT and IF using concrete cell values.
Read the formula, check the data
Excel Skills Test
Can you copy a formula without breaking its references, filter the right rows and calculate a total? Check essential Excel knowledge in 12 practical questions.
12questions
8minutes
3topics
free
✓ No sign-up required · instant result
01
Check the foundations of everyday spreadsheet work
Small spreadsheet errors can change a whole report. Practise reading ranges, identifying fixed references and preserving records when sorting.
Copy references accurately
Check what moves and what stays fixed when a formula is copied.
Keep table records together
Practise filtering, safe sorting and finding duplicate IDs without deleting rows.
02
Three practical Excel topics
Four tasks on formulas, four on copying cell references and four on handling tabular data.
Formulas
Evaluate basic calculations and conditions using the values given.
Cell references
Apply relative, absolute and mixed references to the stated copy operation.
Working with tables
Choose filters and table operations that preserve records and match the conditions.
How your score is calculated
One correct choice earns one point: 12 overall and four per topic. No timer or negative marking. The percentage is the share correct in this question set.
- 1Read the cell values, formula or table and choose one answer.
- 2Revisit any question before submitting; there is no need to open Excel.
- 3Review your total, three topic scores and the explanation for every task.
Understand the notation first
- Function names are shown in English and function arguments use commas throughout this quiz.
- A dollar sign fixes the following column or row when a formula is copied.
- For table tasks, check every condition and keep values from the same record together.
FAQ
Questions about the Excel test
Excel skills are useful for reports, administration and everyday work with numbers. This original BrainApps quiz covers basic functions, relative and fixed cell references, and safe table operations. You choose an answer from the data and conditions shown rather than editing a live workbook. The result counts correct answers and separates three topics to guide revision. It includes a full explanation for each task, including copied formulas and the rows selected by a filter.
What does this Excel skills test cover?+
It covers SUM, AVERAGE, COUNT, IF and SUMIF, copied relative and fixed references, filtering, sorting and identifying duplicates. There are 12 original questions.
Do I need to install Excel?+
No. You read the values and formulas in the browser and choose an answer. This version checks understanding rather than hands-on editing in a workbook.
Why are function names in English?+
One consistent notation makes the questions comparable across languages. The test uses English function names and commas between arguments. A local Excel installation may display translated function names or use semicolons.
Is it suitable for interview preparation?+
It offers practice with common spreadsheet concepts and explanations for errors. For recruitment, pair a knowledge quiz with a practical task relevant to the role rather than relying on a short score alone.
How is the result calculated?+
Each correct answer earns one point. You see the total out of 12 and three scores out of four. Time spent does not affect the result.
Can I review my answers?+
Yes. Before submission you can change choices. Afterwards, the result preserves your answers, the correct choices, the task data and the explanations.
Related tests
12 questions
Will your formula still work after copying?
Try 12 practical questions and see exactly why each answer is correct.