Excel Basic Formulas

60 Minutes

4 Questions

Designed to evaluate a candidate's fundamental skills in Excel, this assessment focuses on basic formulas and tasks. Candidates will be challenged to use simple formulas like SUM and AVERAGE, manage sheet operations such as removing duplicates and merging sheets, and more. This assessment aims to verify the candidate's proficiency in using these basic Excel functionalities in everyday 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