The Barren River Yacht Club keeps data about its fleet of rental and charter boats in a workbook. The worksheets have missing pieces of data. You will complete work on these sheets, calculate projected rates for each boat., and build basic statistics about past rentals. This activity is meant to demonstrate what you have learned about spreadsheets this semester. You will only get one attempt at this activity. Please submit your final spreadsheet to the link in your weekly assignment. 1. Open and download the Barren YachtClub workbook. Do a file save as and put your Lastname, firstname in front of Barren YachtClub before saving. The Fleet worksheet contains information about each rental boat and the cost for half-day and full-day rentals. The New Price worksheet needs to have new values for renting the boats. The new values are increased by either 5% and 10% from the original values for hall-day and full-day values found in the Fleet worksheet. 2. Start with the new prices worksheet and review the formula in cell DS. Make any changes necessary and copy the formula for the remaining half-day rentals. (10 pts) 3. Create a new formula for the half-day rentals so that you can just copy the formula down for the 5% and 10% columns. (10 pts) Complete this for both the ball day and full-day rentals. 4. Go to the Fleet worksheet and create an IF function in column G. If the boat has 8 or more seats, then have the cell display "Yes, otherwise it should display "No." The logic is that only boats with eight or more seats can have a stove. (10 pts) 5. Put today's date in cell Kl with a light blue background The Barren River Yacht Club keeps data about its fleet of rental and charter boats in a workbook. The worksheets have missing pieces of data. You will complete work on these sheets, calculate projected rates for each boat., and build basic statistics about past rentals. This activity is meant to demonstrate what you have learned about spreadsheets this semester. You will only get one attempt at this activity. Please submit your final spreadsheet to the link in your weekly assignment. 1. Open and download the Barren YachtClub workbook. Do a file save as and put your Lastname, firstname in front of Barren YachtClub before saving. The Fleet worksheet contains information about each rental boat and the cost for half-day and full-day rentals. The New Price worksheet needs to have new values for renting the boats. The new values are increased by either 5% and 10% from the original values for hall-day and full-day values found in the Fleet worksheet. 2. Start with the new prices worksheet and review the formula in cell DS. Make any changes necessary and copy the formula for the remaining half-day rentals. (10 pts) 3. Create a new formula for the half-day rentals so that you can just copy the formula down for the 5% and 10% columns. (10 pts) Complete this for both the ball day and full-day rentals. 4. Go to the Fleet worksheet and create an IF function in column G. If the boat has 8 or more seats, then have the cell display "Yes, otherwise it should display "No." The logic is that only boats with eight or more seats can have a stove. (10 pts) 5. Put today's date in cell Kl with a light blue
