9 Enter database functions to calculate the average SAT
12.000 and GPA for all early admits with admissions scores at or above the threshold . Note that you cannot merely average the existing averages because the counts are different for Early Admits and Regular Admits . You can use the database function without performing an advanced filter with an output range ( use cell references from the Criteria range in your function ).
10 Calculate the average GPA for all in-state early admits
10.000
( use cell references from the Criteria range in your function ).
11 Create a footer with your name on the left side , Page 1
6.000 of ? codes in the middle , and the file name code on the right side .
12 Save and close the workbook , and submit the file as 0.000 directed .