Accounting and MS Excel Test
For jobseekers
Practice your skills and earn a certificate of achievement when you score in the top 25%.
Take a Practice TestFor companies
Test candidates with real-world problems and interview the best ones.
Sign Up to Offer this TestAbout the test
The Accounting and MS Excel test assesses proficiency in handling financial data, including automatically evaluating Excel files uploaded as answers.
The key areas covered in the test include work sample tasks such as:
- Calculating with spreadsheet data to satisfy business needs.
- Using double-entry bookkeeping to categorize debits and credits.
- Determining profit, depreciation, and other basic financial values.
Roles such as accountant, auditor, and financial analyst rely on strong accounting and MS Excel skills to ensure accurate financial reporting, analysis, and decision-making.
Sample public questions
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 base price of each product.
- Make sure you reference cells A5 and B5 in your formulas.
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.
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 starting from the 1st of July, 2018, and stretching through 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.
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?
Where can you find information about the total interest accrued during the reporting period of one year?
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 TestSample silver certificate
Sunshine Caprio
Java and SQL TestDomeCertificate
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.
39 more premium Accounting and MS Excel questions
Balance Sheet, Commodity Sale, Office Chairs, Debits or Credits, TDEC Inc., Plurality Corp., Profit and Income, Region Code, Regional Sales, Large Orders, Currency Conversion, Industry Sectors, Order Display, Expense Management, Test Scores, Customer Feedback, Employee Conference, Five Year Sales, Aussie Freight, Hot Beverage Filters, Product Lookup, Employee Lookup, Electronic Products, Sales Invoice, New Corporate Building, Transfer, Account Types, Woodworking Machine, Equity, Balance Sheet Reports, Production Line Value, Net Income, Total Assets, Company Truck, Equity and Assets, Pivot Error, Purchase Logs, Worked Hours, Overdue Invoices.
Skills and topics tested
- Basic Financial Statements
- Accounting and Finance
- Balance Sheet
- Double-Entry Bookkeeping
- Accounts Receivable
- Chart of Accounts
- Debits and Credits
- Fixed Assets
- Depreciation
- Income Statement
- Salaries
- MS Excel
- Data Filtering
- Data Management
- Exclusion Criteria
- Charting
- Data Labels
- Pie Chart
- Conditional Formulas
- Data Sorting
- Cell References
- Formulas and Functions
- Bar Chart
- Chart Axes
- Advanced Filter Tool
- Data Lookup
- Field Groups
- Pivot Tables
- INDEX MATCH
- Two-Dimensional Lookup
- Match Type
- VLOOKUP
- Invoices
- Asset Liquidity
- Liabilities
- Interest Expenses
- Video
- Date Manipulation
For job roles
- Accountant
- Auditor
- Financial Accountant
- Financial Analyst
- Financial Manager
- Management Accountant
- Staff Accountant
Sample candidate report
Need it fast? AI-crafted tests for your job role
TestDome generates custom tests tailored to the specific skills you need for your job role.
Sign up now to try it out and see how AI can streamline your hiring process!
What others say
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
Used by
Solve all your skill testing needs
150+ Pre-made tests
130+ skills
Multi-skills Test
How TestDome works
Choose a pre-made test
or create a custom test
Invite candidates via
email, URL, or your ATS
Candidates take
a test remotely
Sort candidates and
get individual reports