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 of 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\mathrm{.}1,2\mathrm{.}2,2\mathrm{.}3,2\mathrm{.}4,2\mathrm{.}5,2\mathrm{.}6,2\mathrm{.}7]$

File Needed: SanDiegoSailing$-02.$xIsx $($Available from the Start File link.$)$

Completed Project File Name: $[$your name$]-$SanDiegoSailing$-02.$xIsx

Skills Covered in This Project

Create and copy formulas.

Use formula auditing tools.

Set mathematical order of operations.

Use relative, mixed, and $3$D cell references.

Use COUNTIF and SUMIF functions.

Build an IF formula.

Insert the TODAY function.

Steps to complete This Project

Reset Progress $$

Back to top

$31$