Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
SEARCH vs FIND. SEARCH works like FIND but ignores capitals, so "vip" also matches VIP and Vip. Both return a position, or #VALUE! when nothing matches. Wrap either in ISNUMBER to get TRUE when the text is found and FALSE when it isn’t.
=ISNUMBER(SEARCH("refund",C2)) TRUE for "Refund sent" or "REFUND"Account managers type notes into the CRM by hand, in any mix of capitals. You asked the AI assistant to flag every contact whose note mentions VIP, so they get a call before the price change.
AI assistant: “Done! D2:D9 checks each note for vip. None of these contacts is a VIP account.”
Check the AI’s formulas in D2:D9. Fix them so each row shows TRUE when the note in column C mentions vip in any capitalisation, and FALSE otherwise.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Customer ref | Contact | Notes | VIP? | ||||
| 2 | C-1065 | Kevin Garcia | ;;VIP account | FALSEAI | ||||
| 3 | C-1076 | Chris Patel | Net-30 terms.. | FALSEAI | ||||
| 4 | C-1023 | Olivia Smith | VIP account ? | FALSEAI | ||||
| 5 | C-1061 | Elena Dimitrov | Vip account!! | FALSEAI | ||||
| 6 | C-1043 | Leo Moreno | Closed on Mondays** | FALSEAI | ||||
| 7 | C-1024 | John Jensen | VIP account ? | FALSEAI | ||||
| 8 | C-1058 | Leo Fox | Use loading dock B # | FALSEAI | ||||
| 9 | C-1086 | Julia Silva | VIP account;; | 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