• In Cell F9, insert a formula that will tell me how many students scored equally or above the average score. (You will need to enter in the number that you got from B34. Do not use cell reference)
• In Cell F11, insert a formula that will tell me the total funding that will be distributed to the qualified students based on their scores that were equal and above the average score.
• Assume that there was only $98,000 in the escrow account to distribute for scholarships; did they have enough money to distribute to students who met the requirements? Enter your answer "YES" or "NO" in Cell F13.
• In Cell F15, insert a formula that will tell me either how much the account is short by or how much money is left over after distributing the funds to the qualified students. (If you are short, the number should be displayed in a negative format. If you have money left over, the number should be displayed in a positive format).

B C D E F University of Key West Scholarship Assessment and Competency Exam Scores Names Exam Scores Funding Qualifications teve Jobs 54 $7,500 ack Welch 845 $8,000 Danny Wegmans $7,300 Mary Bana 753 $6,800 8 rren Buffet 951 $7,700 9 eff Bezos 546 $6,500 How Many Met the Criteria? 10 Ursula Burns 522 $7,400 11 Itewart Butterfield 584 $6,600 Total Funding For Those Who Met the Criteria 12 bill Gates 987 $6,900 13 im Cook 352 $5,500 YES or NO? 14 Phil Mickleson 125 $7,800 15 Mark Cuban 599 $7,100 How Much Over or Under? 6 ack Dorsey 375 $6,800 17 Tiger Woods 963 $6,300 18 Daniel Ekler 345 $7,200 19 Reed Hastings 365 $6,100 20 Gary Kelly 666 $8,100 21 ohn Mackey 265 $8,500 22 lon Musk 754 $7,700 23 ndra Nooyi 369 $6,900 24 larry Page 325 $7,000 25 heryl Sandberg 444 $8,100 26 Bryson DeChambeau 542 $6,200 27 Meg Whitman 742 $7,800 8 Mark Zuckerberg 626 $2,600 29 Oprah Winfrey 411 $2,000 30 Kenneth Frazier 811 $2,900 31 Debra Lee 522 $2,200 32 28 $181,500 33 34 Average 636.6 35 Mode 845 Median 639.5