What this level covers
The modern toolkit and the discipline around it. Dynamic arrays, FILTER and SORT and UNIQUE, LET and LAMBDA, and the auditing habits that find a broken link before someone else does. Fifty-five scored cells.
One workbook. Lessons to read, practice grouped by topic, then a mixed checkpoint. 55 scored cells.
Inside the file
- 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.