5 Enter a nested IF function inside a main IF function in
10.000 the Final Decision column( in I17). The decision text should be one of the following: Early Admission, Early Rejection, Admit, or Reject. Hint: Two logical tests are based on the Yes / No displayed in the Admit Early and Reject Early columns. For regular admission, a student must have a combined admission score that is 2900or higher. A student is rejected if his or her score is lower than the threshold. Use appropriate references to the cells in the Miscellaneous Standards & Filter range.
6 Copy the formulas down the Admit Early, Reject Early, 12.000
Score, and Final Decision columns.
7 Enter a database function to count the total number of
10.000 admissions with >= threshold scores. Use the criteria in cells K6: L7 in your function.
8 Enter a database function to count the total number of
10.000 in-state early admissions. Use cell references from the Criteria range in your function.