← All practice testsExcel skills

Levels 2 to 4 — the set

What these levels cover

Levels 2, 3 and 4 together — logic and lookups, finance and dates, then arrays and auditing. Two hundred and four scored cells in all, and ten dollars less than buying them one at a time.

3 workbooks, one per level, each with its own lessons, practice and checkpoint. 204 scored cells in all.

Inside each workbook

Instructions
What this level covers, how to work it, how it is marked.
Lessons
One card per topic. Read the card, then answer that topic on Practice.
Practice
The questions, grouped by topic. Orange cells are yours to fill in.
Checkpoint
Ten mixed questions with no topic headings, to see what stuck.
Score
Your result, by topic and overall.
Solutions
A worked answer for every question, shown when you ask for it.

A toggle at the top of the Test tab stays on N while you build, so you are working blind. Flip it to Y and every cell you filled turns green or red in place — no separate answer key. Values are compared, not formulas, so any construction that lands on the right number scores. The in-sheet coloring needs Excel 2010 or later; the Scoring tab works in any version.

More in excel skills