11. Create and copy a SUMIF function to calculate total revenue by boat make. a. Select cell E27 b. Start the SUMIF function with cells $C$5:$C$19 as the Range. c. Set the Criteria argument to ben'. d. Set the Sum_range argument to cells $E$5:$E$19. e. Copy the formula in cell E27 to cells E28:E30. f. Edit the criteria in each copied formula in cells E28:E30 as needed. 12. Complete formatting. a. Apply the Currency format to all values that represent money. b. Format the labels in cells A1:A2 as 18 point. c. Select cells A1:F2 and click the Alignment launcher [Home tab, Alignment group] Center the labels across the selection. d. Merge and center the label in cell C25 over cells C25:E25 and format it at 16 points. Bold and center the labels in rows 4 and 26. f. Select cells A4:F19 and apply All Borders. Do the same for cells C25:E30. g. Center the page horizontally. e. 1 E F D C H G A B San Diego Sailing Bookings Revenue per Passenger #of Total Passengers Fees 4 6 6 an 4 + 3 Date Boat ID Make and Model 4/5/20 1010 Catalina Wave 6 4/8/20 1015 Catalina Sky 7 4/11/20 1146 Hunter Ray 8 4/14/20 1150 Capri MKZ 9 4/17/20 1152 Capri 22 Mk 11 10 4/20/20 1164 Capri 22 Mk 11 11 4/23/20 1168 Hunter 33 12 4/26/20 1175 Beneteau 40 13 4/29/20 1180 Beneteau 373 14 5/2/20 1185 Hunter Sea 15 5/5/20 1190 Beneteau 373 16 5/8/20 1200 Beneteau 373 17 5/11/20 1205 Beneteau 40 18 5/14/20 1225 Hunter Sea 19 5/17/20 1230 Catalina Wave 20 21 22 23 24 Revenue per Passenger 525 131.25 850 141.6666667 500 83.33333333 525 87.5 325 81.25 475 158.3333333 725 120.8333333 850 85 350 43.75 650 81.25 62.5 725 90.625 850 70.83333333 725 90.625 675 112.5 6 10 8 8 625 10 8 12 8 6 25 Bookings by Make Count Total Revenue 5 0 5 Beneteau Capri Catalina Hunter 5 5 26 27 28 29 30 31 32 33 34 35 36 22