REPORTING & ANALYSIS · ORIGINAL EXERCISE
A gap in the roster
Count unassigned tasks: blank owners in B2:B6.
This quest practices COUNTBLANK using a fictional business dataset. Read the sheet below, then enter the interactive quest to write and check your formula.
| Task | Owner | Status | Hours |
|---|---|---|---|
| Import | Ari | Done | 3 |
| Clean | Bea | Done | 4 |
| Review | Open | 2 | |
| Export | Cam | Open | 1 |
| Archive | Open | 2 |
Hints to get you started
- Blank owners indicate unassigned work.
- COUNTBLANK counts empty cells.
- Use B2:B6.
Show the worked solution
=COUNTBLANK(B2:B6)COUNTBLANK exposes missing information in a working report.
Make the skill stick
After solving the task, explain what each reference does and why the formula answers the business question. Try the workbook download inside the quest to practice in your own spreadsheet app.
Explore the rest of this region →