Free spreadsheet practice test for job interviews

Many data entry, MIS executive, accounts and analyst roles include a short practical spreadsheet test, usually 15 to 30 minutes on a laptop at the office. You get a table of sales or staff data and a list of questions. The questions are rarely hard. What makes people fail is time: they know the function exists but cannot type it without searching.

The functions that come up most

Across most entry-level tests, the same handful of functions appear again and again:

COUNTIF / COUNTA — how many orders, how many staff in one department.
SUM / SUMIF / SUMIFS — total units, total amount for one region, total for a region and a status.
AVERAGE with ROUND — average order value to two decimals.
MAX with INDEX and MATCH — which order or which person has the highest value.
Text clean-up — TRIM, PROPER, LEFT and FIND for messy names and codes.

Try the free practice test

The printable spreadsheet practice test has a 12-row sales table and eight questions in exactly this style, with an answer key and the formula for each answer. Type the table into a blank sheet starting at A1, set a 15-minute timer and go. If a question takes you more than two minutes, that is the function to drill.

Practice the keys, not just the formulas

Speed in a test comes as much from the keyboard as from formulas. Jumping to the end of a column with Ctrl + Down, selecting a range with Ctrl + Shift + Down and filling a formula down with Ctrl + D save several seconds per question. The free 47-shortcut cheat sheet lists them with examples.

On the day

Read all the questions first and answer the easy ones.
Use cell references, not typed numbers — testers check the formula bar.
Check one answer by hand (filter and look) before moving on.
Leave five minutes to re-read every cell you filled in.

If you want a calmer warm-up first, the monthly budget worksheet is a gentle way to practice budget vs actual and percentage formulas on your own numbers. All free pages are on the printables hub.