Current Pledges Date: Total pledges: Total amount: 3. In cell F5, insert a formula without using a function that subtracts the pledge date from the current date (B2). 4. Use the Fill Handle to fill the range F6:F17 with the formula in cell F5, filling the range without formatting. 5. In column G, calculate the number of days the pledge is overdue. If the age of the pledge is greater than 21 days, it is overdue. Calculate the days overdue as follows: a. In cell G5, insert a formula using the IF function that tests whether the age of the pledge is greater than 21. b. If the age of the pledge is greater than 21 , subtract the due date (cell E5) from the current date. c. If the age of the pledge is less than or equal to 21 , display 0 meaning the pledge is not overdue. d. Use the Fill Handle to fill the range G6:G17 with the formula in cell G5, filling the range without formatting. 6. Calculate 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 I5, 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 I6:I17 with the formula in cell I5, filling the range without formatting. 7. In cell B19, enter a function that counts the number of pledge IDs. 8. In cell B20, enter a function to total the pledges. 9. Go to the Quarter 3 Gifts worksheet. Apply the Accounting number format to the gift amounts. 10. Calculate the percentage each type of gift contributed to the total amount of gifts. a. Create a formula without using a function that divides the amount of cash gifts by the total amount of gifts. b. Increase the decimal places to two. c. Use the Fill Handle to fill the range C6:C10 with the formula in cell C5. 11. Go to the Formula Documentation worksheet, insert a stacked fraction equation for the Percentage of Total Gifts: Type of Gifts/Total Gifts 12. Save the file and upload to the exam