Excel Test
TestDome skill assessments are used by more than 5,000 companies and 450,000 individual test takers.
Jobseekers: Get a Certificate
Take a Practice TestCompanies: Try First, Pay Later
Sign Up To Use This TestThe 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
Sample Candidate Report
Sample Free Questions
Tax Inclusive
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.
Tax Inclusive
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
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.
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 OrdersSkills
ExcelScore Distribution
| 0-33% | |
|---|---|
| 34-66% | |
| 67-100% |