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

  1. Percentages (beginner): Work out the gross margin of each product in D2:D5: the share of revenue left after cost. Write one formula in D2 and copy it down.
  2. Running balance (beginner): The account opens with the balance in F1. Show the balance after each transaction in D2:D6: money in adds to it, money out takes away. One formula in D2, copied down.
  3. Conditional sums (intermediate): How much was spent on Travel? Work out the total in F2 from the ledger.
  4. Dates (intermediate): How many days overdue is each invoice on the report date in F1? Put it in C2:C6. An invoice that is not due yet should show 0, not a negative number.
  5. Lookups (intermediate): Each transaction has an account code. Fill C2:C6 with the account name from the chart of accounts in F2:G6, with one formula copied down.
  6. Logic (intermediate): In D2:D6, show Over where the actual spend is more than the budget, and OK everywhere else.
  7. Conditional sums (advanced): What did the Sales department spend in Q2? Work out the total in G2.
  8. 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.
  9. Loans (advanced): What is the monthly payment on this loan? Put it in B5 as a positive number. The rate in B2 is per year, and payments are monthly.
  10. Investment appraisal (advanced): A project costs the amount in B2 today and returns the cash flows in B3:B6 at the end of each year. What is its net present value at the discount rate in E1? Work it out in E3.

Your result

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.

Other tests