Course outline / Job and interview practice
Lesson 75 of 75 · Intermediate · 4 exercises
Interview practice: logic and text
IF decisions and name handling, as asked in job tests.
What you'll practise
- Flag who gets a bonus
- Work out a raise
- First name only
- Build an email address
Flag who gets a bonus
In cell H2, show "Bonus" if Ana (row 2) works in Sales and earns under 45,000, otherwise "None".
Work out a raise
In cell H2, give IT staff a 5% raise and everyone else 3%: show Ben's new salary (row 3) with IF.
First name only
In cell H2, get Dee's first name from B5.
Build an email address
In cell H2, build Ana's email address: her first name in lower case, then "@company.com". Ana's name is in B2.
Try it in a real spreadsheet
Every step checks your answer instantly and tells you exactly what to fix.