Advanced Excel Online Test

Candidates Assessed

15755+

Organisations Served

157+

Advanced Microsoft Excel online test is the most effective pre-hire test for recruiters and hiring managers to assess advanced excel skills before hiring. This test contains questions on Macros, VLOOKUP, MATCH, PIVOT Tables, etc. Our customers have reported that the excel proficiency test has helped them reduce hiring cost by 40%.

Test Summary

The online advanced excel test reports give you detailed hiring analytics and you will surely get to know how the candidate deals with problem-solving using Excel and whether the candidate is the right fit for the job role. Moreover, Test Insights section helps to identify job fit candidates more accurately with score distribution & section analysis features.

The Excel proficiency test may contain MCQs (Multiple Choice Questions), MAQs (Multiple Answer Questions), Fill in the Blanks, Whiteboard Questions, Audio/Video Questions, AI-LogicBox, Job-based Simulations, True or False Questions, etc.

Test Duration: 20 minutes

No. of Questions: 10

Level of Expertise: Expert

Useful for hiring

Excel Expert with 3 to 4 yrs experience
Microsoft Office Specialist
Office Manager

Topics Covered

Chart Formatting

Excel advanced online test helps to evaluate candidates' knowledge of formatting the chart using format task pane

Large & Sum

Our online excel test helps to assess candidates' skills of using ‘Large’ function to identify largest value from the given set and ‘Sum’ function to calculate sum of given set

Datevalue

This assessment evaluates candidates' knowledge of using DateValue function to convert date from text to serial number

Concatenate

Our Excel proficiency test quantifies candidates' knowledge of using Concatenate function to combine values from multiple ranges

Aggregate

This assessment helps to assess candidates' knowledge of using aggregate function to a list

Substitute & Choose

Our online advance excel test helps recruiters to evaluate candidates' ability to use Substitute & Choose function

VLOOKUP

This assessment evaluates candidates' knowledge of using VLOOKUP to find things in a table

INDEX & Match

Excel online test helps to check candidates' ability to use Index function to return the value at a given location in a range or array & Match function to search for a specified item in a range of cells

Sample Questions

Choose from our 100,000+ question library or add your own questions to make powerful custom tests

Question types:

Multiple Option

Topic:

Choose

Difficulty:

Hard

Q 1. Which of the given functions will help you extract the name based on the serial number mentioned in Cell A13 dynamically?

Choose function in Excel

=CHOOSE(A13,D2:D10)

=CHOOSE(A13,D2,D3,D4,D5,D6,D7,D8,D9,D10)

=CHOOSE(A5,D2:D10)

=CHOOSE(4,D2:D10)

You can customize this test by

Setting difficulty level of test

Choose easy, medium or hard questions from our skill libraries to assess candidates of different experience levels.

Combining multiple skills into one test

Add multiple skills in a single test to create an effective assessment. Assess multiple skills together.

Adding your own questions to the test

Add, edit or bulk upload your own coding questions, MCQ, whiteboarding questions & more.

Requesting a tailor-made test

Get a tailored assessment created with the help of our subject matter experts to ensure effective screening.

Related Skills

Customer Service Aptitude Test

Trusted By

Pedro Furtado, Capacity Manager, Altran-Portugal

“Finding quality talent is a challenge more so when you consider the sheer number of resumes we get each year. To top this, the time we spent on our recruitment process was humongous. iMocha helped us to cut down on our candidate filtration time by 40 %, making it our preferred assessment tool.”