Badge Names
Your client is printing conference badges. Privacy policy says badges show the attendee's first name and only the initial of their last name, with a period — so "Ada Lovelace" becomes "Ada L.".
Every name in the list is exactly two words: a first name, one space, a last name. Produce the badge text for each attendee, one row per name, aligned with the input.
The grader swaps in attendee lists of different lengths, so cover the whole OUTPUT range: where the input row is empty, the output row must be empty too.
Work on it
- Make a copy of the template — it becomes your private sheet.
- Solve it however you like — helper columns and extra tabs are fair game. The one rule:
the grader swaps
INPUTfor other datasets, so never put your own content insideINPUT. - Check yourself against the expected sample output shown in your copy (and below).
- Submit below — Share → "anyone with the link, Viewer", paste the link. Your sheet is graded against 2 hidden datasets, so hardcoded answers won't survive.
Sample
Input (Input!B2:B33)
| Name |
| Ada Lovelace |
| Grace Hopper |
| Alan Turing |
| Katherine Johnson |
| Edsger Dijkstra |
| Barbara Liskov |
Expected output (Answer!B3:B33)
| Badge |
|---|
| Ada L. |
| Grace H. |
| Alan T. |
| Katherine J. |
| Edsger D. |
| Barbara L. |