Financial Analyst and MS Excel Test

TestDome skill assessments are used by more than 11,000 companies and 1,030,000 test takers.

For Jobseekers

Practice your skills and earn a certificate of achievement when you score in the top 25%.

For Companies

Test candidates with real-world problems and interview the best ones.

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.

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

Easy
7 min
filev
Public
AI-resistant
MS Excel
Cell References
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 base price of each product.
• Make sure you reference cells A5 and B5 in your formulas.

Easy
7 min
filev
Public
AI-resistant
MS Excel
Data Filtering
Data Management
Date Ranges

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.

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
3 min
num
Public
Financial Analysis
Activity Ratios
Current Asset Turnover Ratio

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?

For jobseekers: get certified

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

Sample silver certificate

Sunshine Caprio

Java and SQL
TestDome
Certificate

Skills and topics tested

• Basic Financial Statements
• Accounting and Finance
• Balance Sheet
• Depreciation
• Fixed Assets
• Liabilities
• Asset Liquidity
• Income Statement
• Interest Expenses
• Financial Analysis
• Debt Ratio
• Leverage Ratios
• Accounts Receivable
• Activity Ratios
• Receivables Turnover Ratio
• Profit Margins
• Profitability Ratios
• Investment Ratios
• Payout Ratio
• Retained Earnings
• Salaries
• Liquidity Ratios
• Debt-to-Equity Ratio
• Cash Ratio
• MS Excel
• Data Filtering
• Data Management
• Exclusion Criteria
• Data Sorting
• Date Functions
• Formulas and Functions
• Charting
• Data Labels
• Pie Chart
• Conditional Formulas
• Cell References
• Bar Chart
• Chart Axes
• Data Lookup
• Field Groups
• Pivot Tables
• INDEX MATCH
• Two-Dimensional Lookup
• Match Type
• VLOOKUP

For job roles

• Equity Analyst
• Financial Analyst
• Financial Manager
• Investment Analyst

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.

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

Solve all your skill testing needs

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

130+ 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.

How TestDome works

1

or create a custom test

2

Invite candidates via

3

Candidates take
a test remotely

4

Sort candidates and
get individual reports