Level 2Text, Part 2Practice, 3 min
TEXT: a dashboard headline
The task
The dashboard needs a headline like March 2026 revenue: $48,250. In C2, join the month in A2 and the revenue in B2 into that sentence, using
TEXT to format each one.The data
The starting sheet. Cells outlined in green are where your formulas go.
| A | B | C | |
|---|---|---|---|
| 1 | Month | Revenue | Headline |
| 2 | March 2026 | $48,250 | |
| 3 | April 2026 | $51,900 |