Excel Formula Expertise

45 Minutes

4 Questions

Designed to evaluate a candidate's expertise in Excel formulas thoroughly, the assessment incorporates practical challenges that require candidates to write formulas to address specific problems. It covers advanced functions such as pivot tables, VLOOKUP, HLOOKUP, INDEX, and MATCH, emphasizing the candidate's ability to apply these tools effectively in real-world scenarios.

Example Question:

Excel

The following Excel file contains a store sales dataset.

Please identify the profit when the number of units sold was 12.

If there are more than a few occasions when it occurred, choose the one that got the highest profit.

The result should be in cell O9997.

When ready, upload the Excel and verify your result is correct.

Note:

The result must be in cell O9997