Cells Task/problem Example Q1 D4:F11 Determine expense budget: Frank's Job role is "Executive officer The Staff table includes an EmployeeID, Name and Job (ExOf)", which Role details. It also has empty cells for an Expense matches with EO budget for staff for the years 2021, 2022 and 2023 in the Expense (D4:F11). budget table. Excel Functions/features to you should use You must use VLOOKUP and other functions we have covered in the tutorials The Expense budget table includes an Employee ID (Emp_ID) in column H. The Emp_ID corresponds with the last part of the Job role text in column C. For instance, Franks job role ends with the characters (ExOf). The E and the O combine match with the EMP_ID (EO"). Therefore, his 2021 budget is $15,000, his 2022 budget is $20,000, and his 2023 budget is $25,000. Define H2:K11 as a Named Range called "Expense_budget" and use this in your VLOOKUP Write a formula that uses the Expense budget table to populate columns D:F with the correct figure. Do this with one formula that is created for D4 and copied to D4:F11. B D E F G H Staff table 1 2 3 Employeeld 4 123A Expense budget 2021 2022 2023 Emp_ID EO 5 AA 6 RM 123B 1230 123D 123E Name Frank Kraemer Jack Cersi Ken Ruilin Stellios 7 Job role Exective officer (ExOf) Administration assistant (AdAs) Research manager (ReMa) Head of division (HeDi) Accounts manager (AcMa) Team lead (Tele) Project manageer (PrMa) Finance officer (FiOf) Expense budget 2021 2022 2023 $ 15,000 $ 20,000 $ 25,000.00 $ 3,000 $ 5,000 $ 7,000.00 $ 8,000 $ 10,000 $ 1,20,000.00 $ 8,000 $ 10,000 $ 1,20,000.00 $ 10,000 $ 15,000 $ 20,000.00 $ 11,000 $ 13,000 $ 15,000.00 $ 7,000 $ 9,000 $ 11,000.00 $ 8,500 $ 10,000 $ 11,500.00 AM 8 HD PM 9 123F 1236 10 11 TL FO 123H 12