A. Enter a database function to count the total number of admissions with >= threshold scores

B. enter a database function to count the total number of in-state early admissions.

BrandonSessionASMT7 - Excel File Home nsert Draw Page Layout Data Review View HelpTelme Share 3 Defirve Name Tr Use in Formula f Trace Precedents Show Formulas Calculate Now watch: Calculation tecalculate Sheet Error Checking - insert AutoSum Recently Financial Logical Text Date & Lookup & Math &More Name Time Reference- Trig Functions Manager Create from Selection Remove Arows Evaluate Formula Window Options Function Library Defined Names Formula Auditing West Coast University Admissions Office Applications for Fall 2015 Admission Admission Criteria Score Description ts Average SAT Average GPA ounts StandardEarly Admit Early Reject 2000 Threshold admission scores n State early admission 1000 SAT 8 GPA Miscellaneous Standards & Filter 2900 600 11 Threshold Score Multiplier Final Decision GPA Admit Early Reject Early Residence Out State In State In State In State In State Out State In State In State SAT 2300 2300 2300 2245 2200 2200 2124 2321 0.994 0.994 0994 0.992 0.988 0.988 0.986 0.984 Last First 17 Alevy 18 Camgg 19 Ethridge 20 McGarry Bridgette 21 Forys 22 Mathias 23 Brasington 24 Collins 4700 4700 4700 4645 4600 4600 4512 Early Admission Early Admission Early Admission Early Admission Early Admission Early Admission Early Admission Admit Julie No No 4.00 Yes Yes Yes Yes Mary 4.00 4.00 4.00 3.98 3 64 No No No No Adam Cheryl Applicants No 100% 9:12 PM O Type here to search