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 .