What does the correct answer look like using all of the information provided?

Question Cells Task/problem Example Excel Functions/features to you should use IF, OR, YEAR, VLOOKUP 1 G4:G9 Calculate the living allowance for staff: Staff are allocated a city living allowance if they joined the firm before 2016 (column C) OR if they hold a Senior position (column D). David Silver joined the firm before 2016 and is Senior so he is permitted a city living allowance. He is located in Melbourne (i.e., cell E4), so he receives a 10% bonus of $18,500. Cell D4 should display $18,500. Define the name range C15:D20 as City_allowance and use this in your VLOOKUP Calculate the city allowances using the rates specified in the City_allowance table. Where staff do not receive an allowance the text "No living allowance" should be displayed. Hugo Chevi joined the firm in 2019 and is "Junior and thus is not permitted a living allowance and the text "No living allowance" should be displayed. Last Name Silver Brown First Name David Harriette Hugo Sally Tyrion Jamie Chevi Chan Smith Date Started Position 2/9/14 Senior 11/8/15 Junior 11/11/19 Junior 14/6/20 Senior 1/4/20 Junior 1/7/17 Senior Location Melbourne Singapore Hong Kong New York New York Sydney Salary $185,000 $120,000 $120,000 $210,000 $150,000 $220,000 Brown City_allowance table City City allowance Hong Kong 15% London 20% Melbourne 10% New York 20% Singapore 20% Sydney 10%