Download start file
- Open the SanDiegoSailing-02.xlsx start file.
- If the workbook opens in Protected View, click the Enable Editing button so you can modify it.
- 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. EdittheformulaincellD5toshow D$4 instead of â€œD4.â€ The formula multiplies 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).
b. Copy the formula in cell D5 to cells D6:D19 without formatting to preserve the border.
X . , BC
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. Note also that
the reference on the Fleet sheet ($H6) is adjusted to show the correct row. 6. Build a formula with mixed references.
Last Updated: 11/30/17 Page 1
San Diego Sailing Rental and Charter Fleet
2-106 Mixed references in the new formula
USING MICROSOFT EXCEL 2016 Independent Project 2-5 (Mac 2016)