Excel skills test / Accounting and finance
Excel test for accountants
Ten tasks from the working day of an accountant, bookkeeper or finance assistant, in a live spreadsheet: margins, a running balance, overdue invoices, a ledger to total, a loan and a net present value. It's free and there's nothing to sign up for.
What it tests
Accounting work in Excel comes down to a handful of things done reliably: totals by category and by period, percentages, dates, looking a code up in a table, and the financial functions for loans, depreciation and investments. Tests of Excel for finance jobs tend to ask for the same things. The test checks the result, not the method, so any formula that gets it right counts.
The 10 tasks
- Percentages (beginner): Work out the gross margin of each product in
D2:D5: the share of revenue left after cost. Write one formula inD2and copy it down. - Running balance (beginner): The account opens with the balance in
F1. Show the balance after each transaction inD2:D6: money in adds to it, money out takes away. One formula inD2, copied down. - Conditional sums (intermediate): How much was spent on Travel? Work out the total in
F2from the ledger. - Dates (intermediate): How many days overdue is each invoice on the report date in
F1? Put it inC2:C6. An invoice that is not due yet should show 0, not a negative number. - Lookups (intermediate): Each transaction has an account code. Fill
C2:C6with the account name from the chart of accounts inF2:G6, with one formula copied down. - Logic (intermediate): In
D2:D6, show Over where the actual spend is more than the budget, and OK everywhere else. - Conditional sums (advanced): What did the Sales department spend in Q2? Work out the total in
G2. - Depreciation (intermediate): The machine in the table is written off in equal amounts over its useful life. What is the depreciation per year? Work it out in
B5. - Loans (advanced): What is the monthly payment on this loan? Put it in
B5as a positive number. The rate inB2is per year, and payments are monthly. - Investment appraisal (advanced): A project costs the amount in
B2today and returns the cash flows inB3:B6at the end of each year. What is its net present value at the discount rate inE1? Work it out inE3.
Your result
- Job-ready (9–10): You would be comfortable with these tasks in an interview or on the first day.
- Strong (7–8): Most of it is there. The tasks you missed are worth an evening each.
- Getting there (4–6): You know the basics of the job. The lessons below fill the gaps.
- Starting out (0–3): A fair first try. Start with the lessons below and come back.
Any formula that gets the right answer counts. Missed a task? The results link to the lesson that teaches it. We keep each attempt's answers and score, without any personal details, to see which tasks people find hard.
Common questions
What Excel skills does an accountant need?
Conditional totals with SUMIF and SUMIFS, lookups with VLOOKUP or XLOOKUP, IF for flags and checks, date arithmetic for ageing reports, and the financial functions PMT, NPV and SLN. PivotTables matter too, and have their own lessons in the course.
Is this the test employers use?
No. Employers and recruiters set their own tests, and many are multiple choice. This one is practice: real tasks in a real sheet, which is harder than recognising the right answer in a list and closer to the job.