solve the questions by using Microsoft Excel.

4. Create the following table and solve questions a-d (4 marks) Hourly Pay $ 5.00 000 UN 7 Employee Name Total Hours Total Wages 8 Mohamed 45 9 Talal 10 Saeed 25 11 Hassan 66 12 Ali 74 13 Waleed 69 14 Abdalla 70 15 Monthly Wages 16 17 a) Use absolute reference to calculate the total wages (C8:C14). b) Calculate the monthly wages in C16. c) Create 3 scenarios as follows: Hourly Pay 10 Scenario Name High Medium Low 1 d) Show the scenario summary