All lessons › Lesson 14
Lesson 14: Timed mock test: 10 mixed accounting Excel tasks
A timed practice test, scored at the end. 10 tasks, 15 minutes.
This mock test mixes the skills from lessons 1 to 13 into ten tasks with a 15-minute clock. It is set up like a timed screening test: you get one attempt per task, there are no hints, and you find out how you did only at the end.
When you finish, or when time runs out, you see your score overall and by topic, plus the specific correction for every task you missed. Unanswered tasks count as wrong. Your best score is saved in this browser. Take it again on another day to check that the weak topics have improved. The tasks are original practice items, not questions from any real employer test.
The test
The timed test needs JavaScript.
Task 1 · Totals
In B7, total the net amounts of the five invoices.
Task 2 · Absolute references
In D2, calculate the gross amount (net plus tax at the rate in G1) in a single formula without using column C, then fill it to D6.
Task 3 · Logic and counting
Running balances are in E2:E8. In E10, count how many balances are below zero.
Task 4 · Conditional totals
In G10, total all credits posted to Cash in the journal (A2:D13).
Task 5 · Lookups
Account number 2000 is in J2. In K2, return its account name from the chart of accounts in F1:H8.
Task 6 · Dates and aging
Buckets are in F2:F8. In H3, count the invoices in the Over 60 bucket.
Task 7 · Reconciliation
The adjusted bank balance is in H4 and the book balance is in H6. In H7, calculate the unreconciled difference (adjusted bank balance minus book balance).
Task 8 · Depreciation
In B5, calculate total straight-line depreciation over the van's whole life.
Task 9 · Conditional totals
In G6, total Sales department spending in Feb.
Task 10 · Finance functions
Tidewater Dental is financing equipment (loan B1, annual rate B2, years B3). In B4, calculate the monthly payment as a positive number.