Solving the Problem

NOTE: Do not use IF functions in any of these formulas. However, you can use CountIF$($s$),$ SumIF$($s$)$ or

AverageIF$($s$),$ if appropriate. Also, do not add any new columns or rows to answer questions not

asked in this project. Answer precisely the question we have asked for each respective cell$($s$)$

indicated.

$1.$ Write a Formula in cell F$3,$ which can be copied down the column to determine $($TRUE$/$FALSE$)$ if the any of

the corresponding applicant$$s information is invalid.

$2.$ Write a Formula in cell G$3,$ which can be copied down the column to determine $($TRUE$/$FALSE$)$ if the

corresponding applicant$$s EBRW SAT score is above the national average EBRW score and the applicant$$s

math SAT score is above the national average math score and the applicant$$s information is not invalid.

$3.$ Write a formula in cell H$3,$ which can be copied down the column, to determine $($TRUE$/$FALSE$)$ if the

corresponding applicant$$s composite score is within $20\%($higher or lower$)$ of the national average

composite score.

$4.$ Write a formula in cell I$3,$ which can be copied down the column, to determine $($TRUE$/$FALSE$)$ if the

corresponding applicant will be accepted to OSU.

$5.$ Write a formula in Cell J$3,$ which can be copied down the column, to determine $($TRUE$/$FALSE$)$ if the

corresponding applicant is waitlisted.

$6.$ Write a formula in cell K$3,$ which can be copied down the column, to determine $($TRUE$/$FALSE$)$ if the

corresponding applicant is rejected.

$7.$ Write a formula in cell G$16$ to determine $($TRUE$/$FALSE$)$ if all applicants have valid information.

$8.$ Write a formula in cell G$17$ to determine $($TRUE$/$FALSE$)$ if at least one applicant has invalid information.

$9.$ Write a formula in cell G$18$ to determine $($TRUE$/$FALSE$)$ if at least $2$ applicants have been accepted.

$10.$ Write a formula in cell G$19$ to determine $($TRUE$/$FALSE$)$ if none of the applicants were waitlisted.

$11.$ Write a formula in cell G$20$ to determine $($TRUE$/$FALSE$)$ if only Lundgren was accepted. This formula does not

need to automatically determine which student is Lundgren and which are not