SharpAssessmentGet started

Free Excel test

Free Excel test online: 12 formula tasks (SUM, AVERAGE, ROUND, IF, percentages) checked on two value sets, new tasks each attempt, worked answers, shareable result.

FREE PRACTICE · NEW QUESTIONS EVERY ATTEMPT

Excel formula skills test

Write a formula for the worksheet shown. Start with = and use cell references. Supported: arithmetic, comparisons, ranges, SUM, AVERAGE, MIN, MAX, COUNT, ROUND and IF. This is formula practice, not the full Excel application.

12 questions12 minutes69 in the bank
Choose your pace

Each attempt draws 12 of 69 questions, and a retake avoids the ones you have just seen. One point per correct answer, no penalty for guessing. Skip and return to questions; answers and explanations appear after you finish. Your progress stays on this page until you reload or leave.

What an Excel test measures

Excel skills tests for jobs usually have a formula section, and that section is what this test practises. The task is always the same shape: here is a small worksheet, produce a formula that gives the right answer in a named cell. Totals, averages, a line total from quantity and price, a growth rate, a discounted price, a rounded division, a value that depends on a condition.

This test covers exactly that section. Every task is scored on the worksheet you can see and on a second set of values you cannot, so the formula has to work, not just the number.

How this free test works

  • 12 tasks across six skills: totals (SUM, MIN, MAX, COUNT), averages, arithmetic, percentages (growth, discount, tax, share of total, margin), rounding and conditions (IF).
  • A bank of 69 tasks from 23 templates, each rendered with random values. An attempt draws at most one task per template and a retake avoids the ones you just did.
  • Type the formula starting with =. Cell references are shown in the column headers. $ signs are ignored and ; works as a separator, so a European Excel habit is not penalised.
  • 12 minutes timed, or untimed while you learn.
  • Worked answers show one correct formula and the value it gives; any equivalent formula built from cell references is accepted.
  • An optional shareable result with a permanent link, preview image and Add to LinkedIn profile button.

Sample Excel formula questions

Row A: Team B: Orders
2 North 18
3 South 24
4 East 13
5 West 25

In B6, total B2:B5. =SUM(B2:B5) gives 80. So does =B2+B3+B4+B5. =80 is rejected, because it fails on the second set of values.

In D2, calculate the growth rate from B2 to C2 as a decimal. =(C2-B2)/B2. The most common wrong answer divides by C2, the new value.

In C2, return 1 if B2 is at least 50, otherwise 0. =IF(B2>=50,1,0). Note at least: >50 fails when B2 is exactly 50, and the hidden values include that case.

How to improve your Excel test score

  1. Reference cells, never retype numbers. A formula that contains the visible figure will not survive a change of data, in this test or in a real workbook.
  2. Learn the six functions cold: SUM, AVERAGE, MIN, MAX, COUNT and IF cover most of what employer formula tests ask. ROUND(x, places) rounds half away from zero.
  3. Read the boundary words. At least is >=, more than is >, below is <.
  4. Percentages as decimals. A growth rate of 25% is 0.25; a discount of 15% multiplies by (1 − 0.15).
  5. Check the units of the answer before you move on: a price per unit is total ÷ quantity, not the other way round.

Reading your result

The result guide explains the score and which of the six skills to practise. This checker is a subset of Excel: no text functions, lookups, dates or macros. Unsupervised practice, not a certificate.

For the full spreadsheet behaviour, see Microsoft’s SUM documentation and ROUND documentation.

Frequently asked questions

Is the Excel test free?
Yes. All 12 tasks, the score, worked answers and a public result link are free, with no account, no email address and no download.
Do I need Excel installed?
No. You type a formula into a field on the page and it is evaluated in the browser against the worksheet shown. The evaluator supports arithmetic, comparisons, rectangular ranges, SUM, AVERAGE, MIN, MAX, COUNT, ROUND and three-argument IF, with commas or semicolons as separators.
Are the tasks the same every time?
No. The bank holds 69 tasks built from 23 templates with randomised values. An attempt draws 12, never two from the same template, and a retake avoids the tasks you just did.
Why is my formula checked on a second set of values?
So that typing the visible answer as a number does not score. =80 gives the right total for the values you can see and the wrong one for the hidden set; =SUM(B2:B5) gives the right total for both. That is the difference between knowing the answer and knowing Excel.
Is this an Excel test for a job interview?
It practises the formula part of one. Employer Excel tests also cover sorting, filtering, charts, pivot tables and lookups, none of which this browser exercise attempts. The score is a percentage of these 12 tasks, not a proficiency level.