Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
Reading the rule. Say the rule out loud. "This and that" means both must be true. "This or that" means one is enough. Swapping the two is easy to miss, so test the formula on a row that meets only one rule.
=OR(5>3,2>4) is TRUE, =AND(5>3,2>4) is FALSE
Sales calls key accounts personally. The rule: Enterprise segment and an order of 1,000 or more. The AI’s list has far more Yes rows than the team expected.
AI assistant: “I flagged key accounts in D2:D11: Enterprise customers and orders of 1,000 or more.”
Check D2:D11 and fix the formulas so only orders that meet both rules show "Yes".
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Order | Segment | Value | Key account? | ||||
| 2 | 50374 | Mid-Market | 1212.7 | YesAI | ||||
| 3 | 50458 | Enterprise | 367.5 | YesAI | ||||
| 4 | 50500 | Enterprise | 1410 | YesAI | ||||
| 5 | 50504 | Mid-Market | 467.24 | NoAI | ||||
| 6 | 51125 | Enterprise | 1614.15 | YesAI | ||||
| 7 | 50509 | Enterprise | 824.7 | YesAI | ||||
| 8 | 50511 | Mid-Market | 882 | NoAI | ||||
| 9 | 50513 | SMB | 639.2 | NoAI | ||||
| 10 | 50523 | Mid-Market | 1159.9 | YesAI | ||||
| 11 | 50528 | Enterprise | 2435 | YesAI | ||||
| 12 | ||||||||
| 13 | ||||||||
| 14 |
=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