The Excel data file Credit Risk Data provides information about $425$ bank customers who had applied for loans. The data include the purpose of the loan, checking and savings account balances, number of months as a customer of the bank, months employed, gender, marital status, age, housing status, number of years at current residence, job type, and credit$-$risk classification by the bank.

Open data file Credit Risk Data, and use $=$COUNTIF$()$ or $=$COUNTIFS$()$ function to determine the answers of the follows $($show the results as well as Excel functions$/$parameters you used$)$:

$($a$)$ How many customers applied for New Car loan?

Your answer: $\_\_\_\_\_\_\_\_\_\_\_$; Function and parameters you used: $\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_.$

$($b$)$ How many customers applied for Used Car loan?

Your answer: $\_\_\_\_\_\_\_\_\_\_\_$; Function and parameters you used: $\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_.$

$($c$)$ How many customers applied for Small$-$appliance loan?

Your answer: $\_\_\_\_\_\_\_\_\_\_\_$; Function and parameters you used: $\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_.$

$($d$)$ How many customers applied for Furniture loan?

Your answer: $\_\_\_\_\_\_\_\_\_\_\_$; Function and parameters you used: $\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_.$

$($e$)$ How many customers had checking account balance less than $$500?$

Your answer: $\_\_\_\_\_\_\_\_\_\_\_$; Function and parameters you used: $\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_.$