1. Review the provided spreadsheet to ensure the accuracy of the current dats and correct any errors that you identify. Hint: remember that the exam scores are on a 100-point scale and that one employee received a perfect score. 2. Complete the remaining analysis and format the spreadsheet to include the following: 1. Someone made an error when formatting the employees' ID numbers and formatted them with decimals. These should be formatted as Social Security (xxx-xx-xxxx). 2. Calculate the Overall Score for each employee (use a 100-point scale). The Product Knowledge Exam is worth 30% of the overall score and the manag evaluation is worth 70% of the overall score. 3. In the "Evaluation" column, use a VLOOKUP function to identify employees who will be promoted based on their Overall Scores. Use the data found on as your table array when writing the formula. Also, as always, use an absolute reference when necessary. 4. Format the fonts (colors, sizes, and typefaces) to be both professional and visually appealing. 5. Format the rows and columns so that heights and widths are appropriate for the data. 6. Choose a company name and replace "Company Name" in cell A1 with the new name. 7. Add a company logo that will correspond with the organization's name. Ensure that the logo you choose or design is not copyright-protected. 8. Sort the data based on the "Overall Score column: employees who will be recommended for promotion should be shown last. 9. Create a bar chart to show product knowledge exam scores and manager ratings for each employee. Employees should be shown along the x-axis. Th should be on a separate sheet within the file. 10. Identify which employees shall be given promotions. In the "Promoted?" column, write a conditional statement that fills the field with "Yes" if the employ high performer and "No" if the employee is not a high performer. 11. Under the "Recommended for Promotion" section, list the employees who will be given promotions based on their high performance. 12. Use a function or formula to calculate: Average Percentage Salary Increase Total Cost of Raises Total Cost of New Salaries