$5.$ Select the Product Development Schedule tab, and then format cells G$7$:G$16$ in English $($United

States$)$ Locale using the date format, March $14,2012.$

$6.$ Populate range F$7$:F$16$ with the expected date for the delivery of the product using the

WORKDAY function.

Hints:

i$.$ The Expected Date of Product Delivery $=$ Development Start Date located in cell C$4+$

Duration. Don$$t forget to include holidays, which are found on the Holidays tab.

ii$.$ Don$$t forget to use absolute references in the formula where necessary.

$3$ of $6$

$7.$ Use cells H$7$:H$16$ to enter the calculation for the number of days that the product is late. The

number of days late is the date delivered minus the expected date.

Hint: A positive number will be days late; a negative number will be delivery before the expected

date $($e$.$g$.,-2$ means the product was delivered two days before its expected delivery date$).$

$8.$ In cells I$7$:I$16,$ using the IFS function, display the status of each developer based on number of

days that the product was delivered after the expected delivery date. Use the Developer Status

Information in cells K$6$:L$10.$

Hints:

i$.$ The order of the conditions is critical to use the IFS function successfully.

ii$.$ Don$$t forget to use absolute references in the formula where necessary.

Task $3$

$9.$ Use the AUTOSUM, MAX, MIN, and AVERAGE functions to calculate the amounts in cells

D$17$:D$20.$

$10.$ Use the VLOOKUP function in column C to retrieve the Developers$$ names $($in the Last name,

Initial. format$)$ corresponding to the Product Code in column B$.$ The Developers$$ names are

found on the Developers tab.

Hint: The Developers$$ names array needs to have absolute references.

Task $4$

$11.$ Use the MEDIAN and MODE.SNGL functions in cells D$23$:D$24$ to determine the median and

mode cost of development for products NP$-$ChA$1$ to NP$-$ChC$2.$

$12.$ Calculate the standard deviation for the Cost of Development using the STDEV.S formula and

enter it into cell D$25.$

$13.$ Calculate the $1$st and $3$rd quartiles using the QUARTILE.INC function and enter them into cells

D$26$:D$27.$

$14.$ Format cells D$17$:D$20$ and D$23$:D$27$ with the Currency format, with two decimals.