Formula Lab · Basic assessment

Make the numbers answer you.

Five essential Excel challenges. Type each formula yourself, select cells right on the sample worksheet, and get instant feedback—no workbook required.

How to use the quiz

Pick a level: Basic, Intermediate, or Advanced. Each challenge gives you a worksheet and a goal. Type your formula in the formula bar, and click worksheet cells to insert their references—no need to type ranges by hand. Press Enter or Run formula to check it.

Your formula is what counts. The right formula passes; a hardcoded number does not, even if the answer is correct.

Level overview

Sales_DataCells A1:E9
Press Enter to run
Cell selection is always on. Type your formula, then choose cells on the worksheet to insert their references.
✓

Basic assessment complete.

You handled the four core summary functions and calculated unit cost with a direct cell formula.