Eligibility criteria Minimum age 67 Maximum income $45,000 Pension % 66.00% of income less than maximum income Age Pension 18 For this question, you should assume that people are only 19 entitled to receive a pension if they are at least 67 years old 20 and have an income of less than $45,000. If they qualify, the 21 pension will be 66% of the difference between their income 22 and the maximum eligible income of $45,000. 23 (a) Use a logical function in cell E24, copied to E25:E29, to 24 display in these cells how much pension each person can 25 receive (1.5 marks). 26 (b) Use conditional formatting to change the background 27 colour of cells E24:E29 from yellow to green ONLY IF a 28 pension is payable (0.5 mark). 29 30 Name John Bill 68 66 57 Income $52,000 $16,000 $65,000 $23,000 $41,000 $36,000 Ann Chris Sara Jane 68 59 65