Excel Test

TestDome skill assessments are used by more than 6,000 companies and 450,000 individual test takers.

Jobseekers: Get a Certificate

Take a Practice Test

Companies: Try First, Pay Later

Sign Up To Use This Test

The Excel test evaluates a candidate’s ability to work with spreadsheets, including the knowledge of how to organize, calculate, analyze, and visualize data contained within a spreadsheet.

It’s an ideal test for pre-employment screening of candidates applying for a variety of job roles. A good candidate for any job requiring the use of spreadsheets will be able to display competency with using functions, writing formulas, sorting and filtering data, and creating accurate charts. This Excel test can be used to screen large groups of candidates to select only those with the required Excel knowledge to bring in for an interview.

This test requires candidates to download data files, perform assignments within spreadsheet software, and upload their solution files for automatic evaluation. Candidates can use either their personal copy of Microsoft Excel or the free web version of Excel to complete the test.

Recommended Job Roles
Account Manager
Administrative Assistant
Data Analyst
Digital Marketing Specialist
Financial Accountant
Financial Analyst
Financial Manager
Management Accountant
Manager
Project Manager
Sales Manager
Sales Person
Secretary
Staff Accountant
Statistician
Sample Candidate Report

Sample Free Questions

Tax Inclusive

10min
  -  
Easy 
  -  
FILEV

Excel Formulas and Functions Public New

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.

Your task is to download the file ‘Tax Inclusive-Raw Data.xlsx’ file and 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. When you have completed your work, save it in .xlsx format, then upload that file for evaluation.

Time Filters

10min
  -  
Easy 
  -  
FILEV

Excel Data Filtering Data Management Public New

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 'Time Filters-RawData.xlsx’ file and execute this request. When you have completed your work, save it in .xlsx format, then upload that file for evaluation.

Use Free Questions On a Trial Plan

Premium Questions

The premium question library contains our unique, hand-crafted questions. We offer a refund if you find any of them answered online.

Questions
Currency Conversion, Order Display, Overdue Invoices, Large Orders
Skills
Excel Formulas and Functions Data Filtering Data Management Data Sorting
Score Distribution
# of candidates
0-33%
34-66%
67-100%
Score
Pricing For Premium Questions