c. In P12, get the sum of the Salaries for employees with a Hired Date after 12/31/1997. d. In P13, get the sum of the Salaries for employees with a Review Date on or before 7/1/18. e. In P17, get the average Age for employees with a Hired Date before 10/1/2004. f. In P18, get the average Age for employees with a Review Date after 12/31/18. 11. On the Charity sheet, use an inexact type of VLOOKUP to calculate in column K how many tickets each donor will get for the charity ball by looking into the table in N4:08. Copy down the column. 12. On the Charity sheet, nest the VLOOKUP inside an IFERROR function so that if an error occurred in column K, that cell will appear blank instead. Copy down the column. 13. On the Charity sheet, in the Status column, use a nested IF function to display the word "Inactive" when the This Year column is empty, display the word "New" when the Prev. Year column is empty, and display "Active" otherwise. (Hint: An empty cell will equal zero.) 14. On the NameIt sheet, name the table with your last name. 15. On the Nursery GiftList sheet, calculate the Discounted Unit Price in column D. The business formula for discounting a price is UnitPrice minus the UnitPrice multiplied by the Discount. (Hint: Be careful of order of