In order to find the missing data values, create a heat map in Excel that shades the empty cells a different color. Use Excel's Conditional Formatting function to

create this heat map and answer the following questions.

Hint: Click on Conditional Formatting in the Styles group in the Home tab. Select Highlight Cells Rules and click More Rules.... Then enter Blanks in the

Format only cells with: box. Choose a format for these blank cells that will make them obviously stand out.

Click on the datafile logo to reference the data.

DATA $\sqrt[\phantom{2}]{f}$ile

For each question, which respondents did not provide answers? Choose the correct list below.

$($i$)$

$($ii$)$

$($iv$)$