Question 3 [20 marks] Using the spreadsheet in Figure 1, answer questions (a) to (c) accordingly. a) Calculate the total amount of hours work and salary for Sally Hertz. Write a formula in E12 and F12. [6 Marks] b) Write a formula to calculate Highest salary in B23. [3 Marks] c) Write a formula to calculate Lowest salary in B24. [3 Marks) d) Write a formula to calculate Average salary in B25. [3 Marks) B D F PAYROLL RECORDS JANUARY 2020 1 2 3 Total Hours Worked Salary 4 Employee 5 John Abhot 6 Terry Burke 7 Linda Carlson 8 Krista Carter 9 John Dole 10 James Erickson 11 Fred Gretchen 12 Sally Hertz 13 Melanie Jackson 14 Peter Lorne 15 Mike McDonald 16 Lyle O'Toole 17 Samantha Reimer 18 William Peterson 19 Randy Wilkes 20 Alex Zimmerman 21 22 23 Highest Salary 24 Lowest Salary 25 Average Salary Hours Overtime Hours 36.00 2.00 40.00 2.00 22.00 2.00 25.00 2.00 39.00 2.00 40.00 9.00 39.00 9.00 13.00 9.00 35.00 9.00 40.00 9.00 19.00 9.00 40.00 5.00 25.00 5.00 33.00 5.00 29.00 5.00 40.00 11.00 Pay Rate (/hour) $12.00 $15.00 $12.00 $15.00 $9.00 $12.00 $20.00 $12.00 $12.00 $12.00 $9.00 $15.00 $12.00 $9.00 $15.00 $12.00 Figure 1