Excel Data Analysis and Formulas Implementation

In cell A1, enter "Number of customers without any mortgages" and calculate the number of customers without any mortgage accounts in cell B1. Hint: You will want to utilize the count command in cell B1. Formula to use =COUNTIF(Sheet1!I:I,0)

In cell A2, enter "Number of customers without any car loans" and calculate the number of customers without any car loans in cell B2. Hint: you will want to utilize the count command in cell B2.
Calculate the percentage of in C2 based on the 50 customers.
In cell A3, enter "Number of customers without any investment accounts" and calculate the number of customers without any investment accounts in cell B3. Hint: you will want to utilize the count command in cell B3.
Calculate the percentage of in C3 based on the 50 customers.
In rows 4 through 6, repeat the previous two items (item 6 and 7) to determine the number of customers without direct deposit, number of customers with a deposit balance greater than $200,000, and number of customers with a deposit balance less than $10,000.
Make sure that you utilize formulas to calculate each number.
Save your work.
The formulas to use:

=COUNTIF(Sheet1!I:I,0)

=COUNTIF(Sheet1!J:J,0)

=COUNTIF(Sheet1!N:N,0)

=COUNTIF(Sheet1!P:P,"No")

=COUNTIF(Sheet1!F:F,">200000")

=COUNTIF(Sheet1!F:F,"<10000")