This year, sam, jo, andi and loren won 1st, 2nd, 3rd and 4th place, respectively, in the annual scholarship competition. the first place winner will receive the scholarship over 4 years, the second place winner will receive the prize over 3 years, the third place winner will receive the scholarship over 2 years, and the fourth place winner will receive the scholarship as a single lump sum. (data: you will often see data included in this first tab: vou will need to use this data to complete the total prize1st place 30,0002nd place 20,000 3rd place 10,000 4th place 2,500 (requirements: this is where you wil see what you need to do to complete the problem. for the pu through how to complete this problem, including providing instruction on certain excel skills.) requirment (1) enter the information in the yearly prize payout table to determine the total amount of money the make sure to use cell references, formulas and functions where appropriate.) [14 points for example: a) in cell b4, type then on the data tab, click on cell b7 to create a cell reference; next over 4 years, and then click enter . make sure to use the rank. eq function to fill out ranks column.