1) Classify the checking account status based on the thresholds in cell "M2" and "N2". LOW = Accounts Below value in "M2" HIGH = Accounts Over value in "N2" MED = Accounts between the values in "M2" and "N2"

2) Classify the savings account status based on the thresholds in cell "M2" and "N2". LOW = Accounts Below value in "M2" HIGH = Accounts Over value in "N2" MED = Accounts between the values in "M2" and "N2"

3) Identify a formula-based analysis to find: a) Number of applicants for each type of loan b) Savings account status of customers applying for a new car loan? c) Credit risk of customers applying for a new car loan? d) Average savings balance of customers applying for a small appliance loan?

4) Identify a pivot-table based analysis to find: a) Number of applicants for each type of loan b) Savings account status of customers applying for a new car loan? c) Credit risk of customers applying for a new car loan? d) Average savings balance of customers applying for a small appliance loan?