Question Instruction Marks Done Section A | The following are to be completed in the Labour HR Data sheet: 8 A1-A8 This sheet contains a list of employees at the company followed by a series of 8 0 multiple-choice questions. Some of the questions are general, some refer to the data. Each question has only one correct answer, please indicate the correct answer by changing the corresponding value in column F from FALSE to TRUE. Only change one option for each question or it will be marked wrong. Section B The following questions are to be answered on the Labour Costs Sheet: 15 B1 The labour costs sheet lists all the staff directly involved in making the workbenches. Cell J3 contains the rate at which superannuateon is calculated for all staff. Change the number formatting of J3 to percentage with one decimal place B2 In D4 calculate the Superannuateon for that employee using the salary in C4 and the 1 rate in J3. (Use cell references, do not type in the values as they may change). Copy the formula down to calculate super for the other staff. B3 Column E is too narrow, widen it to be roughly the same width as the columns either side B4 In E4 calculate the Total Salary by adding the Annual Salary to the Super. Copy the formula down to E15 B5 Total salaries are based on a 40hour week and a 52week year. In F4, using this H information and the value in E4, calculate the Hourly Rate for that employee. Copy the formula down to F15. B6 In C17 add up the annual salaries to get the total. Copy the formula across to E17. 37 In J5 calculate the Average Annual Salary (without Super). O B8 In J6 calculate the Average Hourly Rate (the average of values in the Hourly Rate N column) correct to two decimal places. Do not change the formatting but do apply a standard rounding operation. B9 In J7 calculate the Highest Annual Salary . B10 In J8 calculate the Lowest Annual Salary. 1 O B11 In J9 calculate the % Difference between the highest and lowest annual salary. 2 312 Name the following Ranges: N O B4:B15 Product_Line F4:F15 Hourly_Rate