9. Create a division formulaa. Click the Bookings sheet tab and select cell F5. Calculate average revenue per passenger by dividing the fee by the number of passengers. b. Build the division formula. c. Copy the formula in cell F5 to cells F6:F19. 10. Create and copy a COUNTIF function to count bookings by boat manufacturer. a. Select cell D27 b. Start the COUNTIF function from the Statistical category by clicking the More Functions button in the Function Library group c. Use cells $C$5:$C$19 as the Range argument. d. Set a Criteria argument that will select all boats in the "Beneteau" group. The criteria is bent. If you type the formula, include quotation marks. e. Copy the formula in cell D27 to cells D28:030. f. Edit the criteria in each copied formula in cells D28:030 to reflect the boat make. 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:30 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. Reset Progress c. Select cells A1:F2 and click the Alignment launcher (Home tab, Alignment group), Ceni the selection d. Merge and center the label in cell C25 over cells C25:E25 and format it at 16 points.