Type the criteria in Criteria Range $1$:

$>=2900$ in cell L$6$

$$ Early Admission in cell M$6$

h$)$ Enter a database function in cell H$6$ to count the total number of early admissions with $>=$ the threshold score. Use

the range L$5$:M$6$ for the criteria range.

i$)$ Enter a database function cell I$6$ to calculate the average SAT score for early admissions with $>=$ threshold score.

Use the range L$5$:M$6$ for the criteria range.

j$)$ Enter a database function in cell J$6$ to calculate the average GPA for early admissions with $>=$ threshold score. Use

the range L$5$:M$6$ for the criteria range.

k$)$ Type the criteria in Criteria Range $2$:

l$)$ In State in cell L$10$

m$)$ Early Admission in cell M$10$