MS Excel Test
TestDome skill assessments are used by more than 7,000 companies and 450,000 individual test takers.
For Jobseekers
Practice your skills and earn a certificate of achievement when you score in the top 25%.
Take a Practice TestFor Companies
Test how candidates think, strategize, and solve problems so you can interview the best.
Sign Up to Offer This TestTestDome Skill Assessments
Used by over 450,000 jobseekers
Trusted by over 7,000 companies
Premium questions with real-world problems
The MS 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 MS 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 MS Excel to complete the test.
TestDome is trusted by businesses large and small
Practice your skills.
Sign up for a trial plan.
Free Sample Questions for MS Excel Test
Our sample questions are free for companies to use on a trial plan. See more about our premium questions for paid plans below.
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.
Specifically, you need to:
- 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.
Note: Do not use array formulas in your work.
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.
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 '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.
Sales Comparison
You have been asked to create a column chart and need to make it look the same as the chart provided in the image below.
Your task is to download the ‘SalesComparison-RawData.xlsx’ file and use your spreadsheet knowledge to create the chart shown here. You should attempt to recreate this chart using any columns colors you want, but be sure to:
- Create a clustered column chart.
- Set up the horizontal axis categories and remove horizontal gridlines to match the image.
- Adjust the vertical axis scale and remove vertical gridlines to match the image.
- Add a chart title, vertical axis title, and legend that match those displayed in the image above.
- Ensure your data series are in the correct order.
When you have completed the chart, save it in .xlsx format, then upload that file for evaluation.
Practice your skills.
Pick the number of tests you need.
Pass/fail grouping
Our tests are designed to put candidates into either the pass group or the fail group so you can find the best candidates faster.
Full customization
We have pre-built tests and questions, but you can customize them however you like. Change the pass/fail scores, time requirements, and more.
Cheating protection
Use tests that solve real-world problems, with no answers that can be easily found online. Because we test performance and skills (not information), we allow the use of online resources, just like in real life. Copy/paste prevention and online proctoring via webcam prevent cheating.
Candidate reporting
Get an overview into the percentage of passes and fails. Then dive deeper into the results of your top candidates to select who goes onto the next phase of hiring.
Learn more
Sign up for a trial plan.
Premium Questions for MS Excel Test
TestDome offers a premium questions library with 1000+ unique, hand-crafted questions whose answers can’t be found online. If you spot an answer somewhere online, we’ll give you a refund.
Question Names
These premium questions are included in this pre-built test and can be added to any multi-skill test. Please sign up for a paid plan to view the questions in detail.
Currency Conversion, Order Display, Aussie Freight, Product Lookup, Large Orders, Hot Beverage Filters, Expense Management, Region Code, Industry Sectors, Regional Sales, Overdue Invoices, Five Year SalesCovered Skills
Testing of these skills is covered in this pre-built test because they’re closely related. On our paid plan, you can easily create your own custom multi-skill tests.
MS ExcelRecommended Job Roles
These are the job roles that we recommend for the MS Excel online test.
Take or Offer the MS Excel Online Test
For Jobseekers
Take a Practice TestFor Companies
Sign Up to Offer This TestHow TestDome works
1. Choose or create a test
2. Share your test via URL or email
3. Review overall results and pass/fail grouping
4. Dive deeper into individual results
Excellent support & free concierge service
We offer fast, hands-on support for any question or concern you might have. If you want help with building a custom test or inviting candidates, we’ll handle everything for you.
Contact Support for any questions or to request our free concierge service.
