2 Enter a nested logical function in the Admit Early
10.000 column( in F17) to display either Yes or No. The university admits a student early if that student meets both the early admission criteria for the SAT and GPA. That is, the student’ s SAT score must be 2000 or higher, and the GPA must be 3.80 or higher. Use appropriate references to the cells in the Admission Criteria range. Based on the requirements, the first student, Julie Alevy, will be admitted early.
3 Enter a nested logical function in the Reject Early
10.000 column( in G17) to display either Yes or No. The university rejects a student early if that student has either an SAT score less than 1000or a GPA below 1.80. Use appropriate references to the cells in the Admission Criteria range.
4 Enter a formula in the Score column( in H17) to
10.000 calculate an applicant’ s admission score. Apply the multiplier( found in the Miscellaneous Standards & Filter range) to the student’ s GPA and add that score to the SAT. Julie Alevy’ s score is 4700.