Accounting and Excel Test
TestDome skill assessments are used by more than 7,000 companies and 450,000 individual test takers.
For Jobseekers
Practice your skills and earn a certificate of achievement when you score in the top 25%.
Take a Practice TestFor Companies
Test how candidates think, strategize, and problem solve so you can interview the best.
Sign Up to Offer This TestTestDome Skill Assessments
Used by over 450,000 jobseekers
Trusted by over 7,000 companies
Premium questions with real-world problems
The Accounting and Excel test evaluates a candidate’s ability to measure, process, and communicate the financial information of a business or corporation, as well as the ability to organize and calculate data contained within a spreadsheet.
This assessment can be used as an accounting test for pre-employment screening of candidates applying for a variety of roles, including staff accountant, financial accountant, and management accountant, or as a finance test for candidates applying for financial analyst or financial management positions. A good candidate for any accounting job requiring the use of spreadsheets will be able to display competency with sorting and filtering data, using functions, and writing formulas.
This test requires candidates to perform assignments within spreadsheet software as well as answer multiple-choice and calculation questions about the principles and core subjects within the accounting and finance disciplines. Candidates can use either their personal copy of Microsoft Excel or the free web version of Excel to complete the test.
TestDome is trusted by businesses large and small
Practice your skills.
Sign up for a trial plan.
Free Sample Questions for Accounting and Excel Test
Our sample questions are free for companies to use on a trial plan. See more about our premium questions for paid plans below.
Tax Inclusive
Your company sells products to customers in two cities, New York and San Francisco. You have been asked to calculate each product’s retail prices inclusive of sales taxes in these cities.
Specifically, you need to:
- Write formulas to calculate the retail prices, inclusive of sales tax, using the net prices of each product.
- Make sure you reference cells A5 and B5 in your formulas.
Note: Do not use array formulas in your work.
Your task is to download the file ‘TaxInclusive-RawData.xlsx’ file and execute the request. When you have completed your work, save it in .xlsx format, then upload that file for evaluation.
Cash Withdrawal
When a bank's customer makes an ATM cash withdrawal from the customer's account, which classes of the bank's Chart of Accounts will be affected?
Time Filters
Your company’s accounting department has asked you to give them a list of orders filtered by two periods of time:
- On 'Sheet1', they need orders spanning a two-month period (from the 1st of July, 2018, to the 31st of August, 2018).
- On 'Sheet2', they need all orders for the period before the 1st of July, 2018, and all orders for the period after the 31st of August, 2018.
Your task is to download the file 'TimeFilters-RawData.xlsx’ file and execute this request. When you have completed your work, save it in .xlsx format, then upload that file for evaluation.
Total Interest
Where can information about the total interest accrued during the reporting period of one year be found?
Practice your skills.
Pick the number of tests you need.
Pass/fail grouping
Our tests are designed to put candidates into either the pass group or the fail group so you can find the best candidates faster.
Full customization
We have pre-built tests and questions, but you can customize them however you like. Change the pass/fail scores, time requirements, and more.
Cheating protection
Use tests that solve real-world problems, with no answers that can be easily found online. Because we test performance and skills (not information), we allow the use of online resources, just like in real life. Copy/paste prevention and online proctoring via webcam prevent cheating.
Candidate reporting
Get an overview into the percentage of passes and fails. Then dive deeper into the results of your top candidates to select who goes onto the next phase of hiring.
Learn more
Sign up for a trial plan.
Premium Questions for Accounting and Excel Test
TestDome offers a premium questions library with 1000+ unique, hand-crafted questions whose answers can’t be found online. If you spot an answer somewhere online, we’ll give you a refund.
Question Names
These premium questions are included in this pre-built test and can be added to any multi-skill test. Please sign up for a paid plan to view the questions in detail.
Net Income, Equity, Commodity Sale, Transfer, Balance Sheet, Office Chairs, Production Line Value, Woodworking Machine, Account Types, Profit and Income, Balance Sheet Reports, Total Assets, Product Lookup, Overdue Invoices, Hot Beverage Filters, Order Display, Currency Conversion, Aussie Freight, Debits or Credits, Sales Invoice, Company Cars, Equity and Assets, New Corporate Building, Five Year Sales, Large Orders, Expense Management, Region CodeCovered Skills
Testing of these skills is covered in this pre-built test because they’re closely related. On our paid plan, you can easily create your own custom multi-skill tests.
Basic Financial StatementsRecommended Job Roles
These are the job roles that we recommend for the Accounting and Excel online test.
Take or Offer the Accounting and Excel Online Test
For Jobseekers
Take a Practice TestFor Companies
Sign Up to Offer This TestHow TestDome works
1. Choose or create a test
2. Share your test via URL or email
3. Review overall results and pass/fail grouping
4. Dive deeper into individual results
Excellent support & free concierge service
We offer fast, hands-on support for any question or concern you might have. If you want help with building a custom test or inviting candidates, we’ll handle everything for you.
Contact Support for any questions or to request our free concierge service.
