Get 25% off all test packages.

microsoft excel tests

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:

  1. Create a basic SUM formula for the total number of transactions
  2. Change the table alignment to Center

microsoft excel tests

Intermediate Excel test

For a test of intermediate knowledge of Microsoft Excel, typical questions might be:

  1. Calculate the average number of transactions in a 3-hour window
  2. Apply conditional formatting to highlight all cells with transactions greater than 120

Advanced Excel test

Finally, these would be typical questions at advanced level:

  1. Create a pivot table for monthly sales, assuming each day was the same as the one shown in the table
  2. 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

picked

Hire better talent

At picked we help companies build perfect teams

Join picked Try picked today

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.

Video Tutorials

Percentage change

2 mins

Data Interpretation

2 mins

Graph Interpretation

2 mins

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
    Intelligent learning system
Improve your hiring chances by 76%

Prepare for your Test

One-time payment. No recurring fees

One Test Package
1 month access
  • 1 test package of your choice
  • Dashboard performance tracking
  • Full solutions and explanations
  • Tips, tricks, guides and resources
Upgrade now 30-Day Money-back guarantee
All Test Packages
12 months access
  • 45 Numerical reasoning tests
  • 45 Verbal reasoning tests
  • 30 Diagrammatic reasoning tests
  • 30 Situational judgement tests
  • 25 Publisher packages e.g. SHL
  • 180 Employer packages e.g. HSBC
  • + 11 Extra packages including: Abstract, Inductive, Mechanical, Personality and more
  • Dashboard performance tracking
  • Full solutions and explanations
  • Tips, tricks, guides and resources
Upgrade now 30-Day Money-back guarantee

SSL secure payment