How our test assesses Microsoft Excel skills
In Picked's Microsoft Excel test, candidates will need to answer a range of questions targeting an intermediate level of proficiency, from demonstrating knowledge across various Microsoft Excel features and functions to troubleshooting questions.
Understanding tasks such as the creation of financial models, budgeting and analysis, various Excel-based reports, performance dashboards, data analysis, and excel automation is extremely useful.
The Excel test is designed to indicate how well a candidate understands Microsoft Excel based on a final test score, which can then be compared to the scores of other applicants.
The multiple-choice questions consist of one correct answer and two to four distractors. The distractors are generic mistakes or misconceptions, which makes the test challenging and helps measure a candidate's proficiency more accurately.
During the development process, the test was rigorously analysed to maximise reliability and validity in line with industry best practices. It was created and tested by experienced data analysts and psychometric experts, and field-tested with a representative sample of job applicants who have varying Microsoft Excel experience, just like you might find in a talent pool.
Each test is reviewed by a panel of individuals representing diverse backgrounds to check for any sensitivity, fairness, face validity and accessibility issues. This ensures each candidate has a fair chance of demonstrating their true level of Microsoft Excel proficiency.
Our software tests are monitored to ensure they are up-to-date and optimised for performance.