Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
Marketing is sending the year-end newsletter and needs to know how many CRM contacts have no email on file. The AI assistant answered in G1.
AI assistant: “There are 14 contacts with no email on file (G1).”
Check the AI’s formula in G1 and fix it so it counts the contacts in rows 2 to 17 that have no email.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Contact | Phone | Contacts with no email | 14AI | ||||
| 2 | Maria Hart | maria.hart@meadowclinic.com | 555.643.0064 | |||||
| 3 | Kevin Hart | kevin.hart@orchardlogistics.com | 555.697.5360 | |||||
| 4 | Kevin Garcia | kevin.garcia@graniteclinic.com | 5559527650 | |||||
| 5 | CHRIS PATEL | chris.patel@pioneerconsulting.com | 555.538.7574 | |||||
| 6 | peter hart | 555.749.1680 | ||||||
| 7 | Emma Jensen | emma.jensen@riverdental.com | 5559751233 | |||||
| 8 | julia stone | julia.stone@cedarrealty.com | (555) 788-6885 | |||||
| 9 | Rachel Price | rachel.price@northacademy.com | 555.556.0303 | |||||
| 10 | mark PATEL | mark.patel@lakesidestudios.com | 5552964610 | |||||
| 11 | sam WALSH | +1 555 244 8804 | ||||||
| 12 | grace WARD | grace.ward@harborlawgroup.com | (555) 534-0584 | |||||
| 13 | olivia jensen | olivia.jensen@willowpharmacy.com | (555) 491-6073 | |||||
| 14 | Leo Fox | leo.fox@falcondental.com | 555.554.8960 | |||||
| 15 | John Young | john.young@bluemotors.com | 555-624-8342 | |||||
| 16 | david WALSH | david.walsh@atlasconsulting.com | 555.956.1029 | |||||
| 17 | PAUL NOVAK | paul.novak@granitepharmacy.com | 555-502-3558 | |||||
| 18 | ||||||||
| 19 | ||||||||
| 20 |
=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