Excel

1. 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:
   1. 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.
   2. 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.
   3. Display the level as "Bronze" for any other pledge amount.
   4. Use the Fill Handle to fill the range H6:H17 with the formula in cell H5, filling the range without formatting.