Copy a formula into a range.
4. 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 G5) is greater than 21 and if the pledge amount (cell D5) 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 15 contains an incorrect formula.
5. 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 D5) 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 D5) 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.
6. 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 K5, insert a formula using the OR function that returns TRUE if the donation level (cell H5)
equals "Gold" or the repeat donor indicator (cell J5) equals "Y".
b. Use the Fill Handle to fill the range K6:K17 with the formula in cell K5, filling the range without
formatting.
X Create a formula using a function.
In the Pledge Tracker worksheet, the formula in cell K5 should contain the OR function.
X Copy a formula into a range.
In the Pledge Tracker worksheet, cell K5 contains an incorrect formula.
7. Jane likes to keep track of the total number of pledges she has received for the university. In cell
