Please help how do it do it ?

Independent Project 2-5 These instructions are compatible with both Microsoft Windows and Mac operating systems. San Diego Sailing keeps data about its fleet of rental and charter boats. One the sheets is missing a piece of data and another sheet has circular reference errors. You will complete work on these sheets, calculate projected rates for each boat, and build basic statistics about past rentals. [Student Learning Outcomes 2.1, 2.2, 2.3, 2.4, 2.5, 2.6, 2.7] File Needed: SanDiegoSailing-02.xlsx (Available from the Start File link.) Completed Project File Name: [your name]-SanDiegoSailing-02.xlsx Skills Covered in This Project Create and copy formulas. Use formula auditing tools. Set mathematical order of operations. Use relative, mixed, and 3D cell references. Use COUNTIF and SUMIF functions. Build an IF formula. Insert the TODAY function. NOTE: If group titles are not visible on your Ribbon in Excel for Mac, click the Excel menu and select Preferences to open the Excel Preferences dialog box. Click the View button and check the Group Titles check box under In Ribbon, Show. Close the Excel Preferences dialog box. 1. Open the San Diego Sailing-02.xlsx workbook. 2. If the workbook opens in Protected View, click the Enable Editing button so you can modify it. 3. The file will be renamed automatically to include your name. Change the project file name if directed to do so by your instructor, and save it. 2. If the workbook opens in Protected View, click the Enable Editing button so you can modify it. 3. The file will be renamed automatically to include your name. Change the project file name if directed to do so by your instructor, and save it. 4. Review a formula. a. Click the New Prices sheet tab and review the Formula bar. b. Click cell D5. The formula begins with 1+D4. 5. Edit and copy a formula with mixed references. a. Edit the formula in cell D5 to show D$4 instead of "D4." The formula should multiply one plus the percentage value in cell D4 by the current rate on the Fleet sheet ($H5). With an absolute reference to row 4 and column H on the Fleet sheet, you can copy the formula down the column (Figure 2-105). 1054"Fleet F C C San Diego Salling 2 New Priest and 10% increases Half-Day Full Day 10% 5% 10% Boat Make and Model Length 5% 1010 Catalina Wave 284"=(1-0$4 1015 Catalina Sky $0.00 Figure 2-105 Mixed reference in the edited formula b. Copy the formula in cell D5 to cells D6:D19 without formatting to preserve the border. c. Select cells D5:D19 and drag the Fill pointer to copy the formulas to cells E5:E19. d. Click cell E6. The formula is adjusted to use the percentage value in cell E4 in place of cell D4. Note also that the reference on the Fleet sheet ($H6) is adjusted to show the correct row. 6. Build a formula with mixed references. a. Click cell F5 and type = (1+ to start the formula. b. O Select cell F4 and make it an absolute reference to the row but not the column. c. Type * for the closing parenthesis and multiplication. b. O Select cell F4 and make it an absolute reference to the row but not the column. c. Type )* for the closing parenthesis and multiplication. d. Click cell 15 on the Fleet sheet, and make the reference absolute for the column but not the row (Figure 2- 106) -1.754 letis e. Copy the formula down column F without formatting to preserve the border. D E 1 San Diego Sailing Rental and Charter Fleet f. Format cells F5:F19 as Currency and then copy cells F5:F19 to cells G5:G19. # Boat Makan Model 51010 Catalina Wave 2013 talia Sky Model Galley Half-Bay Full Day Lugh You Sleep with Steve Male Rat 284 2010 81 $375.00.650.00 2012 $423205728 7. Build an IF function formula. Figure 2-106 Mixed references in the new formula a. Click the Fleet sheet tab and select cell G5. Rental boats with a stove in the galley must seat 8 or more people. b. Create an IF function in which the logical_test argument determines if there are 8 or more seats. c. Use Yes for the value_if_true argument. Use No for the value_if_false argument. (If you type the formula, enclose the text arguments within quotation marks.) d. Copy the formula to cells G6:G19 without formatting and then center the data in column G. 8. Insert the TODAY function in cell B21. Format the date to show the month spelled out, the date, and four digits for the year (January 1, 2020). 9. Create a division formula. a. 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 COUNTIE function from the Statistical category by clicking the More Functions button in the 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. Use cells $C$5:$C$19 as the Range argument. C. d. Set a Criteria argument that will select all boats in the Beneteau" group. The criteria is ben*. 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:D30 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: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. e. O 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. 1. Select cells A4:F19 and apply All Borders. Do the same for cells c25:630. g. Center the page horizontally. 13. Save and close the workbook (Figure 2-107). San Diego Sailing Bookings Revenue per Passenger of Date Boat ID Make anad Model Passengers 4/5/2020 1010 Catalina Wave 4 4/8/20201015 Catalina Sky 4/11/2020 1146 Hunter Ray 6 4/14/2020 1150 Capri MK2 6 4/17/2020 1152 Capri 22 Mil 4 4/20/2020 1154 Capri 22 Mk II 2 4/23/2020 1163 Hunter 33 6 4/26/2020 1175 Beneteau 4D 10 4/29/2020 1180 Beneteau 373 8 52/2020 1185 Hunter Sea 8 5/5/2020 1190 Beneteau 373 10 5/2/2020 1200 Beneteau 373 8 5/12/2020 1205 Deneteau 40 12 5114/2020 1225 Hunter Sea 8 5/17/2020 1230 Catalina Wave 6 Total Revenue per Fees Passenger 552500 5131.25 $850.00 $341.67 $500 DO $83.33 S525.00 $87.50 5325.00 581.25 $475.00 $158.33 $725.00 $220.33 S85000 585.00 $350 DE $43.75 S650.00 581.25 5625.00 562.50 $725 DD $90.63 $350.00 370.35 5725.00 590.63 $575 DOI $112.50 Dones Capri Catalina Hunter Bookings by Make Total Count Revenue 9 $3400.00 3 $1,325.00 al $2,050.DO 4 $2,500.00 San Diego Sailing Rental and Charter Fleet Sango Salling New Prices 10 Increme Half Day Full Day 4 Model Half Day Length Year Seats Seeps with love Rate 204 2010 Yes $375.00 2012 5425.00 '6" 2014 10 6 $350.00 24's 2011 6 No $325.00 2016 No $325.00 24'8" 2016 5 - NO $325.00 20 10 5425.00 3910201121 6 $489.00 3611 2017 10 6V 6 $369.00 35' 2009 sol 10 6 5349.00 $ 3611 2017 10 6 $369 Bont D Make and Model 2010 Catalina Wave 2015 Can Sky 1146 Hunter 1150 Capri MKZ 1152 Carl 22 M 1184 Capri 22 Mika 2160 Hunters 1175 Beneteau 40 1180 Beneteau 373 1185 Hunter ses 1190 Denetesu 373 4 Rul Day Rate 3000.00 $725.00 $900.00 $900.00 $500.00 $900.00 $725.00 $750.00 $725.00 $550.00 $825.00 Bantin Make and Model 1010 Catalina Wave 1015 Catalina Sky 1146 Hunter Ray 1150 Caori MKZ 1152 Capri 22 M 1164 Caori 22 MR 1168 Hunter 20 23 1179 Beneteau 10 1180 Beneteau 373 1185 Hunter See 1190 Beneteau 373 1200 Beneteau 373 Length 260 2847 361 26 208 208 2016 3910 30'11" 361 35'11" a5'11" $393.75 $446.25 $36750 $541.25 $34125 $341.25 $44625 $513.45 $38745 $366.45 $38745 $347.45 $412.50 9467.50 $385.00 $357.50 $957.50 5357.50 $467.50 5537.00 $405.90 $383.90 $405.90 $40.90 $682.30 $781.25 $325.00 $325.00 $325.00 $325.00 9761.25 $187.50 $761.25 $577.50 $656.25 S655.25 BOK $715.00 573750 $350.00 $350.00 $50.00 $350.00 $79750 5823.00 579750 9605.00 568750 968750 6 Dones Cri Catalina Hunter Bookings by Make Total Count Revenue 3 $3,400.Dol 3 $1,325.00 a $2,050.00 4 $2,500.00 San Diego Sailing Rental and Charter Fleet San Diego Salling New Prices and 10% Incremes Half Day Full Day Length 260 356 240 208 248 Bon D Naked Model 2010 Cina Wave 2015 Catalina Sky 3146 Hunter 1150 Capri MKZ 1152 22 MB 1164 22 M Col22 1160 Hunter 35 1175 Beneteau 40 1180 Deneteau 573 1185 Hunter ses 1190 Denete u 375 1200 Deneteau 573 1205 Denete o 40 Hunters 1330 Cina Wave Model Half Day Length Year Seats Sees with Stove Rate 204 2010 o 6 5375 00 Yes $425.00 s'' 20341 10 6 $350.00 249 ol 4 No $325.00 241 2018 4 No $325.00 24 2018 6 Ne $325.00 2015 10 6 Yes $425.00 3910 2019 12 6 Yes 5489.00 3611 201710 6 Yes $369.00! 35'5 2009/10 6 61 $349.00 3611 2017110 ol $369.00 3611 6 ol To $309.00 3910 2016121 2008 ol 0 Yes 5409.00 2012 10 e $340.00 204 2010 ol $490.0 Rul Day Rate 5000.00 $725.00 $900.00 $500.00 $800.00 $500 GB $725.00 $750.00 $725.00 $550.00 5625.00 5625.00 $23000 5725.00 $675.00 lotin Make and Model 1010 Catalina Wave 1015 Catalina Sky 1146 Hunter Ray 1150 Caori MKZ 1152 Gagri 2 Mk 1164 Cr 2 Ma | 1168 Hunter 33 1175 Beneteau 40 1180 Beneteau 373 1185 Hunter ses 1190 Beneteau 373 1200 Beneteau 373 1205 Beneteau 40 1225 Hunter Sea 1230 Catalina Wave tok $412.50 5467.50 $385.00 $357.50 $357.52 $357.50 $467.50 $537.90 $405.90 $383.90 5405.90 $405.90 $537.90 $383.90 $482.90 $393.73 $446.25 $36750 $34125 $3.41.25 $34125 $146.25 $513.45 $387 49 $366.45 538745 $38745 $513.45 $346.43 $ $460.95 3910 3511 356 35'11" 3511 29'10 350 200 S182.50 $781.25 $325.00 $325.00 $325.00 $325.00 $761.25 $187.50 $761.25 $577.50 $ $656.25 $655.25 $187.50 $761.25 $ $701.15 $715.00 $79730 $350.00 $350.00 $50.00 $350.00 $ $79750 23.00 579750 S605.00 568730 $60750 Sa 25.00 579750 5702 50 2017 10 ury 1.2020 Figure 2-107 Excel 2-5 completed 14. Upload and save your project file. 15. Submit project for grading. File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do PROTECTED VIEW Be carefulfiles from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing A1 X fir San Diego Sailing B D E F G H I J K L M 1 San Diego Sailing Rental and Charter Fleet 2 3 Full Day 4 Rate 5 6 7 8 9 10 11 12 Boat ID Make and Model 1010 Catalina Wave 1015 Catalina Sky 1146 Hunter Ray 1150 Capri MKZ 1152 Capri 22 Mk II 1164 Capri 22 Mk II 1168 Hunter 33 1175 Beneteau 40 1180 Beneteau 373 1185 Hunter Sea 1190 Beneteau 373 1200 Beneteau 373 1205 Beneteau 40 1225 Hunter Sea 1230 Catalina Wave Model Galley Length Year Seats Sleeps with Stove 28'4" 2010 8 6 28'4" 2012 8 6 336" 2014 10 6 24'8" 2011 6 4 24'8" 2016 6 4 24'8" 2016 6 4 33'6" 2018 10 6 39'10" 2018 12 6 36'11" 2017 10 6 35'6' 2009 10 6 36'11" 2017 10 6 36'11" 2017 10 6 39'10" 2018 12 6 35'6" 2012 10 6 28'4" 2019 8 6 Half-Day Rate $375.00 $425.00 $350.00 $325.00 $325.00 $325.00 $425.00 $489.00 $369.00 $349.00 $369.00 $369.00 $489.00 $349.00 $439.00 $650.00 $725.00 $500.00 $500.00 $500.00 $500.00 $725.00 $750.00 $725.00 $550.00 $625.00 $625.00 $750.00 $725.00 $675.00 13 14 15 16 17 18 19 20 21 22 23 24 Independent Project 2-5 These instructions are compatible with both Microsoft Windows and Mac operating systems. San Diego Sailing keeps data about its fleet of rental and charter boats. One the sheets is missing a piece of data and another sheet has circular reference errors. You will complete work on these sheets, calculate projected rates for each boat, and build basic statistics about past rentals. [Student Learning Outcomes 2.1, 2.2, 2.3, 2.4, 2.5, 2.6, 2.7] File Needed: SanDiegoSailing-02.xlsx (Available from the Start File link.) Completed Project File Name: [your name]-SanDiegoSailing-02.xlsx Skills Covered in This Project Create and copy formulas. Use formula auditing tools. Set mathematical order of operations. Use relative, mixed, and 3D cell references. Use COUNTIF and SUMIF functions. Build an IF formula. Insert the TODAY function. NOTE: If group titles are not visible on your Ribbon in Excel for Mac, click the Excel menu and select Preferences to open the Excel Preferences dialog box. Click the View button and check the Group Titles check box under In Ribbon, Show. Close the Excel Preferences dialog box. 1. Open the San Diego Sailing-02.xlsx workbook. 2. If the workbook opens in Protected View, click the Enable Editing button so you can modify it. 3. The file will be renamed automatically to include your name. Change the project file name if directed to do so by your instructor, and save it. 2. If the workbook opens in Protected View, click the Enable Editing button so you can modify it. 3. The file will be renamed automatically to include your name. Change the project file name if directed to do so by your instructor, and save it. 4. Review a formula. a. Click the New Prices sheet tab and review the Formula bar. b. Click cell D5. The formula begins with 1+D4. 5. Edit and copy a formula with mixed references. a. Edit the formula in cell D5 to show D$4 instead of "D4." The formula should multiply one plus the percentage value in cell D4 by the current rate on the Fleet sheet ($H5). With an absolute reference to row 4 and column H on the Fleet sheet, you can copy the formula down the column (Figure 2-105). 1054"Fleet F C C San Diego Salling 2 New Priest and 10% increases Half-Day Full Day 10% 5% 10% Boat Make and Model Length 5% 1010 Catalina Wave 284"=(1-0$4 1015 Catalina Sky $0.00 Figure 2-105 Mixed reference in the edited formula b. Copy the formula in cell D5 to cells D6:D19 without formatting to preserve the border. c. Select cells D5:D19 and drag the Fill pointer to copy the formulas to cells E5:E19. d. Click cell E6. The formula is adjusted to use the percentage value in cell E4 in place of cell D4. Note also that the reference on the Fleet sheet ($H6) is adjusted to show the correct row. 6. Build a formula with mixed references. a. Click cell F5 and type = (1+ to start the formula. b. O Select cell F4 and make it an absolute reference to the row but not the column. c. Type * for the closing parenthesis and multiplication. b. O Select cell F4 and make it an absolute reference to the row but not the column. c. Type )* for the closing parenthesis and multiplication. d. Click cell 15 on the Fleet sheet, and make the reference absolute for the column but not the row (Figure 2- 106) -1.754 letis e. Copy the formula down column F without formatting to preserve the border. D E 1 San Diego Sailing Rental and Charter Fleet f. Format cells F5:F19 as Currency and then copy cells F5:F19 to cells G5:G19. # Boat Makan Model 51010 Catalina Wave 2013 talia Sky Model Galley Half-Bay Full Day Lugh You Sleep with Steve Male Rat 284 2010 81 $375.00.650.00 2012 $423205728 7. Build an IF function formula. Figure 2-106 Mixed references in the new formula a. Click the Fleet sheet tab and select cell G5. Rental boats with a stove in the galley must seat 8 or more people. b. Create an IF function in which the logical_test argument determines if there are 8 or more seats. c. Use Yes for the value_if_true argument. Use No for the value_if_false argument. (If you type the formula, enclose the text arguments within quotation marks.) d. Copy the formula to cells G6:G19 without formatting and then center the data in column G. 8. Insert the TODAY function in cell B21. Format the date to show the month spelled out, the date, and four digits for the year (January 1, 2020). 9. Create a division formula. a. 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 COUNTIE function from the Statistical category by clicking the More Functions button in the 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. Use cells $C$5:$C$19 as the Range argument. C. d. Set a Criteria argument that will select all boats in the Beneteau" group. The criteria is ben*. 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:D30 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: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. e. O 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. 1. Select cells A4:F19 and apply All Borders. Do the same for cells c25:630. g. Center the page horizontally. 13. Save and close the workbook (Figure 2-107). San Diego Sailing Bookings Revenue per Passenger of Date Boat ID Make anad Model Passengers 4/5/2020 1010 Catalina Wave 4 4/8/20201015 Catalina Sky 4/11/2020 1146 Hunter Ray 6 4/14/2020 1150 Capri MK2 6 4/17/2020 1152 Capri 22 Mil 4 4/20/2020 1154 Capri 22 Mk II 2 4/23/2020 1163 Hunter 33 6 4/26/2020 1175 Beneteau 4D 10 4/29/2020 1180 Beneteau 373 8 52/2020 1185 Hunter Sea 8 5/5/2020 1190 Beneteau 373 10 5/2/2020 1200 Beneteau 373 8 5/12/2020 1205 Deneteau 40 12 5114/2020 1225 Hunter Sea 8 5/17/2020 1230 Catalina Wave 6 Total Revenue per Fees Passenger 552500 5131.25 $850.00 $341.67 $500 DO $83.33 S525.00 $87.50 5325.00 581.25 $475.00 $158.33 $725.00 $220.33 S85000 585.00 $350 DE $43.75 S650.00 581.25 5625.00 562.50 $725 DD $90.63 $350.00 370.35 5725.00 590.63 $575 DOI $112.50 Dones Capri Catalina Hunter Bookings by Make Total Count Revenue 9 $3400.00 3 $1,325.00 al $2,050.DO 4 $2,500.00 San Diego Sailing Rental and Charter Fleet Sango Salling New Prices 10 Increme Half Day Full Day 4 Model Half Day Length Year Seats Seeps with love Rate 204 2010 Yes $375.00 2012 5425.00 '6" 2014 10 6 $350.00 24's 2011 6 No $325.00 2016 No $325.00 24'8" 2016 5 - NO $325.00 20 10 5425.00 3910201121 6 $489.00 3611 2017 10 6V 6 $369.00 35' 2009 sol 10 6 5349.00 $ 3611 2017 10 6 $369 Bont D Make and Model 2010 Catalina Wave 2015 Can Sky 1146 Hunter 1150 Capri MKZ 1152 Carl 22 M 1184 Capri 22 Mika 2160 Hunters 1175 Beneteau 40 1180 Beneteau 373 1185 Hunter ses 1190 Denetesu 373 4 Rul Day Rate 3000.00 $725.00 $900.00 $900.00 $500.00 $900.00 $725.00 $750.00 $725.00 $550.00 $825.00 Bantin Make and Model 1010 Catalina Wave 1015 Catalina Sky 1146 Hunter Ray 1150 Caori MKZ 1152 Capri 22 M 1164 Caori 22 MR 1168 Hunter 20 23 1179 Beneteau 10 1180 Beneteau 373 1185 Hunter See 1190 Beneteau 373 1200 Beneteau 373 Length 260 2847 361 26 208 208 2016 3910 30'11" 361 35'11" a5'11" $393.75 $446.25 $36750 $541.25 $34125 $341.25 $44625 $513.45 $38745 $366.45 $38745 $347.45 $412.50 9467.50 $385.00 $357.50 $957.50 5357.50 $467.50 5537.00 $405.90 $383.90 $405.90 $40.90 $682.30 $781.25 $325.00 $325.00 $325.00 $325.00 9761.25 $187.50 $761.25 $577.50 $656.25 S655.25 BOK $715.00 573750 $350.00 $350.00 $50.00 $350.00 $79750 5823.00 579750 9605.00 568750 968750 6 Dones Cri Catalina Hunter Bookings by Make Total Count Revenue 3 $3,400.Dol 3 $1,325.00 a $2,050.00 4 $2,500.00 San Diego Sailing Rental and Charter Fleet San Diego Salling New Prices and 10% Incremes Half Day Full Day Length 260 356 240 208 248 Bon D Naked Model 2010 Cina Wave 2015 Catalina Sky 3146 Hunter 1150 Capri MKZ 1152 22 MB 1164 22 M Col22 1160 Hunter 35 1175 Beneteau 40 1180 Deneteau 573 1185 Hunter ses 1190 Denete u 375 1200 Deneteau 573 1205 Denete o 40 Hunters 1330 Cina Wave Model Half Day Length Year Seats Sees with Stove Rate 204 2010 o 6 5375 00 Yes $425.00 s'' 20341 10 6 $350.00 249 ol 4 No $325.00 241 2018 4 No $325.00 24 2018 6 Ne $325.00 2015 10 6 Yes $425.00 3910 2019 12 6 Yes 5489.00 3611 201710 6 Yes $369.00! 35'5 2009/10 6 61 $349.00 3611 2017110 ol $369.00 3611 6 ol To $309.00 3910 2016121 2008 ol 0 Yes 5409.00 2012 10 e $340.00 204 2010 ol $490.0 Rul Day Rate 5000.00 $725.00 $900.00 $500.00 $800.00 $500 GB $725.00 $750.00 $725.00 $550.00 5625.00 5625.00 $23000 5725.00 $675.00 lotin Make and Model 1010 Catalina Wave 1015 Catalina Sky 1146 Hunter Ray 1150 Caori MKZ 1152 Gagri 2 Mk 1164 Cr 2 Ma | 1168 Hunter 33 1175 Beneteau 40 1180 Beneteau 373 1185 Hunter ses 1190 Beneteau 373 1200 Beneteau 373 1205 Beneteau 40 1225 Hunter Sea 1230 Catalina Wave tok $412.50 5467.50 $385.00 $357.50 $357.52 $357.50 $467.50 $537.90 $405.90 $383.90 5405.90 $405.90 $537.90 $383.90 $482.90 $393.73 $446.25 $36750 $34125 $3.41.25 $34125 $146.25 $513.45 $387 49 $366.45 538745 $38745 $513.45 $346.43 $ $460.95 3910 3511 356 35'11" 3511 29'10 350 200 S182.50 $781.25 $325.00 $325.00 $325.00 $325.00 $761.25 $187.50 $761.25 $577.50 $ $656.25 $655.25 $187.50 $761.25 $ $701.15 $715.00 $79730 $350.00 $350.00 $50.00 $350.00 $ $79750 23.00 579750 S605.00 568730 $60750 Sa 25.00 579750 5702 50 2017 10 ury 1.2020 Figure 2-107 Excel 2-5 completed 14. Upload and save your project file. 15. Submit project for grading. File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do PROTECTED VIEW Be carefulfiles from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing A1 X fir San Diego Sailing B D E F G H I J K L M 1 San Diego Sailing Rental and Charter Fleet 2 3 Full Day 4 Rate 5 6 7 8 9 10 11 12 Boat ID Make and Model 1010 Catalina Wave 1015 Catalina Sky 1146 Hunter Ray 1150 Capri MKZ 1152 Capri 22 Mk II 1164 Capri 22 Mk II 1168 Hunter 33 1175 Beneteau 40 1180 Beneteau 373 1185 Hunter Sea 1190 Beneteau 373 1200 Beneteau 373 1205 Beneteau 40 1225 Hunter Sea 1230 Catalina Wave Model Galley Length Year Seats Sleeps with Stove 28'4" 2010 8 6 28'4" 2012 8 6 336" 2014 10 6 24'8" 2011 6 4 24'8" 2016 6 4 24'8" 2016 6 4 33'6" 2018 10 6 39'10" 2018 12 6 36'11" 2017 10 6 35'6' 2009 10 6 36'11" 2017 10 6 36'11" 2017 10 6 39'10" 2018 12 6 35'6" 2012 10 6 28'4" 2019 8 6 Half-Day Rate $375.00 $425.00 $350.00 $325.00 $325.00 $325.00 $425.00 $489.00 $369.00 $349.00 $369.00 $369.00 $489.00 $349.00 $439.00 $650.00 $725.00 $500.00 $500.00 $500.00 $500.00 $725.00 $750.00 $725.00 $550.00 $625.00 $625.00 $750.00 $725.00 $675.00 13 14 15 16 17 18 19 20 21 22 23 24