Test Your Microsoft Excel Skill Level – Case Study 5

A company rolled out an employee engagement initiative program. They collected the feedback from the employees. Feedback scale ranges from a to z. Have a look at the below screenshot to understand how the data is captured in the feedback excel report.

We need to find the lowest, highest and average rating provided by each candidate. This must be solved without creating any extra column or table.

Download the excel file by clicking here

You can post your solution in the comments section

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.