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 F3, 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 G3, 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 H3, 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 I3, 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 J3, which can be copied down the column, to determine (TRUE/FALSE) if the
corresponding applicant is waitlisted.
6. Write a formula in cell K3, which can be copied down the column, to determine (TRUE/FALSE) if the
corresponding applicant is rejected.
7. Write a formula in cell G16 to determine (TRUE/FALSE) if all applicants have valid information.
8. Write a formula in cell G17 to determine (TRUE/FALSE) if at least one applicant has invalid information.
9. Write a formula in cell G18 to determine (TRUE/FALSE) if at least 2 applicants have been accepted.
10. Write a formula in cell G19 to determine (TRUE/FALSE) if none of the applicants were waitlisted.
11. Write a formula in cell G20 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