Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
TEXT. Dates are stored as numbers, and & joins the number, not what the cell shows. TEXT(value, format) turns a number into text in the format you give: "mmm d, yyyy" for Mar 5, 2025, "yyyy-mm-dd" for 2025-03-05, or "#,##0.00" for 1,234.50.
="Refund of "&TEXT(B2,"#,##0.00") gives Refund of 1,234.50
Customer service sends a one-line shipping update for each June order. Joining a date straight into text shows its serial number, like 45823, instead of the date.
In D2:D8, build a line like Order 50500 shipped Jun 15, 2025 via ParcelLine from the order in A, the ship date in B and the carrier in C. Show the date in the format mmm d, yyyy.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Order | Shipped | Carrier | Update | ||||
| 2 | 50500 | 2025-06-15 | ParcelLine | |||||
| 3 | 50501 | 2025-06-14 | Greenway Logistics | |||||
| 4 | 50502 | 2025-06-16 | ParcelLine | |||||
| 5 | 50503 | 2025-06-16 | Rapid Freight | |||||
| 6 | 50504 | 2025-06-18 | ParcelLine | |||||
| 7 | 50505 | 2025-06-17 | ParcelLine | |||||
| 8 | 50506 | 2025-06-16 | Rapid Freight | |||||
| 9 | ||||||||
| 10 | ||||||||
| 11 |
=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