Worksheet 3, Task 3: 1 question (2 marks) Question Cells G4:09 Task/problem Example Excel Functions/features to you should use Calculate the living allowance David Silver joined the IF, OR, YEAR for staff: firm before 2016 and is VLOOKUP "Senior" so he is Staff are allocated a city living permitted a city living Define the name range allowance if they joined the fim allowance. He is located C15:D20 as before 2016 (column C) OR if in Melbourne (.e. cell "City allowance" and use they hold a "Senior" position E4), so he receives a 10% this in your VLOOKUP (column D). bonus of $18.500. Cell D4 should display $18.500. Calculate the city allowances using the rates specified in the Hugo Chevi joined the "City_allowance table". Where firm in 2019 and is staff do not receive an allowance Junior" and thus is not the text "No living allowance" permitted a living should be displayed." allowance and the text "No living allowance" should be displayed. F H M Salary Living allowance $185.000 #NAME? $120.000 $120,000 $210000 $150,000 $220,000 B C D 1 2 3 First Name Last Name Date Started Position Location 4 David Silver 2014/9/2 Senior Melbourne 5 Harriette Brown 2015/8/11 Junior Singapore 6 Hugo Chevi 2019/11/11 Junior Hong Kong 7 Sally Chan 2020/6/14 Senior New York 8 Tyrion Smith 2020/4/1 Junior New York 9 Jamie Brown 2017/7/1 Senior Sydney 10 11 12 13 City allowance table 14 City City allowance 15 column 1 column 2 16 Hong Kong 15% 17 London 20 18 Melbourne 100 19 New York 20W 20 Singapore 21 Sydney 10 22 23 20N