Please answer using the following template:

Please show answers to the table as well as the formulas used thank you.

Task 3 (Worksheet 3 and Worksheet 4). 2 questions (5 marks) Important: This second part of this question pertains to TWO worksheets named Task 3 and Report. Your staff members are evaluated yearly on six dimensions of their performance: quality, quantity, knowledge, initiative, reliability, and adaptability. Each of these dimensions is rated by the employee's supervisor and recorded in the table on the Task 3 worksheet. The weighted score column (K) will contain your formula to calculate an overall score for each employee based on their performance and appropriate weightings given in the weighting table, as per instructions below. Cells Task/problem Example Functions/features you should Q1 K4:K23 in the Task 3 worksheet Write a formula to calculate a weighted score for employee 1097, Dorian. 3 marks The score is the sum of the six dimensions (columns E:)) which are each multiplied by the corresponding weighting in the dimension weightings table (columns M:0) e.g. quality score Dorian joined in 2017, therefore we take his weightings from the Column O in the Dimension Weightings table. After using the correct weightings in the weightings formula, Dorian's weighted score of 70.5% should be displayed in K4. You should use YEARFRAC and TODAY. We have not used these in our tutorials, but you should be able to learn new functions. You should also use (E4) x quality weighting + quantity score (F4) Xquantity weighting, etc. Convert the number to a percentage by dividing the entire result by 100, then use the percentage format from the ribbon. Format it to one decimal place. Harold joined the firm in functions covered 2022, and therefore we take in tutorials his weightings from the Column N in the Dimension This is a long, Weightings table. Therefore, repetitive formula! Harold's weighted score of 51.0% should be displayed in K15. Be aware that the weighting for new staff (hired less than one year ago) is different to all other staff, so your formula must choose the correct weighting column from the weightings table based on the length of the staff member's employment. Use the relevant statistical functions. Ensure that you appropriately link to the Task 3 worksheet. Copy the formula down the K column for all employees Q2 F13:113 in F13 in the Report worksheet: Write the The lowest quality score in the appropriate formula to determine the the Task 3 worksheet 2 Report lowest score for the quality (E4:E23) is 14. marks worksheet performance dimension amongst all employee records on the Task 3 The average quality score in worksheet. Task 3 worksheet E4:E23 is 61.05. G13 in the Report worksheet: Write the appropriate formula to determine the average score for the quality performance dimension amongst all employee records on the Task 3 worksheet. H13 in the Report worksheet: Write the appropriate formula to determine the median score for the quality performance dimension amongst all employee records on the Task 3 worksheet. 113 in the Report worksheet: Write the appropriate formula to determine the highest score for the quality performance dimension amongst all employee records on the Task 3 worksheet. 36 88 93 43 64 95 94 68 87 35 95 51 44 78 70 70 84 67 93 65 16 41 51 95 61 82 93 93 84 Dimension weightings Dimension New staff Other Quality 10.0% 20.0% Quantity 10.0% 20.0% Knowledge 5.0% 15.0% Adaptability 25.0% 15.0% Initiative 25.0% 15.0% Reliability 25.0% 15.0% 44 55 59 93 100 100 35 87 84 42741 42419 41050 40199 40346 40654 42718 44547 42103 41410 43502 44585 43390 44579 41101 44589 40701 61 73 65 97 61 36 80 1097 Honey 1363 Fan 1395 Jackson 1589 Wang 1849 Jaeger 2136 Farges 2536 Chao 3067 Singer 3297 Min 3393 Smith 3690 Robert 4020 Potter 4062 Walker 4108 Heller 4222 Robertson 4559 Rogany 4588 Senti 4744 Patel 4826 Horton 4900 Power 78 Dorian Helen Simon Li Florian James Xing Tara Stanley John Eunice Harold Karina Julia Daniel Yancey Mario Vanessa Winona Michael 94 43 14 44 45 61 69 100 72 71 87 41 77 65 89 85 90 38 63 47 40 70 98 74 94 70 75 94 60 64 43 61 98 44 35 87 31 90 81 47 68 35 92 61 53 98 76 40 40 72 46 60 70 62 89 40 40 74 59 66 63 44593 41276 41460 23 64 57 85 92 53 51 92 52 59 64 74 38 CHADI DYEE EVALUATION Employeeld Employee 1097 Dorian Honey Dear Dorian, Your performance evaluation has been completed and your weighted score is 0.0%. Six dimensions of your performance were considered, and one dimension, quality, has been listed below, along with information to allow you to compare your performance to that of other staff. Weighting Performance dimension Quality EVALUATION RESULTS: DORIAN HONEY Your score Company-wide scores (out of 100) Rank (out of 1001 Lowest Average Median Highest 78 7th % of staff below your score 0.0% 0.2 Sincerely, Roger Jolly Jones HR Analytics Manager