What this level covers
Where a model starts making decisions. IF and nested logic, AND and OR, SUMIF and COUNTIF and their multi-condition versions, VLOOKUP and INDEX/MATCH and XLOOKUP, and the text functions that clean up data before any of it will work. Eighty scored cells.
One workbook. Lessons to read, practice grouped by topic, then a mixed checkpoint. 80 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.