This Accounting and MS Excel Test Separates Good From Bad Hires

Check our public questions below

Solve questions to get feedback or
take a practice test and get a free certificate.

Screen with work-sample questions

Work-samples are the best predictor of work performance. 8,000+ companies use TestDome premium questions.

About the test

The Accounting and MS 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 MS Excel to complete the test.

Sample public questions

Easy
2 min
mcq
Public
Basic Financial Statements
Accounting and Finance
Interest Expenses

Where can information about the total interest accrued during the reporting period of one year be found?

Easy
2 min
mcq
Public
Double-Entry Bookkeeping
Accounting and Finance
Balance Sheet
Chart of Accounts

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?

Easy
10 min
filev
Public
MS Excel
Formulas and Functions

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.

Easy
10 min
filev
Public
MS Excel
Data Filtering
Data Management

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.

Easy
2 min
mmcq
Public
Double-Entry Bookkeeping
Accounting and Finance
Chart of Accounts
Debits and Credits
Fixed Assets

Your company just purchased a company vehicle with cash.

For jobseekers: get certified

Earn a free certificate by achieving top 25% on the Accounting and MS Excel test with public questions.

Take a Certification Test

Sample silver certificate

Sunshine Caprio

Java and SQL

TestDome
Certificate

TestDome logo on certificate

For companies: premium questions

Buy TestDome to access premium questions that can't be practiced.
Get money back if you find any premium question answered online.

Sign Up to Offer this Test

29 more premium Accounting and MS Excel questions

Balance Sheet, Office Chairs, Production Line Value, Woodworking Machine, Debits or Credits, New Corporate Building, Account Types, Company Cars, Commodity Sale, Transfer, Sales Invoice, Equity and Assets, Total Assets, Profit and Income, Net Income, Equity, Currency Conversion, Order Display, Aussie Freight, Product Lookup, Large Orders, Hot Beverage Filters, Expense Management, Region Code, Plurality Corp., TDEC Inc., Balance Sheet Reports, Overdue Invoices, Five Year Sales.

Skills and topics tested

  • Basic Financial Statements
  • Accounting and Finance
  • Balance Sheet
  • Double-Entry Bookkeeping
  • Accounts Receivable
  • Chart of Accounts
  • Depreciation
  • Fixed Assets
  • Debits and Credits
  • Income Statement
  • Asset Liquidity
  • Invoices
  • Liabilities
  • Salaries
  • Interest Expenses
  • MS Excel
  • Formulas and Functions
  • Data Filtering
  • Data Management
  • Data Sorting
  • Data Lookup
  • Pivot Tables

For job roles

  • Accountant
  • Financial Accountant
  • Financial Analyst
  • Financial Manager
  • Management Accountant
  • Staff Accountant

Sample candidate report

What others say

Decorative quote

Simple, straight-forward technical testing

TestDome is simple, provides a reasonable (though not extensive) battery of tests to choose from, and doesn't take the candidate an inordinate amount of time. It also simulates working pressure with the time limits.

Jan Opperman, Grindrod Bank

Product reviews

G2 High Performer 2022G2 Read Our Reviews

Used by

Solve all your skill testing needs

150+ Pre-made tests

From web development and database administration to project management and customer support. See all pre-made tests.

90+ skills

From JavaScript and SQL to English and customer support. See all questions to filter by skill.

Multi-skills Test

Mix questions for different skills or even custom questions in one test. See an example.

How TestDome works

1

Choose a pre-made test
or create a custom test

2

Invite candidates via
email, URL, or your ATS

3

Candidates take
a test remotely

4

Sort candidates and
get individual reports

Want to know more?