The project lead in an MNC decides to assign every member of his team to a new project and monitors their performance on a customized scale of scores. The data on their performance over a period of six months are shown below:

a. Create a heat map in Excel that shades the cells with negative performance scores. Use Excel's Conditional Formatting function to create this heat map.
b. For each month, identify the team member who scored negative? Which month has the highest negative performance scores?

Question

The project lead in an MNC decides to assign every member of his team to a new project and monitors their performance on a customized scale of scores. The data on their performance over a period of six months are shown below:
  
a. Create a heat map in Excel that shades the cells with negative performance scores. Use Excel's Conditional Formatting function to create this heat map.
b. For each month, identify the team member who scored negative? Which month has the highest negative performance scores?

Quizplus · Accepted Answer

The Answer of The project lead in an MNC decides to assign every member of his team to a new project and monitors their performance on a customized scale of scores. The data on their performance over a period of six months are shown below:
  
a. Create a heat map in Excel that shades the cells with negative performance scores. Use Excel's Conditional Formatting function to create this heat map.
b. For each month, identify the team member who scored negative? Which month has the highest negative performance scores?

The Project Lead in an MNC Decides to Assign Every