Step 1:
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
ACDGH
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)
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!Use Discount Code "Newclient" for a 15% Discount!NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.