Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
LEFT and RIGHT. LEFT(text, n) returns the first n characters of a text; RIGHT(text, n) returns the last n. They work on the cell's text, so a code like INV-50001 can be split into its parts without retyping anything.
=LEFT("INV-50001",3) gives INVThe warehouse exports every stock line with a SKU such as PP-101-BX. The first two letters are the category: PP is Paper & Print, CK Coffee & Kitchen, CL Cleaning and DS Desk Supplies.
In C2:C9, return the two-letter category code at the start of each SKU in column A. Use a formula that points at column A.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | SKU | Product | Category code | |||||
| 2 | PP-101-BX | Copy Paper A4 (500) | ||||||
| 3 | CK-201-PK | Espresso Beans 1kg | ||||||
| 4 | CL-303-CS | Paper Towels (24) | ||||||
| 5 | DS-401-BX | Ballpoint Pens (50) | ||||||
| 6 | CK-203-CS | Paper Cups (1000) | ||||||
| 7 | PP-103-EA | Toner Cartridge Black | ||||||
| 8 | CL-305-PK | Disinfectant Wipes (12) | ||||||
| 9 | DS-406-PK | Notebook A5 (10) | ||||||
| 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