How TestDome Automatically Evaluates MS Excel Tests

Posted on May 6, 2026 by Josip Kremenic

A good Excel test should measure whether a candidate can actually work in Excel. That is why TestDome’s MS Excel test includes spreadsheet work-sample questions: candidates download an initial .xlsx file, complete a realistic task in Microsoft Excel or Excel for the web, and upload the finished workbook for automatic evaluation.

This post explains how that automatic evaluation works and why it gives employers a stronger signal than a test made only of multiple-choice questions.

Why we use real Excel files instead of only quiz questions

Multiple-choice questions can check whether someone recognizes Excel concepts, but many jobs need more than recognition. Administrative assistants, accountants, data analysts, managers, and sales teams often need to clean data, write formulas, create pivot tables, and prepare charts that other people can understand.

File-upload questions let candidates solve tasks in the same way they would solve them at work: open a workbook, inspect the data, choose the right Excel feature, make the change, save the file, and submit the result. The scoring is still automatic, but the task itself is practical.

The candidate workflow

1. The candidate opens an MS Excel question in TestDome.
2. They download a starting .xlsx workbook.
3. They complete the requested task in Microsoft Excel or in the free Excel Online.
4. They save the completed workbook in .xlsx format.
5. They upload the file to TestDome for automatic evaluation.

The candidate does not need to learn a special testing interface. They use the spreadsheet tool they already know, while TestDome evaluates the uploaded workbook automatically.

What happens after a candidate uploads an Excel file

TestDome’s Excel evaluation engine opens the submitted workbook and validates the workbook model. We use GemBox.Spreadsheet, a .NET Excel library from GemBox. GemBox.Spreadsheet gives our evaluation engine access to worksheets, cells, formulas, charts, axes, legends, filters, and pivot-table structures.

Each Excel question has a question-specific validator written in C#. The validator checks whether the uploaded workbook satisfies the requirements in the question description. Instead of judging the candidate’s clicks or the exact path they took, the engine checks the result saved in the file.

What the validator can check

Different Excel questions require different checks. Depending on the task, the validator can inspect workbook properties such as:

• worksheet count, worksheet names, used ranges, and workbook structure;
• cell values, formulas, cell references, and formula outputs;
• lookup logic such as VLOOKUP, INDEX MATCH, match type, tiered references, and two-dimensional lookups;
• data filtering, advanced filters, exclusion criteria, sorting, and date ranges;
• pivot tables, field groups, and summarized data;
• conditional formulas, date manipulation, currency conversion, and calculated fields;
• charts, including chart type, axes, scale, gridlines, data labels, legends, titles, series names, and series values.

Example: evaluating an Excel chart task

One public MS Excel question, Sales Comparison, asks the candidate to create a clustered column chart that matches a target chart. A validator for this kind of question can check the workbook at several levels:

• Can the uploaded workbook be opened?
• Does it contain the expected worksheet and chart structure?
• Is the chart the requested type?
• Are the horizontal and vertical axes visible, ordered, titled, and scaled as required?
• Are gridlines, legend placement, chart title, and formatting consistent with the task?
• Do the data series have the expected names, order, and values?

The simplified example below shows the general idea:

using GemBox.Spreadsheet;
using GemBox.Spreadsheet.Charts;
using NUnit.Framework;

ExcelFile workbook = ExcelFile.Load(uploadedFile);
ExcelWorksheet sheet = workbook.Worksheets[0];
Assert.That(workbook.Worksheets.Count, Is.EqualTo(expectedWorksheetCount));

ExcelChart chart = sheet.Charts[0];
Assert.That(chart, Is.TypeOf<ColumnChart>());
Assert.That(chart.Title.DisplayText.Trim(), Is.EqualTo(expectedChartTitle));
Assert.That(chart.Series.Count, Is.EqualTo(expectedSeriesCount));

This style of validation is important for Excel assessment because the final workbook is the work product. A candidate can use different Excel commands and still pass if the resulting workbook meets the requirements.

Focused test cases make scoring easier to understand

We split Excel validation into focused test cases. A single question might check several independent parts of the task, such as workbook structure, formulas, filters, pivot-table setup, or chart details.

This approach helps with a more precise scoring – candidates can receive points for the parts they solved correctly.

Why GemBox.Spreadsheet is a good fit for automatic Excel evaluation

Our Excel automatic evaluation engine needs to read .xlsx files reliably and inspect spreadsheet objects programmatically. GemBox.Spreadsheet is designed for .NET applications and can work with workbook content such as cells, formulas, formatting, charts, and pivot tables without requiring Microsoft Excel to run on the server.

We were able to use GemBox’s team spreadsheet expertise while designing our Excel questions and our Excel evaluation engine. That matters when a test needs to evaluate more than final numbers. In real Excel work, details such as lookup ranges, pivot-table fields, chart axes, labels, and series order can all be part of the required result.

Skills covered by TestDome’s MS Excel questions

The MS Excel question bank covers both public practice questions and premium screening questions. The topics include practical spreadsheet skills such as:

• formulas and functions;
• cell references and conditional formulas;
• VLOOKUP, INDEX MATCH, match type, and two-dimensional lookup tasks;
• data sorting, filtering, advanced filters, and exclusion criteria;
• date manipulation and date ranges;
• pivot tables and field groups;
• bar charts, column charts, pie charts, chart axes, legends, labels, and chart data.

These are the kinds of spreadsheet tasks that appear in everyday business work, from expense management and sales reports to customer feedback, invoices, freight data, performance reviews, and lookup-heavy product lists.

What this means for employers

Automatic Excel evaluation gives hiring teams a consistent way to screen practical spreadsheet skills before interviews. The candidate completes a realistic task, TestDome evaluates the submitted workbook, and the employer can compare candidates using objective results.

For roles where Excel accuracy matters, this reduces the risk of hiring someone who can talk about Excel but cannot produce a correct spreadsheet under realistic conditions.

FAQ

Can candidates use Excel Online?

Yes. Candidates can solve the file-upload questions using Microsoft Excel or the free Excel for the web, as long as they save and upload the completed workbook in .xlsx format.

Does TestDome evaluate the final workbook or the candidate’s clicks?

TestDome evaluates the uploaded workbook. The validator checks the resulting file, not the exact sequence of clicks the candidate used to create it.

Can automatic evaluation grade charts and pivot tables?

Yes. For file-upload Excel questions, validators can inspect workbook objects such as chart type, axes, titles, legends, series values, pivot-table fields, formulas, filters, and sorted data.

Does the MS Excel test contain only multiple-choice questions?

No. The MS Excel test includes work-sample tasks where candidates download a workbook, complete a task, and upload the file for automatic evaluation. Multiple-choice questions can still be useful for some concepts, but file-upload tasks are the best way to test practical spreadsheet work.

Why does automatic evaluation matter?

It lets TestDome test real Excel work at scale. Employers get consistent scoring, while candidates get to use the same Excel workflow they would use on the job.

Test practical MS Excel skills

To see the public questions and screening coverage, visit TestDome’s MS Excel test.