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 3hour 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
Within two hours of practice I have improved my score from 50% correct to 88%.Joseph used Practice Aptitude Tests to improve his numerical reasoning 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 reread 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 doublecheck 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.
Video Tutorials
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
Prepare for your Test
Onetime payment. No recurring fees