A
Active Mind
Training Services
|

Active Mind Excel Intermediate Skills Assessment

Practical Skills Simulation

This assessment evaluates your ability to work with data in Excel: filtering, sorting, conditional formatting, linking worksheets, grouping and subtotals. You will work directly with a simulated workbook. Read each instruction carefully and complete the required task.

Task 1
Filter Sales Records
Task 2
Sort Data
Task 3
Highlight Sales with Conditional Formatting
Task 4
Link Worksheets
Task 5
Group and View Data
Task 6
Create Subtotals

How It Works

  1. 1
    Complete practical tasks

    Work directly in the interactive spreadsheet. Read each task's instructions and complete the required actions.

  2. 2
    Enter values and formulas

    Click a cell to select it, type your value or formula, and press Enter to confirm. Formulas begin with the equals sign (=).

  3. 3
    Correct your mistakes

    Edit a cell to correct an answer. Use Undo or Reset Task when needed. Reset Assessment clears your overall progress, so use it carefully.

  4. 4
    Choose your mode

    Practice: feedback, hints and learning notes after each submission; retry tasks to learn from mistakes. Assessment: no hints; your score, pass/fail result and competency breakdown appear in the final report. Normal editing and corrections remain possible.

This is a simulated Excel environment. Some features and keyboard shortcuts may differ from Microsoft Excel.

Mode

Total 100 points · Pass mark 70% · Unlimited attempts per task