Enter a formula in cell J13 to obtain the number of A grades for Ernesta. Copy the formula through cell J18 to count number of A grades for the other candidates. Write down the formula used in ce

Here are the solutions to your questions:

4. Enter a formula in cell J13 to obtain the number of A grades for Ernesta. Copy the formula through cell J18 to count number of A grades for the other candidates. Write down the formula used in cell J13.
Assuming Ernesta's grades are in cells C13 through H13, and the grades for other candidates are in subsequent rows (C14:H14, C15:H15, etc.):
The formula in cell J13 is:

$$=\text{COUNTIF(C13:H13, "A")}$$

**5. Deduce the number of B, C, D, E grades for Ernesta. Hence, auto fill