Basic Excel Test for Employment: What's on It
By ExcelReady TeamUpdated 5 min read
The short answer
A basic Excel test for employment checks everyday skills: entering data, writing formulas that start with =, adding and averaging with SUM and AVERAGE, simple maths like totals and percentages, locking a cell with $, filling formulas down, sorting and filtering, and formatting numbers as currency or percent. Most basic tests take 15 to 30 minutes.
Key takeaways
- Every formula starts with =, and a test usually checks the formula, not just the number in the cell.
- SUM, AVERAGE, MIN, MAX and COUNT cover most of the calculation questions on a basic test.
- A $ sign locks a cell such as a tax rate, so the formula still points at it after you fill down.
- Sorting, filtering and number formatting are often tested too, not only formulas.
On this page+
A basic Excel test for employment checks whether you can do the everyday spreadsheet jobs an office role needs: enter data, write simple formulas, total and average a column, work out a percentage and keep a list tidy. Employers often use one for admin, customer service, retail and entry-level office roles. This guide shows what's usually on the test, works through a sample task and explains how to prepare.
What a basic Excel test for employment looks like#
A basic test gives you a small sheet and a list of short tasks, often against a timer. Some run in real Excel. Others run in a browser window that looks like Excel and checks each answer automatically.
You might see two kinds of question:
- Hands-on tasks: "In D7, calculate the order total." You type a formula into a cell.
- Multiple-choice questions: "Which formula adds A1 to A5?" You pick an answer.
Many basic tests last somewhere between 15 and 30 minutes, but this depends on the employer. Ask the recruiter how long it is and what format it uses. That one question removes a lot of stress.
The skills a basic Excel test checks#
Most basic tests stay inside a short list of skills:
| Skill | What you might be asked | Example |
|---|---|---|
| Formulas | Add, subtract, multiply or divide two cells | =B2*C2 |
| SUM | Total a column | =SUM(D2:D6) |
| AVERAGE, MIN, MAX | Find the average, lowest or highest value | =AVERAGE(C2:C6) |
| COUNT and COUNTA | Count numbers or filled cells | =COUNTA(A2:A6) |
| Percentages | Work out tax, a discount or a share | =D7*8% |
| $ references | Lock a rate so it stays put when you fill down | =D2*$F$1 |
| Fill down | Copy a formula to the rows below | Ctrl+D (Mac: ⌘D) |
| Sort and filter | Put a list in order or show only some rows | Data > Sort |
| Formatting | Show numbers as currency or percent | Ctrl+Shift+$ (Mac: Control+Shift+$) |
Every formula starts with an equals sign. Without it, Excel treats what you type as text. If you're new to this, how to write your first Excel formula walks through it step by step.
Worked example: a sample basic Excel test#
Here is a typical basic test task. You get this supply order in A1:D6:
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Item | Qty | Unit Price | Total |
| 2 | Paper | 10 | 4.50 | |
| 3 | Pens | 25 | 1.20 | |
| 4 | Folders | 8 | 2.75 | |
| 5 | Stapler | 2 | 12.00 | |
| 6 | Ink | 3 | 18.50 |
Task 1: Fill in the Total column. In D2, type =B2*C2 and press Enter. The result is 45. Then select D2:D6 and fill down with Ctrl+D (Mac: ⌘D). You get 30, 22, 24 and 55.5.
Task 2: Calculate the order total in D7.
=SUM(D2:D6)The result is 176.5. On Windows you can also press Alt+= (Mac: ⌘+Shift+T) to let AutoSum write the formula. See the SUM function guide for more ways to use it.
Task 3: Find the average unit price.
=AVERAGE(C2:C6)The result is 7.79 (38.95 ÷ 5). The AVERAGE function guide explains how it treats blanks and zeros.
Task 4: F1 holds the tax rate, 8%. Calculate the tax on the order total.
=D7*$F$1The result is 14.12. The $ signs matter when you fill a formula down: they keep it pointing at F1. A test may ask you to work out tax for each line, and that is where an unlocked reference breaks.
Task 5: Sort the list by Total, largest first. Click any cell in the table, then go to Data > Sort, choose Total and "Largest to Smallest". Ink (55.5) moves to the top.
Common mistakes on basic Excel tests#
Small slips cost the most points on basic tests, because the tasks themselves are simple. Watch for these:
- Typing the answer instead of a formula. If you type 176.5 into D7, a test that checks formulas marks it wrong.
- Forgetting the = sign.
SUM(D2:D6)without = just shows as text. - Leaving out a row.
=SUM(D2:D5)misses the Ink line. Check that the range covers every row. - Not locking the rate.
=D2*F1filled down becomes=D3*F2, which points at an empty cell and returns 0. - Formatting instead of calculating. Changing the number of decimals only changes how a number looks, not its value.
Subtraction is another place where people slip. There is no SUBTRACT function: you write =B2-C2. The guide to the Excel subtract formula covers the different ways to do it.
How to prepare for a basic Excel test#
The best preparation is to do each task with your own hands until it feels routine. Reading about formulas is not enough, because the test checks what you can type.
- Learn the core five functions: SUM, AVERAGE, MIN, MAX and COUNT.
- Practise a percentage and a locked rate, because they show up in almost every basic test.
- Learn three shortcuts: fill down (Ctrl+D; Mac: ⌘D), AutoSum (Alt+=; Mac: ⌘+Shift+T) and undo (Ctrl+Z; Mac: ⌘Z).
- Take a timed mock test to practise under the clock. The guide on how to use an Excel mock test to prepare explains how to get the most from one.
Some tests go a little further, for example asking for a weighted average of scores or prices. If the job description mentions reports or analysis, read how to calculate a weighted average in Excel too.
What to do if you don't pass#
One failed test doesn't mean you can't learn the skills. Ask which areas were weak if the employer will tell you, practise those tasks, and try again when another chance comes. The guide on what to do after you fail an Excel test has a step-by-step recovery plan.
Practise it#
Start with your first formulas, then practise SUM and AutoSum in a live spreadsheet: you type the formula, and it checks it instantly. When you feel ready, take the basics skill check, which gives you a supplier order to fix and calculate with no hints, or sit the timed basic Excel mock test.
Try it yourself
This is a live spreadsheet. Type the formula in the green cell and press Enter.
What is the total cost of this office supply order? Click D7 and use SUM on the line totals in D2:D6, then press Enter.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Total | ||||
| 2 | |||||
| 3 | |||||
| 4 | |||||
| 5 | |||||
| 6 | |||||
| 7 | Order total | ||||
| 8 | |||||
| 9 | |||||
| 10 |
Tip: Type =SUM( then select the five line totals and close the bracket.
Practise this in a lesson
Frequently asked questions
What is on a basic Excel test for a job?
A basic Excel test usually asks you to enter and edit data, write simple formulas, use SUM, AVERAGE, MIN and MAX, calculate a percentage, fill a formula down, sort or filter a list and format numbers. Some tests also ask you to make a simple chart.
How long is a basic Excel test?
Many basic tests last 15 to 30 minutes, but it depends on the employer. Ask the recruiter how long it takes and whether it runs in real Excel or in a browser.
What score do you need to pass an Excel test?
There is no single pass mark. Each employer sets its own, and some compare you with other candidates instead. Aim to get every basic question right, because basic tasks are where points are easiest to win.
How can I practise for a basic Excel test?
Practise the core tasks on small tables until each takes a minute or two: totals, averages, a percentage, a locked tax rate and a sort. Then take a timed mock test to practise under the clock.