Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
Wildcards in criteria. In criteria, * stands for any run of characters and ? for exactly one. "North*" matches every text that starts with North, "*Ltd" every text that ends in Ltd, and "*cafe*" any text that contains cafe. Without a wildcard, the criteria must match the whole cell.
=COUNTIF(A2:A60,"*Ltd") suppliers whose name ends in Ltd
The hospitality sales lead asked how much Brightline’s hotel customers spent in this sample of Q2 orders. The AI assistant says the answer is zero.
AI assistant: “Hotel customers spent 0 in these orders (F1). None of the names start with Hotels.”
Fix F1 so it adds up the order values (C2:C21) of every customer whose name ends in "Hotels".
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Order | Customer | Value | Hotel customers | $0.00AI | |||
| 2 | 50269 | Falcon Studios | $99.00 | |||||
| 3 | 50270 | Granite Fitness | $57.00 | |||||
| 4 | 50271 | Silver Pharmacy | $45.60 | |||||
| 5 | 50273 | North Studios | $249.63 | |||||
| 6 | 50274 | Summit Realty | $1,167.90 | |||||
| 7 | 50275 | North Bakery | $104.31 | |||||
| 8 | 50276 | Lakeside Print Co | $108.00 | |||||
| 9 | 50277 | Copper Media | $144.00 | |||||
| 10 | 50278 | Copper Architects | $120.58 | |||||
| 11 | 50279 | Bright Print Co | $247.61 | |||||
| 12 | 50281 | Atlas Realty | $585.00 | |||||
| 13 | 50282 | Granite Labs | $132.05 | |||||
| 14 | 50283 | Cedar Realty | $126.25 | |||||
| 15 | 50284 | Atlas Consulting | $49.50 | |||||
| 16 | 51115 | Harbor & Pine Hotels | $1,325.25 | |||||
| 17 | 50299 | Bright Hotels | $150.60 | |||||
| 18 | 51116 | Harbor & Pine Hotels | $1,638.00 | |||||
| 19 | 50362 | Bright Hotels | $45.13 | |||||
| 20 | 50369 | Beacon Hotels | $207.75 | |||||
| 21 | 50379 | Bright Hotels | $595.95 | |||||
| 22 | ||||||||
| 23 | ||||||||
| 24 |
=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