Best on desktop
The spreadsheet workspace needs more room than this screen offers. Switch to a laptop for the full experience.
You're a communications analyst given three columns of employee data: A (First), B (Last), C (Department). Column E (Target) shows the expected output string — the format your downstream HRIS requires for a directory export.
Inspect column E to derive the rule, then reproduce it in column D:
| Input row | Target output |
|---|---|
| Sarah, Smith, Engineering | S. Smith, Engineering |
| Mark, Johnson, Marketing | M. Johnson, Marketing |
The shape: <First-Initial>. <Last-Name>, <Department> — first initial of the first name, period, space, full last name, comma, space, department.
Your task:
The grader checks column D; column E is your sanity-check.
Graded cells: D3 (Mark / Johnson / Marketing → M. Johnson, Marketing), D8 (Lisa / Wong / Marketing → L. Wong, Marketing), D11 (Robert / Kim / Operations → R. Kim, Operations).