What is the excel function to answer #4 based on the data? Answer question 5 also if you can please, I will thumbs up! ***YOU DONT NEED THE FILE TO ANSWER THIS, JUST TELL ME WHAT THE EXCEL FUNCTION WOULD BE USING THE COLUMN LABELS.

Q4. What is the average age of the furniture loan applicants who are female, skilled, divorced, homeowners with low credit risk? Q5. Assume that the bank would like to offer a promotion in efforts to retain long standing customers by cash prizes. If a customer has been with the bank for over 36 months the bank will deposit 4% of the customers total cash at the bank (checking + saving) to the customers' checking account. Create new column called "After promotion" which calculates the amount in checking account for each customer after the promotion