Excel practice › Excel interview test › Accounting

Excel test for accounting interviews: 8 practice exercises with answers

This is a free Excel practice test for accounting and bookkeeping roles, with answers. You solve 8 exercises in a working spreadsheet in your browser: a budget variance, an account lookup and an accounts receivable aging report. No download and no sign-up.

It is not any employer's or test vendor's actual test. It covers the Excel skills that tests for accounting jobs commonly list, on made-up data.

Skip to the 8 exercises ↓

What these tests check

LevelWhat you're asked to doOn this page
BasicSubtract and divide cells the right way round: a variance, its percentage, the days between two datesExercises 1, 2 and 4
IntermediateAn exact-match lookup by account number; nested IF for aging buckets; ROUND to the cent; a month-end date with EOMONTHExercises 3, 5, 6 and 7
AdvancedA total with two conditions (SUMIFS): what one customer still owesExercise 8

Tests differ by employer and by role. Ask the recruiter which version of Excel the test uses and which level it targets. This page practices formulas: it doesn't cover pivot tables or keyboard shortcuts.

Part 1: budget against actual

A small expense report for March, with a budget and an actual figure per account.

Type the formula in the box and press Enter. Clicking a cell inserts its address. Each answer is checked on the data you see and again on changed data, so a typed-in number won't pass. The answer is under each exercise.

Exercise 1Variance against budget

In D2, calculate the variance for Travel. On this sheet, variance means actual minus budget, so a positive number is over budget.

D2fx
ABCD
1AccountBudgetActualVariance
2Travel12001500
3Rent24002400
4Office Supplies500575
5Utilities800760
6Software650663
7Payroll1800018360
Show the answer

=C2-B2 gives 300.

A variance is one cell minus another. The mistake to avoid is the sign: both ways of subtracting are in use, so check which one the sheet asks for before you write the formula.

Exercise 2Variance as a percentage of budget

The variances are filled in. In E2, calculate the Travel variance as a share of its budget. The result is a decimal (0.1 would mean 10%); in Excel you'd then format the cell as a percentage.

E2fx
ABCDE
1AccountBudgetActualVarianceVariance %
2Travel12001500300
3Rent240024000
4Office Supplies50057575
5Utilities800760-40
6Software65066313
7Payroll1800018360360
Show the answer

=D2/B2 gives 0.25.

The percentage is the variance divided by the budget, the number that was planned: 300 out of 1,200. =(C2-B2)/B2 is the same calculation without the helper column. The parentheses matter there, because Excel divides before it subtracts.

Part 2: chart of accounts

Account numbers on one side, names on the other. Coding lines to accounts is a lookup.

Exercise 3Account name from an account number

Three expense lines need their account names. In F2, return the name of the account whose number is in E2, from the chart of accounts in A1:C8.

F2fx
ABCDEFG
1AccountNameTypeAccountNameAmount
21000CashAsset6200184.75
31200Accounts ReceivableAsset61002400
42000Accounts PayableLiability50003120
54000Sales RevenueRevenue
65000Cost of Goods SoldExpense
76100Rent ExpenseExpense
86200Office SuppliesExpense
Show the answer

=VLOOKUP(E2,A2:C8,2,FALSE) gives Office Supplies.

The account numbers are the first column of the chart, so VLOOKUP works: find E2 in A2:C8, return column 2, exact match. When a lookup like this returns #N/A on a number you can see in the list, one of the two is usually stored as text: see the #N/A error.

Part 3: accounts receivable

The invoices of a made-up wholesaler. The aging report lists the open ones as of March 20, 2026. Terms: an invoice is due on the last day of the month after the month it was issued.

Exercise 4Days overdue

The report date is in G2. In E2, calculate how many days invoice INV-2041 is past its due date.

E2fx
ABCDEFG
1InvoiceCustomerDue dateAmountDays overdueAs of
2INV-2041Baker Hardware11/30/20251840.653/20/2026
3INV-2063Baker Hardware1/31/2026975.34
4INV-2070Summit Bakery1/31/2026640
5INV-2084Ridgeway Motors2/28/20261420.72
6INV-2102Summit Bakery3/31/2026388.45
7INV-2110Ridgeway Motors3/31/20261062.18
Show the answer

=G2-C2 gives 110.

Excel stores a date as a number of days, so one date minus another is the days between them. Point at the report date in its cell instead of typing it, and lock it as $G$2 before copying the formula down. If the cell shows a date instead of a number, change its format to General.

Exercise 5Aging bucket with nested IF

The days overdue are filled in. In F2, show the aging bucket for the invoice in row 2: Current for 0 days or fewer, 1-30, 31-60, or Over 60.

F2fx
ABCDEF
1InvoiceCustomerDue dateAmountDays overdueBucket
2INV-2041Baker Hardware11/30/20251840.65110
3INV-2063Baker Hardware1/31/2026975.3448
4INV-2070Summit Bakery1/31/202664048
5INV-2084Ridgeway Motors2/28/20261420.7220
6INV-2102Summit Bakery3/31/2026388.45-11
7INV-2110Ridgeway Motors3/31/20261062.18-11
Show the answer

=IF(E2<=0,"Current",IF(E2<=30,"1-30",IF(E2<=60,"31-60","Over 60"))) gives Over 60.

Each IF handles one limit and passes everything else on to the next, so the limits go in order. Once the first test has taken everything at 0 or below, the second only needs <=30. Put the bucket names in quotes: without them, Excel reads 1-30 as a subtraction. Nested IF is covered on the IF page and in lesson 2, which is free.

Exercise 6Round a late fee to the cent

Overdue invoices are charged a late fee: the amount times the rate in G2. In E2, calculate the fee for INV-2041 and round it to the cent with ROUND.

E2fx
ABCDEFG
1InvoiceCustomerDue dateAmountLate feeFee rate
2INV-2041Baker Hardware11/30/20251840.650.02
3INV-2063Baker Hardware1/31/2026975.34
4INV-2070Summit Bakery1/31/2026640
5INV-2084Ridgeway Motors2/28/20261420.72
6INV-2102Summit Bakery3/31/2026388.45
7INV-2110Ridgeway Motors3/31/20261062.18
Show the answer

=ROUND(D2*G2,2) gives 36.81.

ROUND changes the stored value, not only what the cell shows: 1,840.65 times 2% is 36.813, and ROUND with 2 keeps 36.81. Formatting a cell to two decimals hides the third one but keeps it in the value, which is how a column of fees ends up a cent away from its own total.

Exercise 7Due date at month end

This is the full invoice register, with the date each invoice was issued. In F2, calculate the due date of INV-2041: the last day of the month after the month it was issued.

F2fx
ABCDEF
1InvoiceCustomerIssuedAmountStatusDue date
2INV-2041Baker Hardware10/22/20251840.65Open
3INV-2058Ridgeway Motors11/17/20252315.56Paid
4INV-2063Baker Hardware12/9/2025975.34Open
5INV-2070Summit Bakery12/19/2025640Open
6INV-2084Ridgeway Motors1/14/20261420.72Open
7INV-2091Baker Hardware1/27/20262150Paid
8INV-2102Summit Bakery2/11/2026388.45Open
9INV-2110Ridgeway Motors2/24/20261062.18Open
Show the answer

=EOMONTH(C2,1) gives 11/30/2025.

EOMONTH returns the last day of a month. The second argument says how many months to move from the start date: 0 for the same month, 1 for the next. It takes care of 28, 30 and 31 days. In Excel the result can show as a plain number until you format the cell as a date.

Exercise 8Open balance for one customer

The register lists paid and open invoices. In H2, total what the customer in G2 still owes: only the invoices with status Open.

H2fx
ABCDEFGH
1InvoiceCustomerIssuedAmountStatusCustomerOpen total
2INV-2041Baker Hardware10/22/20251840.65OpenBaker Hardware
3INV-2058Ridgeway Motors11/17/20252315.56Paid
4INV-2063Baker Hardware12/9/2025975.34Open
5INV-2070Summit Bakery12/19/2025640Open
6INV-2084Ridgeway Motors1/14/20261420.72Open
7INV-2091Baker Hardware1/27/20262150Paid
8INV-2102Summit Bakery2/11/2026388.45Open
9INV-2110Ridgeway Motors2/24/20261062.18Open
Show the answer

=SUMIFS(D2:D9,B2:B9,G2,E2:E9,"Open") gives 2815.99.

SUMIFS starts with the range to add up, then takes one range and one condition per rule: customer equals G2, status equals Open. A row has to meet both to be counted. SUMIF on the customer alone would add the paid invoice too.

How to use the time you have

If the test is tomorrow. Do the 8 exercises on this page. For each one you couldn't solve, open the answer, read why it works, then empty the box and type the formula yourself. Then take the free 10-question Excel test, which ends with a level and the first topic you missed. If there is time left, the general interview test has 10 more exercises with answers.

If you have a few days. Work on what you missed. Lesson 1 (cells, SUM, AVERAGE, MAX) and lesson 2 (IF, AND, OR, nested IF) are free, and so are the function pages linked from each answer. The lessons on VLOOKUP, SUMIFS and COUNTIFS and dates, including EOMONTH, are part of Pro: $29 once for all three tracks, or $19 for the Excel track alone. No subscription, and a 14-day refund.

If the posting mentions pivot tables. They are not on this page. Lesson 9 practices them and is also part of Pro.

Questions people ask

Is this Excel test for an accounting interview free, with answers?

Yes. Every exercise has a Show the answer line under it, with the formula, its result and a short explanation. The page is free and there is nothing to sign up for.

Do I need Excel installed for this Excel skills test for accountants?

No. The spreadsheet on this page runs in your browser. The formulas are the same ones Excel uses, so what you type here is what you would type in Excel. One difference: the sheet shows plain numbers, with no currency or percentage formatting.

Is this the Excel test an accounting employer will give me?

No. This is practice material written for this site, on made-up invoices and accounts. It is not a copy of any employer's or test company's test. Ask the recruiter which version of Excel the test uses, which level it targets, whether it is timed, and whether it includes pivot tables, which this page does not practice.

How long does this accounting Excel practice test take?

It has 8 exercises and no timer, so it takes as long as you need. If your real test is timed, do the page once to learn the formulas, then do it again without opening the answers.

Keep going

Ten questions in a real spreadsheet, from SUM to INDEX/MATCH, on different data. You get a level at the end and the first topic you missed. Free, no sign-up.

Related

Excel test for job interviews, with answersExcel interview questions for data analystsSUMIFS function, with live examplesEOMONTH function, with live examplesROUND function, with live examplesExcel date functions practice (Pro)Excel practice online

Written and tested by Nico, who builds SheetDrill (about). Every formula on this page ran through the engine that checks the exercises before the page was published. Last checked November 2026.