Worksheet 2, Task 2: 1 question (2 marks) Question Cells Task/problem Example H4:119- Create a new Staff ID: Jose's "Staff ID" is -129300" and so the This table includes staff members with "New Staff II)" must two different formats of Staff ID become N129300X": (column A). Excel Functions/features to you should use IF. LEN. CONCAT (or CONCATENATE) A new format for Staff ID has been set by management Jason's "Staff ID"is "17263" and so the "New Staff ID must become "N17263XX": All Staff IDs must start with "N" and be eight characters long. Using the initial Staff ID (column A) add "to the beginning of the ID, then add "X" or "XX" to the end to ensure the new ID in column H is eight characterse long. A G H 1 New staff ID B D E 1 2 3 Staff ID First name Last name Office location Country 4 129300 Jose Fernandes Melbourne Australia 5 17263 Jason Flint Singapore Australia 6 928330 Melinda Greco Auckland New Zealand 7 18274 Marry Alaves Singapore Singapore 8 918260 Chavwe Osembe Sydney Australia 9 18263 Xiao Fan Singapore Singapore 10 11 12 13 14 Department Position title IT Senior Network Engineer Marketing Team Lead Finance Manager Strategy Manager Prodution Operations Strategy Senior Strategist