Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
PROPER. PROPER(text) capitalises the first letter of every word and makes the rest small. It also capitalises after an apostrophe or dash, so check names like O’Neil. You can wrap it around a joined piece to fix the case of the whole result at once.
=PROPER("harbor & pine HOTELS") gives Harbor & Pine HotelsNames in the CRM import were typed in every style: CHRIS PATEL, mark PATEL, olivia jensen. The welcome letters go out tomorrow and need names like Chris Patel.
In C2:C9, join the first name (column A) and last name (column B) with one space, and give every word a capital first letter and small letters after it.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | First name | Last name | Letter name | |||||
| 2 | CHRIS | PATEL | ||||||
| 3 | mark | PATEL | ||||||
| 4 | grace | WARD | ||||||
| 5 | olivia | jensen | ||||||
| 6 | PAUL | NOVAK | ||||||
| 7 | chris | REED | ||||||
| 8 | maria | walsh | ||||||
| 9 | elena | GARCIA | ||||||
| 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