A staff list
Exercise 1 of 3
Usernames are the part of the email before the @, in small letters. In G2, make Ana's username from B2.
About this lesson
A staff list with emails, start dates and salaries. Clean up text, work with dates and summarise numbers, each in one formula.
In this lesson
- Usernames are the part of the email before the @, in small letters. In
G2, make Ana's username fromB2. - In
G2, work out how many full years Kai (row 4) had worked by 30 June 2026. - In
G2, show the average salary in the Sales department, rounded to a whole number.
Use the arrow keys to move between cells; each cell is read out as you go. Type a formula and press Enter. The sheet is also available as a table below.
fx
Type in G2 and press Enter to check.