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.