Financial Analyst 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 Financial Analyst and MS Excel test assesses proficiency in analyzing financial data, including automatically evaluating Excel files uploaded by candidates.
The test focuses on key skills with workplace tasks such as:
- Determining profit margins based on income statements.
- Using financial ratios to calculate values such as assets and liabilities.
- Calculating with spreadsheet data to satisfy business needs.
Financial analysts, business analysts, and financial analysts all need to access, analyze, and manipulate financial data to draw quantifiable conclusions about business operations.
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.
Where can you find information about the total interest accrued during the reporting period of one year?
Study the balance sheet information for Carlton Corporation in 2015 in the image below.
(Open full-size image in a new tab.)
What is the value of the Current Asset Turnover Ratio for Carlton Corporation in 2015?
(Round your answer to the nearest whole number.)
For jobseekers: get certified
Earn a free certificate by achieving top 25% on the Financial Analyst 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 Financial Analyst and MS Excel questions
Balance Sheet, Zero Debts, Receivables Collection, Net Profit Decrease, Criterion Inc., Profit and Income, Strawberry Inc., AP Williams, Webster and Sons, Region Code, Expense Management, Brightsense Inc., New Corporate Building, Woodworking Machine, Equity, Balance Sheet Reports, Production Line Value, Net Income, Total Assets, Company Truck, Equity and Assets, Pivot Error, Purchase Logs, Worked Hours, Test Scores, Industry Sectors, Customer Feedback, Five Year Sales, Product Lookup, Employee Conference, Large Orders, Aussie Freight, Currency Conversion, Regional Sales, Overdue Invoices, Electronic Products, Hot Beverage Filters, Order Display, Employee Lookup.
Skills and topics tested
- Basic Financial Statements
- Accounting and Finance
- Balance Sheet
- Financial Analysis
- Debt Ratio
- Leverage Ratios
- Accounts Receivable
- Activity Ratios
- Receivables Turnover Ratio
- Profit Margins
- Profitability Ratios
- Investment Ratios
- Payout Ratio
- Retained Earnings
- Depreciation
- Income Statement
- Salaries
- Liquidity Ratios
- Debt-to-Equity Ratio
- MS Excel
- Data Filtering
- Data Management
- Exclusion Criteria
- Advanced Filter Tool
- Cash Ratio
- Fixed Assets
- Liabilities
- Asset Liquidity
- Interest Expenses
- Pivot Tables
- Video
- Formulas and Functions
- INDEX MATCH
- VLOOKUP
- Bar Chart
- Chart Axes
- Charting
- Conditional Formulas
- Data Sorting
- Field Groups
- Match Type
- Data Lookup
- Two-Dimensional Lookup
- Cell References
- Data Labels
- Pie Chart
- Date Manipulation
For job roles
- Business Analyst
- Equity Analyst
- Financial Analyst
- Financial Manager
- Investment Analyst
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