BUS3310 independent project

Step 1:

Download start file

Don't use plagiarized sources. Get Your Custom Essay on
BUS3310 independent project
Just from $13/Page
Order Essay
  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.

Homework Writing Bay
Calculator

Calculate the price of your paper

Total price:$26
Our features

We've got everything to become your favourite writing service

Need a better grade?
We've got you covered.

Order your paper