Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
ISBLANK and its blind spot. ISBLANK(cell) is TRUE only when a cell holds nothing at all. A cell with a single space looks empty but holds text, so ISBLANK says FALSE and ISTEXT says TRUE. To treat spaces-only as empty, test the trimmed text instead.
=TRIM(D2)="" TRUE for an empty cell and for one holding only spaces
Before the newsletter goes out, sales wants every CRM contact without an email address so reps can call them. The import left some email cells empty and others holding only spaces.
AI assistant: “Done! C2:C9 flags the contacts with no email. Only Peter Hart and Chris Baker are missing one.”
Check the AI’s formulas in C2:C9. Fix them so each row shows TRUE when the email in column B is missing (empty or only spaces) and FALSE when there is an address.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Contact | No email? | ||||||
| 2 | Maria Hart | maria.hart@meadowclinic.com | FALSEAI | |||||
| 3 | Peter Hart | TRUEAI | ||||||
| 4 | Emma Jensen | emma.jensen@riverdental.com | FALSEAI | |||||
| 5 | Sam Walsh | FALSEAI | ||||||
| 6 | Grace Ward | grace.ward@harborlawgroup.com | FALSEAI | |||||
| 7 | Julia Garcia | FALSEAI | ||||||
| 8 | Chris Baker | TRUEAI | ||||||
| 9 | Leo Fox | leo.fox@falcondental.com | FALSEAI | |||||
| 10 | ||||||||
| 11 | ||||||||
| 12 |
=IF(B2>=1.5,SUM(C2:C9),0)Language
Full plan
Excel ✓ · SQL and Power BI also included
Cancel anytime · 14-day full refund · Secure payment by Stripe