please write what the excel functions are for questions 1-3

The Excel worksheet called "Loans" provides various information on loan applicants. Complete the tasks 1-7 using this data. Q1. Use an Excel function to calculate the average of checking account balances for all the female applicants. Q2. Use an Excel function to calculate the total savings account balances of all the single applicants that has been a customer over 20 months. Q3. Out of all the new car loan applicants, what percentage are single