Mock exams

Excel mock exams

Timed exams built from the course tasks: a live spreadsheet, no hints, and an automatic score with a breakdown by skill.

These are FormulaCamp practice exams, not an official Microsoft certification.

The Sample exam is free. The level and interview exams are part of Pro + Exams.

Level exams

Free

Four short tasks in eight minutes: try the exam format for free.

4 tasks · 8 min · pass mark 70%

Level exam

First formulas, references, totals, simple lookups and error handling.

8 tasks · 25 min · pass mark 70%

Level exam

Functions, IF logic, SUMIFS and COUNTIFS, text and dates, lookups and dynamic arrays.

10 tasks · 35 min · pass mark 70%

Level exam

Financial math, statistics, weighted averages and business calculations.

10 tasks · 45 min · pass mark 70%

Level exam

Formula tasks from the expert tracks: model checks, grouped totals, data cleanup and audits.

10 tasks · 50 min · pass mark 70%

Interview

Typical interview tasks: lookups, SUMIFS and COUNTIFS, IF logic, cleaning text and dates, summaries by formula.

10 tasks · 30 min · pass mark 70%

Interview

Lookups, conditional totals, dynamic arrays, statistics and financial functions at analyst level.

12 tasks · 40 min · pass mark 70%

Each attempt draws its tasks at random from real course tasks, balanced across skills, so a retake is a new exam.
You work in the same spreadsheet as in the lessons. Nothing is checked until you submit, and there are no hints.
You pass with 70% or more. The result shows your score by skill and the lessons for your weak spots.
The timer keeps running if you leave the page; your work is saved in this browser and the exam is submitted when time is up.