Please answer 1 and 2! Please show the formula used in excel for each question and the result from the formula!

1) Suppose a saving account with $500 or less is considered low balance. Create a column to show loans with low saving account balance. How many low saving accounts? 2) Suppose a loan with a term shorter than or equal to 2 years is considered short. Create a column to show loans with short term. How many short term loans? 1) Suppose a saving account with $500 or less is considered low balance. Create a column to show loans with low saving account balance. How many low saving accounts? 2) Suppose a loan with a term shorter than or equal to 2 years is considered short. Create a column to show loans with short term. How many short term loans