The data shows $425$ loan applications. The purpose of the loan and the money on checking and savings accounts of the respective applicants. Question $1$ Use COUNTIF to know the number of applicants per area Question $2$ Use COUNTIF to know the number of applicants with less than or equal to $$0$ on their checking account. Question $3$ Create $1$ new column use IF functions to classify the account as "dangerous" if any of the checking or the savings show less than $$100.$ And "best rate" when none of the $2$ is below $$100$ and checking $+$ savings show more than $$2000.$ Create a small table counting how many "dangerous" and "best rates" you got. County Loan Purpose Checking$$ Savings Monongalia Small Appliance $$0$ $$739$ Monongalia Furniture $$0$ $$1,230$ Wetzel New Car $$0$ $$389$ Marion Furniture $$638$ $$347$ Monongalia Education $$963$ $$4,754$ Monongalia Furniture $$2,827$ $$0$ Marion New Car $$0$ $$229$ Preston Business $$0$ $$533$ Monongalia Small Appliance $$6,509$ $$493$ Monongalia Small Appliance $$966$ $$0$ Monongalia Business $$0$ $$989$ Monongalia New Car $$0$ $$3,305$ Taylor Business $$322$ $$578$ Taylor New Car $$0$ $$821$ Taylor New Car $$396$ $$228$ Preston Used Car $$0$ $$129$ Monongalia Furniture $$652$ $$732$ Monongalia New Car $$708$ $$683$ Monongalia Repairs $$207$ $$0$ Marion Education $$287$ $$12,348$ Marion Furniture $$0$ $$17,545$ Marion Furniture $$101$ $$3,871$ Marion Furniture $$0$ $$0$ Wetzel Furniture $$0$ $$485$ Taylor New Car $$0$ $$10,723$ Taylor Business $$141$ $$245$ Monongalia Used Car $$0$ $$0$ Monongalia Used Car $$2,484$ $$0$ Monongalia Small Appliance $$237$ $$236$ Marion Small Appliance $$0$ $$485$ Marion Education $$335$ $$1,708$ Monongalia Small Appliance $$3,565$ $$0$