Copy a tormula into a range.

Jane sends a reminder to donors with pledges that have been overdue for more than $21$ days if the

amount is more than $$800.$ Provide a quick way to identify those donors as follows:

a$.$ In cell $15,$ insert a formula using the AND function that returns TRUE if the number of days overdue

$($cell G$5)$ is greater than $21$ and if the pledge amount $($cell D$5)$ is greater than $800.$

b$.$ Use the Fill Handle to fill the range $16$:$117$ with the formula in cell $15,$ filling the range without

formatting.

$x$ Create a formula using a function.

In the Pledge Tracker worksheet, the formula in cell $15$ should contain the AND function.

X Copy a formula into a range.

In the Pledge Tracker worksheet, cell I$5$ contains an incorrect formula.

Cortona University assigns each donation to a level of Gold, Silver, or Bronze depending on the

pledge amount. Display the donation level using a nested IF function as follows:

a$.$ In cell $H5,$ insert a formula using an IF function. The first condition tests whether the pledge amount

$($cell D$5)$ is greater than or equal to $5000$ and displays the level as "Gold" if the condition is true.

b$.$ The next condition uses another IF function to test whether the pledge amount $($cell D$5)$ is greater

than or equal to $2000$ and displays the level as "Silver" if the condition is true.

c$.$ Display the level as "Bronze" for any other pledge amount.

d$.$ Use the Fill Handle to fill the range $H6$:$H17$ with the formula in cell $H5,$ filling the range without

formattina.

Create a formula using a function.

$$ Copy a formula into a range.

Donors receive a premium as a token of appreciation if their donation is at the "Gold" level or they

are repeat donors. Provide this information for Jane as follows:

a$.$ In cell K$5,$ insert a formula using the OR function that returns TRUE if the donation level $($cell H$5)$

equals "Gold" or the repeat donor indicator $($cell J$5)$ equals $"$Y$".$

b$.$ Use the Fill Handle to fill the range $K6$:$K17$ with the formula in cell $K,$ filling the range without

formatting.

$x$ Create a formula using a function.

In the Pledge Tracker worksheet, the formula in cell K$5$ should contain the OR function.

X Copy a formula into a range.

In the Pledge Tracker worksheet, cell K$5$ contains an incorrect formula.

Jane likes to keep track of the total number of pledges she has received for the university. In cell