9. Answer the following questions. The dean has asked you to report to him how the applicant pool compares with last years applicant pool. To do this they have asked you to compare the average the SATII scores of this years applicants and compare to last years, which was 610. If the average of the SATII scores this year was higher, display higher, if the average of the SATII this year is the same as last year, display same, if it was lower, display lower. Write your formula in cell B19 as described here: Use an IF function to solve this using the following logic diagram

10. The faculty is thinking of offering a scholarship to students with excellent SAT scores. If a students Math and Verbal SAT scores (combined) is above 1300 they will be considered a scholarship candidate. Write an Excel formula to determine if this student is a "scholarship candidate". If the student is not a candidate display "no scholarship". Place your formula in cell P4 and copy it down the column.