MS Excel Assignment Instructions

For this part of the assignment browse through all worksheets before attempting the question.

Using the Microsoft excel workbook assgt$\_$mgmt$1000\_$open$\_$s$2\_24.$xls complete the questions

below to provide solutions for the senior management of Digital Government Inc, regarding their

services:

Using the $$Results$$ worksheet:

a$.$ Provide the relevant formulas to calculate the average age of respondents accessing

services at the company. Please format the values using zero decimal points. $[4]$

b$.$ Determine the average satisfaction level across all respondents using the appropriate

function $[4]$

c$.$ Using the appropriate feature, dynamically apply the following formats to the necessary

rows as follows:

i$.$ Dissatisfied customers, should be red and bolded $[2]$

ii$.$ Highly Satisfied customers, should be green and italicized $[2]$