bus3310 independent project in 6 hours

Step 1:

Download start file

  1. Open the SanDiegoSailing-02.xlsx start file.
  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. 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)

"Is this question part of your assignment? We can help"