Cells Task/problem Example Excel Functions/features to you should use QI D4F11 Determine expense budget: Frank's Job role is You must use "Executive officer VLOOKUP and The Staff table includes an Employeeld, Name and Job (Exon", which other functions we Role details. It also has empty cells for an Expense matches with "E0" have covered in the budget for staff for the years 2021 2022 and 2023 in the Expense tutorials (D4:F11). budget table. Define H2K11 as a The Expense budget table includes an Employee ID Therefore, his 2021 Named Range (Emp_ID) in column H. The Emp_ID corresponds with budget is $15,000, called the last part of the Job role text in column C. For his 2022 budget is "Expense_budget" instance, Frank's job role ends with the characters $20,000, and his and use this in your (Exon). The E and the combine match with the 2023 budget is VLOOKUP EMP_ID ("EO"). $25,000 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 D4FIT Staff table Expense budget 2021 2022 2023 A 1 2 3 Employeeld 4 123A 5 1238 6 123C 7 1230 8 123E 9 1207 10 123G al 123H 12 13 Name Job role Frank Exective officer (Exof) Kraemer Administration assistant (AdAs) Jack Research manager (Rema) Cersi Head of division (HeDI) Accounts manager (AcMa) Ruilin Team lead (Tele) Project manager (PMO) Stellios Finance officer (10) Emp ID EO AA RM AM HD Expense budget 2021 2022 2023 S 15,000 $20,000 $ 25,000.00 $ 3,000 $5,000 $ 7,000.00 $ 3,000 $10,000 $ 120,000.00 $ 8,000 $10,000 $ 120,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 Ken PM TL FO Cells Task/problem Example Excel Functions/features to you should use QI D4F11 Determine expense budget: Frank's Job role is You must use "Executive officer VLOOKUP and The Staff table includes an Employeeld, Name and Job (Exon", which other functions we Role details. It also has empty cells for an Expense matches with "E0" have covered in the budget for staff for the years 2021 2022 and 2023 in the Expense tutorials (D4:F11). budget table. Define H2K11 as a The Expense budget table includes an Employee ID Therefore, his 2021 Named Range (Emp_ID) in column H. The Emp_ID corresponds with budget is $15,000, called the last part of the Job role text in column C. For his 2022 budget is "Expense_budget" instance, Frank's job role ends with the characters $20,000, and his and use this in your (Exon). The E and the combine match with the 2023 budget is VLOOKUP EMP_ID ("EO"). $25,000 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 D4FIT Staff table Expense budget 2021 2022 2023 A 1 2 3 Employeeld 4 123A 5 1238 6 123C 7 1230 8 123E 9 1207 10 123G al 123H 12 13 Name Job role Frank Exective officer (Exof) Kraemer Administration assistant (AdAs) Jack Research manager (Rema) Cersi Head of division (HeDI) Accounts manager (AcMa) Ruilin Team lead (Tele) Project manager (PMO) Stellios Finance officer (10) Emp ID EO AA RM AM HD Expense budget 2021 2022 2023 S 15,000 $20,000 $ 25,000.00 $ 3,000 $5,000 $ 7,000.00 $ 3,000 $10,000 $ 120,000.00 $ 8,000 $10,000 $ 120,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 Ken PM TL FO
