Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
LEN. LEN(text) counts the characters in a text, including spaces and dashes. When every valid code has the same length, LEN is a fast way to find the broken ones: anything longer or shorter is suspect.
=LEN("West") gives 4A supplier typed some SKUs by hand and a few are broken. Every valid Brightline SKU, like PP-101-BX, is exactly 9 characters long.
In B2:B10, return the number of characters in each SKU in column A. In E2, write a formula that counts how many SKUs are not 9 characters long.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | SKU | Length | ||||||
| 2 | PP-101-BX | Broken SKUs | ||||||
| 3 | CK-20-PK | |||||||
| 4 | CL-303-CS | |||||||
| 5 | DS-401-BOX | |||||||
| 6 | CK-205-PK | |||||||
| 7 | PP-1010-BX | |||||||
| 8 | CL-306-CS | |||||||
| 9 | DS-402-PK | |||||||
| 10 | CL303CS | |||||||
| 11 | ||||||||
| 12 | ||||||||
| 13 |
=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