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 .