Microsoft Excel Tests
These tests assess your ability to use Microsoft Excel. It’s often given by employers to screen candidates who are required to be familiar with the program. There are, however, ways to prepare for the test and achieve a better score.
Prepare yourself for leading employers
Typical Excel test formats & example practice questions
Here we have an example of a typical Excel Test, similar to other practice tests available online:
|Hours||No. of Sales||Stock Purchased||Revenue|
|9am - 12pm||80||100 pieces||£350|
|12pm - 4pm||110||300 pieces||£2000|
|4pm - 7pm||200||700 pieces||£4000|
|7pm - 10pm||100||120 pieces||£300|
Basic Excel test
If you’re taking an Excel Test where only basic knowledge is required, you might be asked to:
- Create a basic SUM formula for the total number of transactions
- Change the table alignment to Center
Intermediate Excel test
For a test of intermediate knowledge of Microsoft Excel, typical questions might be:
- Calculate the average number of transactions in a 3-hour window
- Apply conditional formatting to highlight all cells with transactions greater than 120
Advanced Excel test
Finally, these would be typical questions at advanced level:
- Create a pivot table for monthly sales, assuming each day was the same as the one shown in the table
- Work out the average pieces of stock purchased per customer for each time window
After using the platform for two weeks, I’ve never felt more prepared for an Aptitude test.Ethan used Practice Aptitude Tests to improve his situational judgement scores. Start your success story
Microsoft Excel Tests Tips
1Read the questions carefully
It might seem obvious, but sometimes we’re too anxious to give a question proper time and we end up misreading it. Make sure you understand the charts and the text; don’t be afraid to re-read the question multiple times. Verbal reasoning tests can be a great tool to practice your text comprehension skills necessary to take an Excel Test.
2Know what to expect
Each job needs different Excel skills. Know what the role you’re applying for requires and make sure you’re confident in those skills — they are the most likely to be tested.
3Learn keyboard shortcuts
Doing a job right is not just about the skills, but also the time it takes to complete. An employer may want to test your knowledge of keyboard shortcuts to make sure you can go through basic tasks quickly and efficiently.
4Know your maths
Of course, Excel is designed to make calculations easier, but it doesn’t hurt to know what a number should be in order to double-check you’re using the program right. Practicing how to calculate percentage increases, percentage decreases, simplify ratios and add together percentages will help you gain confidence when using Excel.
Improve your scores with our intelligent learning system
- Get instant access 24/7 to real life tests
- Track historical test performance with our custom dashboards
- Learn from mistakes with our fully worked solutions
- Prepare for top employers with our bespoke employer packages
- Compare your scores against industry standards