## Related Questions

- Help Completing Cengage Assignments
- Detailed Essay Plan Submission In A Few Hours!! (20% Of Final Grade)
- Detailed Essay Plan Submission In A Few Hours!! (20% Of Final Grade)
- Advance Excel Assignment Help
- Business Analytics Excel Assignment
- Excel Test • Download And Open The Excel Test Two.xlsx Workbook.
- The Test Is Basically To Demonstrate If You Have Basic Knowledge On Excel.
- Using Microsoft Excel Create Two Sheets For An Nfl Document.
- Using Historic Sales Data, Create A Monthly Forecast Using Monthly Decomposition
- Business Excel Project Part 03
- Yo19_Excel_Bu03_Ps1_Movie_Analysis
- Choose One Model Or Theory From Chapter 3 And Create A Short 4-5 Powerpoint Presentation That Explains Model Or Theory
- Several Questions Need Completing With Explanation Asap
- This Is A Computer Assignment It Is About Information System In Business Using Access
- Excel Assignment Very Detailed

## Popular Services

- Coursework writing help
- Term paper writing help
- Writing Help
- Paper Writing Help
- Research paper help
- Thesis Help
- Dissertation Help
- Case study writing service
- Capstone Project Writing Help
- Lab report Writing
- Take my online class
- Take my online exam
- Do my test for me
- Do my homework for me
- Do my math homework for me
- Online Assignment Help
- Do my assignment for me
- Essay Writing Help
- Write my college essay
- Write my essay for me

Post your project now for free and watch professional homework help experts outbid each other in just a few minutes.

## Excel Simnet Homework Information Systems Help

Asked

Modified

Viewed
26

NOTE: If group titles are not visible on your Ribbon in Excel for Mac, click the Excel menu and select Preferences to open the Excel Preferences dialog box. Click the View button and check the Group Titles check box under In Ribbon, Show. Close the Excel Preferences dialog box.
Open the SanDiegoSailing-02.xlsx workbook.
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.
Review a formula.
Click the New Prices sheet tab and review the Formula bar.
Click cell D5. The formula begins with 1+D4.
Edit and copy a formula with mixed references.
Edit the formula in cell D5 to show D$4 instead of "D4." The formula should multiply 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).
The formula is =(1+D$4)*Fleet!$H5
Figure 2-105 Mixed reference in the edited formula
Copy the formula in cell D5 to cells D6:D19 without formatting to preserve the border.
Select cells D5:D19 and drag the Fill pointer to copy the formulas to cells E5:E19.
Click cell E6. The formula is adjusted to use the percentage value in cell E4 in place of cell D4. Note also that the reference on the Fleet sheet ($H6) is adjusted to show the correct row.
Build a formula with mixed references.
Click cell F5 and type =(1+ to start the formula.
Select cell F4 and make it an absolute reference to the row but not the column.
Type )* for the closing parenthesis and multiplication.
Click cell I5 on the Fleet sheet, and make the reference absolute for the column but not the row (Figure 2-106).
The formula is =(1+F$4)*Fleet!$I5
Figure 2-106 Mixed references in the new formula
Copy the formula down column F without formatting to preserve the border.
Format cells F5:F19 as Currency and then copy cells F5:F19 to cells G5:G19.
Build an IF function formula.
Click the Fleet sheet tab and select cell G5. Rental boats with a stove in the galley must seat 8 or more people.
Create an IF function in which the logical_test argument determines if there are 8 or more seats.
Use Yes for the value_if_true argument. Use No for the value_if_false argument. (If you type the formula, enclose the text arguments within quotation marks.)
Copy the formula to cells G6:G19 without formatting and then center the data in column G.
Insert the TODAY function in cell B21. Format the date to show the month spelled out, the date, and four digits for the year (January 1, 2020).
Create a division formula.
Click the Bookings sheet tab and select cell F5. Calculate average revenue per passenger by dividing the fee by the number of passengers.
Build the division formula.
Copy the formula in cell F5 to cells F6:F19.
Create and copy a COUNTIF function to count bookings by boat manufacturer.
Select cell D27.
Start the COUNTIF function from the Statistical category by clicking the More Functions button in the Function Library group.
Use cells $C$5:$C$19 as the Range argument.
Set a Criteria argument that will select all boats in the “Beneteau” group. The criteria is ben*. If you type the formula, include quotation marks.
Copy the formula in cell D27 to cells D28:D30.
Edit the criteria in each copied formula in cells D28:D30 to reflect the boat make.
Create and copy a SUMIF function to calculate total revenue by boat make.
Select cell E27.
Start the SUMIF function with cells $C$5:$C$19 as the Range.
Set the Criteria argument to ben*.
Set the Sum_range argument to cells $E$5:$E$19.
Copy the formula in cell E27 to cells E28:E30.
Edit the criteria in each copied formula in cells E28:E30 as needed.
Complete formatting.
Apply the Currency format to all values that represent money.
Format the labels in cells A1:A2 as 18 point.
Select cells A1:F2 and click the Alignment launcher [Home tab, Alignment group]. Center the labels across the selection.
Merge and center the label in cell C25 over cells C25:E25 and format it at 16 points.
Bold and center the labels in rows 4 and 26.
Select cells A4:F19 and apply All Borders. Do the same for cells C25:E30.
Center the page horizontally.
Save and close the workbook (Figure 2-107).

This order does not have tags, yet.

### Additional Instructions

Fleet
San Diego Sailing
Rental and Charter Fleet
Boat ID Make and Model Length Model
Year Seats Sleeps Galley
with Stove Half-Day
Rate Full Day
Rate
1010 Catalina Wave 28'4" 2010 8 6 $375.00 $650.00
1015 Catalina Sky 28'4" 2012 8 6 $425.00 $725.00
1146 Hunter Ray 33'6" 2014 10 6 $350.00 $500.00
1150 Capri MKZ 24'8" 2011 6 4 $325.00 $500.00
1152 Capri 22 Mk II 24'8" 2016 6 4 $325.00 $500.00
1164 Capri 22 Mk II 24'8" 2016 6 4 $325.00 $500.00
1168 Hunter 33 33'6" 2018 10 6 $425.00 $725.00
1175 Beneteau 40 39'10" 2018 12 6 $489.00 $750.00
1180 Beneteau 373 36'11" 2017 10 6 $369.00 $725.00
1185 Hunter Sea 35'6" 2009 10 6 $349.00 $550.00
1190 Beneteau 373 36'11" 2017 10 6 $369.00 $625.00
1200 Beneteau 373 36'11" 2017 10 6 $369.00 $625.00
1205 Beneteau 40 39'10" 2018 12 6 $489.00 $750.00
1225 Hunter Sea 35'6" 2012 10 6 $349.00 $725.00
1230 Catalina Wave 28'4" 2019 8 6 $439.00 $675.00
New Prices
San Diego Sailing
New Prices at 5% and 10% Increases
Half-Day Full Day
Boat ID Make and Model Length 5% 10% 5% 10%
1010 Catalina Wave 28'4" $393.75
1015 Catalina Sky 28'4"
1146 Hunter Ray 33'6"
1150 Capri MKZ 24'8"
1152 Capri 22 Mk II 24'8"
1164 Capri 22 Mk II 24'8"
1168 Hunter 33 33'6"
1175 Beneteau 40 39'10"
1180 Beneteau 373 36'11"
1185 Hunter Sea 35'6"
1190 Beneteau 373 36'11"
1200 Beneteau 373 36'11"
1205 Beneteau 40 39'10"
1225 Hunter Sea 35'6"
1230 Catalina Wave 28'4"
Bookings
San Diego Sailing Bookings
Revenue per Passenger
Date Boat ID Make and Model # of
Passengers Total
Fees Revenue per
Passenger
4/5/20 1010 Catalina Wave 4 525
4/8/20 1015 Catalina Sky 6 850
4/11/20 1146 Hunter Ray 6 500
4/14/20 1150 Capri MKZ 6 525
4/17/20 1152 Capri 22 Mk II 4 325
4/20/20 1164 Capri 22 Mk II 3 475
4/23/20 1168 Hunter 33 6 725
4/26/20 1175 Beneteau 40 10 850
4/29/20 1180 Beneteau 373 8 350
5/2/20 1185 Hunter Sea 8 650
5/5/20 1190 Beneteau 373 10 625
5/8/20 1200 Beneteau 373 8 725
5/11/20 1205 Beneteau 40 12 850
5/14/20 1225 Hunter Sea 8 725
5/17/20 1230 Catalina Wave 6 675
Bookings by Make
Count Total
Revenue
Beneteau
Capri
Catalina
Hunter

### Answers

0No answers posted

### Post your Answer - free or at a fee

#### Login to your account tutor account to post an answer

Posting a free answer earns you **+20** points.

To get help with a similar task to Excel Simnet Homework Information Systems Help, Ask for Microsoft Excel Assignment Help online.