Stop Guessing, Start Hiring Excel Experts
Excel is the backbone of data analysis, reporting, and business intelligence. But when hiring, how can you be sure a candidate’s skills match their claims?
Our immersive Excel assessments provide real-world challenges that go beyond multiple-choice questions. Instantly gauge a candidate’s ability to analyze data, use formulas, and navigate complex functions—before you make a hiring decision.
Self-assessments are unreliable, and testing proficiency manually is time-consuming. That’s where Zmartests comes in.


Real-World Challenges for Accurate Excel Skill Assessment
Zmartests’ Excel tests are fully immersive, replicating real workplace scenarios to assess true proficiency. From data analysis and pivot tables to advanced formulas, each test is designed to measure problem-solving skills in a practical setting.
Unlike traditional multiple-choice tests, our assessments require hands-on execution, ensuring a precise and reliable measure of Excel expertise. No guesswork, no shortcuts—just real skills, tested the right way.
Job roles where Excel skills are particularly in demand include:
100% Online, 100% Accurate Excel Skill Assessment
No software installation required — candidates can complete Zmartests’ Microsoft Excel assessments entirely online, directly from their browser. Every test runs on our secure servers using Microsoft Excel 365, the latest and most secure version.
All Excel features are available: ribbons, menus, keyboard shortcuts, formulas, pivot tables, right-clicks, and more. This ensures candidates work exactly as they would in a real job environment.
With this immersive and intuitive experience, you gain a true-to-life assessment of your candidates’ Excel proficiency, ensuring they’re fully prepared to deliver from day one.

Don’t Fall for the Dunning-Kruger Trap!
When it comes to Excel skills, self-assessments are often unreliable. The Dunning-Kruger effect—a well-documented cognitive bias—leads less experienced candidates to overestimate their abilities, simply because they don’t know what they don’t know. This gap between perception and reality is a common challenge for recruiters.
With Zmartests, you get an objective, data-driven evaluation of each candidate’s true Excel proficiency. Our assessments precisely determine their skill level (Beginner, Intermediate, Advanced, Expert) and percentile ranking, so you can hire with confidence and turn human resources into human assets.

Les coûts d’une mauvaise connaissance d’Excel
88%
88% des feuilles de calcul Excel contiennent des erreurs.
3 heures
3 heures pour compléter l’analyse des ventes au lieu de 30 minutes.
7125 $
7125 $ par année, par employé en perte de productivité.
11 semaines
11 semaines pour déceler une mauvaise embauche.
5 semaines
5 semaines pour trouver un autre employé compétent.

Excel Assessments Tailored to Your Hiring Needs
Every role requires a different level of Excel expertise. With Zmartests, you can choose the assessment that best fits your hiring criteria:
Our comprehensive skills bank lets you design a test that mirrors real-world job tasks. Plus, our team will collaborate with you to choose the most relevant test, guaranteeing an accurate, role-specific assessment that helps you identify the right talent with confidence.
Donec volutpat lacus leo, et vestibulum risus tristique sed. Phasellus ut neque quis sapien efficitur consectetur non non enim. Aenean auctor nisl.
Donec volutpat lacus leo, et vestibulum risus tristique sed. Phasellus ut neque quis sapien efficitur consectetur non non enim. Aenean auctor nisl.
Donec volutpat lacus leo, et vestibulum risus tristique sed. Phasellus ut neque quis sapien efficitur consectetur non non enim. Aenean auctor nisl.
Excel Skills Assessed
Formatting
- Change the column width and row height
- Insert or delete rows and columns
- Hide or show rows or columns
- Fill data automatically
- List of sequential dates
- Paste special
- Apply or remove cell borders
- Apply cell border color
- Change the width of cell borders
- Show or hide the thousands separator
- Format numbers as dates or time
- Format numbers as percentage
- Round a number to the decimal places
- Set or clear a print area
- Merge and unmerge cells
- Headers and footers in a worksheet
- Orientation of text in a cell
- Apply the same formatting
- Wrap text automatically
- Repeat rows at the top
- Enter a line break in a cell
- Unprotect cells
- Custom number format
- Conditional formatting
- Advanced conditional formating
- Protect a worksheet
- Table : automatic formatting
- Group/Ungroup
- Insert/delete a worksheet
- Format a Sheet Tab
- Reorganize worksheets
- Freeze/Unfreeze Panes
- Split Panes
- Insert/Delete links
- Change the calculation mode
- Special character
Calculation
- Blocking $ two dimensions
- Single $ lock
- Extend a formula over several cells
- AVERAGE function
- COUNT function
- SUM function
- Statistical functions
- Operator %
- Operator ^
- Operator * and /
- Operator + –
- Reference to multiple ranges
- Advanced IS function
- Standard SI function
- Standard SUM.SI/NB.SI function
- Time functions
- Text functions
- Naming/modifying range naming
- Using a named range in a formula
- Automatic SUM over subtotals
- Using data validation
- SOMMEPROD function
- SOMMEPROD “Conditional” function
Database
- Find / Replace
- Create a simple list
- VLOOKUP Function
- Advanced Filters
- Basic Filters
- Convert Text to Columns
- Automatic Filters
- Retrieving PivotTable Data
- Sorting Column Data Ascending / Descending
- Refreshing PivotTable Data
- Adding a Calculated Field in a PivotTable
- PivotChart
- Adding fields to a PivotTable
- Adding page fields to a PivotTable
- Adding data to an empty PivotTable
- Enable list totals (Basic)
- Advanced data search
- TRANSPOSE function
- Index functions
- MATCH function
- Advanced Index/Equiv functions
Chart
- Select data for a chart
- Show / hide data labels
- Show or hide legend
- Show or hide title
- Increase chart size
- Choose chart type
- Move title or caption
- Creating a graph with a “mixed” format
- Graphics: advanced axis management
- Graphic: Line/Column inversion
- Graphics: coloring
- Multi-axis graph
- Modify the format of an existing chart
- Waterfall chart
- Bubble chart
- Modify data labels