How to Create a Custom MS Excel Question

Use Testlify's MS Excel question type to evaluate candidates' spreadsheet skills with an automatically graded test-case system.

Before you begin

• Have an Excel (.xlsx) template file ready to share with candidates.
• Know the expected cell values for each test case you plan to create.

Steps

1. Open or create an assessment — Create a new assessment or open an existing one to edit.
2. Go to the Questions section — Click Questions in the left panel.
3. Select MS Excel — Under custom question types, choose MS Excel.
   
4. Add your question — Type the question prompt in the question box.
5. Provide the Excel file — In the Excel box on the right, paste the link to the Excel file candidates will use.
   
6. Set up test cases — Specify each target cell and its correct value. These test cases are used to automatically grade candidate responses.
   
7. Assign scores — Set point values for each test case based on your criteria.
   
8. Save the question — Click Save to add the question to your assessment.

Reviewing candidate responses

Each candidate receives their own copy of the Excel file when they attempt the question. After the assessment, open the Candidate Details Page (CDP) to view each candidate's Excel responses and scores individually.

Need help? Contact support.