Go to the Policy Analysis worksheet, which compiles data about the clients that Yuki

handles, including businesses and individuals from the entire state of Oregon. Calculate

the number of years a client has been with Youngwood Insurance as follows:

a$.$ In cell E$6,$ enter a formula without using a function that subtracts the start date for

the client $($cell D$6)$ from the current date $($cell C$3)$ and divides the result by

$365\mathrm{.}25,$ the number of days in a year, accounting for leap year. Use an absolute

reference to cell C$3$ in the formula.

b$.$ Display the value in cell E$6$ with one decimal place.

c$.$ Fill the range E$7$:E$19$ with the formula in cell E$6.$

Youngwood Insurance offers a discount to clients who have been with the company for

at least five years. Determine whether each client qualifies for a discount as follows:

a$.$ In cell H$6,$ enter a formula using the IF function that tests whether the number of

years $($cell E$6)$ is greater than or equal to $5.$ If it is$,$ display $"$Y$"$ in cell H$6.$ If it is

not, display $"$N$"$ in cell H$6.$

b$.$ Fill the range $H7$:$H19$ with the formula in cell $H6.$

Yuki plans to increase coverage amounts for business clients who are now receiving a

discount. Determine whether Yuki should increase the coverage amounts for each client

as follows:

a$.$ In cell I$6,$ enter a formula using the AND function that tests whether the Business

value $($cell F$6)$ is equal to $"$Y$"$ and whether the Discount value $($cell H$6)$ is equal to

$"$Y$".$

b$.$ Fill the range I$7$:I$19$ with the formula in cell I$6.$

Yuki also plans to offer a free inspection to clients in southern Oregon or those who are

bundling all the types of insurance $($abbreviated as "AHL"$).$ Determine whether each

client should receive a free inspection as follows:

a$.$ In cell J$6,$ enter a formula using the OR function that tests whether the region $($cell

C$6)$ is equal to $"$S$"$ or whether the policy type $($cell G$6)$ is equal to "AHL".

b$.$ Fill the range $J7$:$J19$ with the formula in cell $J6.$