Instructions Open exploring_007_grader_12_Admissions sx and save it as exploring...07 grader_12_Admissions LastFirst In cell E14, enter a date function that calculates the number of days between the initial Deadline (cel E10) and the Date Received for the first student (14) Use m ed and relative references appropriately. Copy the function to the range E15 E68. A negative value indicates the application was after the initial deadline In cell H14 enter a nested logical function to display either Yes or No in the Admit Earty column. The university admits a student early if that student meets both the Earty Admission criteria for the SAT cell B6) and GPA cell 7 That is the student's SAT score must be 2000 or higher, and the GPA must be 3.80 or higher Use relative and m ed references to the cells in the Admission Criteria range. Based on the requirements, the first student, Frank Aaron will not be admitted early In cell 114, enter a nested logical function to display either Yes or No in the Reject Early column. The university rejects a student early if that student has either an SAT score less than 1000 (cell C6) or a GPA below 1.80 (cell C7) Use relative and mixed references to the cells in the Admission Criteria range In cell J14, enter a formula to calculate an applicant's admission score. Apply the multiplier (found in the Miscellaneous Standards & Filter range) to the student's GPA and add that score to the SAT. Frank Aaron's score is 3496 In cell K14, enter nested IF functions inside a main IF function. The final decision text should be one of the following Early Admission, Early Rejection, Admit, or Reject. Mint Two logical tests are based on the Yes/No displayed in the Admit Earty and Reject Early columns For regular admission, a student must have a combined admission score that is 2900 or higher A student is reacted this or her score is lower than the threshold Use a mixed reference to the cell in the Miscellaneous Standards & Filter range Copy the formulas down the Admit Early Reject Early Score and Final Decision columns To paste the formulas, click Paste on the Home tab and click Formulas to copy just the formulas If you use a regular Paste option, the double borders will copy also In cell H6, enter a database function to count the total number of early admissions with >2000 threshold scores. Use the range L5 M6 for the criteria range and J13 for the field In cell 16, enter a database function to calculate the average SAT score for early admissions with the threshold Use the range L5 M6 for the criteria range Instructions In cell enter a database function to calculate the average GPA for early admissions we threshold score. Use the range LSMS for the criteria range incel HT enter a database function to count the total number of in-state early admissions Use the range L9 M10 for the criteria range and C13 for the field In cell 17, enter a database function to calculate the average SAT for early in-state admissions Use the range L9 M10 for the criteria range In cell J7, enter a database function to calculate the average GPA for all in-state early admissions. Use the range L9 M10 for the criteria range T-Mobile Wi-Fi 6:15 PM in cell enter a database function to coate the average SAT for any in state admissions ageLO MO for the criarange 84%E2 SAT incelente a section to calculate the average GPA for all inte at incel a da t ion to adminton Use the range LSM10 for the r the highest score for all incat ange incel 10 enter an INDEX function with ansted MATCH function to identify the last the person who had the highest overscore for instalearly admission The function should dinplay Basic 18 side Page 1 2 des in the middle and the file Create a footer with your name on the mame code on the right side Save and other and the file Grected Tool Point 100 West Coast University Admissions Office Applications for 2018 DI 1111|1llustbushe Elliotshilullistatadalafili ARRAN SER SERIES Instructions Open exploring_007_grader_12_Admissions sx and save it as exploring...07 grader_12_Admissions LastFirst In cell E14, enter a date function that calculates the number of days between the initial Deadline (cel E10) and the Date Received for the first student (14) Use m ed and relative references appropriately. Copy the function to the range E15 E68. A negative value indicates the application was after the initial deadline In cell H14 enter a nested logical function to display either Yes or No in the Admit Earty column. The university admits a student early if that student meets both the Earty Admission criteria for the SAT cell B6) and GPA cell 7 That is the student's SAT score must be 2000 or higher, and the GPA must be 3.80 or higher Use relative and m ed references to the cells in the Admission Criteria range. Based on the requirements, the first student, Frank Aaron will not be admitted early In cell 114, enter a nested logical function to display either Yes or No in the Reject Early column. The university rejects a student early if that student has either an SAT score less than 1000 (cell C6) or a GPA below 1.80 (cell C7) Use relative and mixed references to the cells in the Admission Criteria range In cell J14, enter a formula to calculate an applicant's admission score. Apply the multiplier (found in the Miscellaneous Standards & Filter range) to the student's GPA and add that score to the SAT. Frank Aaron's score is 3496 In cell K14, enter nested IF functions inside a main IF function. The final decision text should be one of the following Early Admission, Early Rejection, Admit, or Reject. Mint Two logical tests are based on the Yes/No displayed in the Admit Earty and Reject Early columns For regular admission, a student must have a combined admission score that is 2900 or higher A student is reacted this or her score is lower than the threshold Use a mixed reference to the cell in the Miscellaneous Standards & Filter range Copy the formulas down the Admit Early Reject Early Score and Final Decision columns To paste the formulas, click Paste on the Home tab and click Formulas to copy just the formulas If you use a regular Paste option, the double borders will copy also In cell H6, enter a database function to count the total number of early admissions with >2000 threshold scores. Use the range L5 M6 for the criteria range and J13 for the field In cell 16, enter a database function to calculate the average SAT score for early admissions with the threshold Use the range L5 M6 for the criteria range Instructions In cell enter a database function to calculate the average GPA for early admissions we threshold score. Use the range LSMS for the criteria range incel HT enter a database function to count the total number of in-state early admissions Use the range L9 M10 for the criteria range and C13 for the field In cell 17, enter a database function to calculate the average SAT for early in-state admissions Use the range L9 M10 for the criteria range In cell J7, enter a database function to calculate the average GPA for all in-state early admissions. Use the range L9 M10 for the criteria range T-Mobile Wi-Fi 6:15 PM in cell enter a database function to coate the average SAT for any in state admissions ageLO MO for the criarange 84%E2 SAT incelente a section to calculate the average GPA for all inte at incel a da t ion to adminton Use the range LSM10 for the r the highest score for all incat ange incel 10 enter an INDEX function with ansted MATCH function to identify the last the person who had the highest overscore for instalearly admission The function should dinplay Basic 18 side Page 1 2 des in the middle and the file Create a footer with your name on the mame code on the right side Save and other and the file Grected Tool Point 100 West Coast University Admissions Office Applications for 2018 DI 1111|1llustbushe Elliotshilullistatadalafili ARRAN SER SERIES