Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Simnet excel independent project 2 5

07/01/2021 Client: saad24vbs Deadline: 2 Day

Excel 2013 Chapter 2 Working with Formulas and Functions Last Updated: 2/4/15 Page 1


USING MICROSOFT EXCEL 2013 Independent Project 2-5


Independent Project 2-5 When San Diego Sailing received its end-of-year financial reports, its financial officers decided to evaluate the rental rates schedule for boats. You have been asked to create a spreadsheet to compare three different proposed rate changes that the group is considering implementing in the new year and to update information on the boat fleet.


Skills Covered in This Project


 Create and copy formulas.


 Apply mathematical order of operations.


 Use relative, absolute, and mixed cell references.


 Apply the IF function.


 Name cells and use the name range in a


formula.


 Apply the TODAY function.


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


NOTE: If the workbook opens in Protected View, click the Enable Editing button in the Message Bar at the


top of the workbook so you can modify it.


2. Select H4 and create an IF function formula to determine which boats include a stove with the galley. Boats


must be able to seat 8 or more people to have a stove in the galley.


a. Use “Yes” for the value_if_true argument.


b. Use “No” for the value_if_false argument.


c. Copy the formula in H4 to H5:H18.


3. Insert a worksheet and name the sheet Data.


4. Type the following information in the new worksheet:


5. Format the table text on the Data sheet.


a. Merge and Center the text in A3 over A3:B3.


b. Apply Accent 1 cell style to A3 and apply bold format.


c. Select A3:B6 and apply the All Borders format.


6. Select A4:B6 and assign range names using the Create from Selection button on the


Formulas tab.


NOTE: To ensure accurate grading, you must complete step 6 correctly before continuing


with the project. Check your work carefully.


7. Select J4 on the Fleet worksheet, and create a formula to calculate a 5% increase for the data


in the “4 Hr. Rate” column using the range name assigned on the Data sheet.


a. Type =. b. Select F4 and type *. c. Press F3 to open the Paste Name dialog box.


d. Select _ 5_Increase and click OK.


e. Press Enter. Copy the formula to row 18.


Step 1


Download start file


Excel 2013 Chapter 2 Working with Formulas and Functions Last Updated: 2/4/15 Page 2


USING MICROSOFT EXCEL 2013 Independent Project 2-5


8. Create formulas for K4:O4 and copy the formulas to row 18.


9. Select the amounts in columns F, G, and J:O and apply the Number format.


10. Select A1 and type San Diego Sailing.


11. Format A1 using the Title cell style and apply bold format. Adjust the column width.


12. Insert a row above the current row 2. Clear the formatting of the new row 2.


NOTE: To ensure accurate grading, you must complete step 12. Check your work carefully.


13. Insert the TODAY() function in A2. Format the date as 11 pt. bold and align left.


14. Change the date format to display the month as a word followed by the day and year.


15. Apply the All Borders format to rows 4 through 19.


16. Click the Insert tab and click the Header & Footer button.


a. Switch to the Footer area.


b. Click the right text box and type Page followed by a space. c. Click the Page Number button on the Header & Footer Tools Design tab.


d. Click the worksheet and return to Normal view.


17. Paste range names in a worksheet.


a. Click the Data sheet tab and select cell A15.


b. Click the Use in Formula button [Formulas tab, Defined Names group].


c. Click Paste Names.


d. Click the Paste List button in the Paste Name dialog box.


e. Click OK.


18. Save and close the workbook (Figure 2-74).


19. Upload and save your project file.


20. Submit project for grading.


Step 2


Upload & Save


Step 3


Grade my Project


2-74 Excel 2-5 completed

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Top Essay Tutor
University Coursework Help
Helping Hand
Writer Writer Name Offer Chat
Top Essay Tutor

ONLINE

Top Essay Tutor

I have more than 12 years of experience in managing online classes, exams, and quizzes on different websites like; Connect, McGraw-Hill, and Blackboard. I always provide a guarantee to my clients for their grades.

$105 Chat With Writer
University Coursework Help

ONLINE

University Coursework Help

Hi dear, I am ready to do your homework in a reasonable price.

$102 Chat With Writer
Helping Hand

ONLINE

Helping Hand

I am an Academic writer with 10 years of experience. As an Academic writer, my aim is to generate unique content without Plagiarism as per the client’s requirements.

$100 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Emirates airlines analysis - Structure chart for restaurant management system - Heil hitler confessions of a hitler youth hbo movie - Cybertext building blocks of accounting a financial perspective - 007d8 - Marketing an introduction 13th edition citation - Portfolio assignment - Paper - Fight for liberty jose orozco - Speed of a toy car lab answers - Safety inventory can help for managing uncertainty in supply chain. - Doing ethics moral reasoning and contemporary issues 4th edition pdf - Mackay fuel filler hose - Telephone operator job description - BUSM1100 Individual Case Study Report - Assignment self awareness and conflict resolution - Health Policy and Law - Weiser lock battery change - Merriespruit tailings dam disaster - Manager's hot seat: working in teams: cross functional dysfunction - Enter to learn go forth to serve - Why is it best to have six or less life-cycle phases in an epm system - Actuarial mathematics for life contingent risks 2nd edition pdf - Ppt cloud computing architecture - What is the rationale for the payback method - Maximum zs for tt - Ac nielsen research services - Simnet excel independent project 2 5 - Haunting in connecticut jonah - Quality child care for babies national childcare accreditation council 2008 - Borders bookstore case study - Scs 100 theme 2: marriage graphic organizer - Importance of reimbursement in healthcare - Corporate social responsibility mercedes benz - Moorebank sports club menu - Vulnerable Populations - Florida car wash is considering a new project - Chapter 4 video quiz project repat - Google docs wiki template - What makes army leaders successful when exercising mission command - Bt easicom 1000 for sale - Write the economic analysis section of a business proposal - Eycc msu - Harrow bangkok term dates - Zipcar refining the business model case study analysis - Example of vertical analysis of financial statements - How to think like an anthropologist sparknotes - Harris pharmacy grove park - Childs v.weis - Two point perspective drawing - What are the components of research paper - Rn adult medical surgical online practice 2019 a - Mcgraw hill marketing simulation answers - Balanced chemical equation for sodium hydroxide and potassium hydrogen phthalate - According to prothero what is the problem for judaism - No sugar spark notes - Anthro root word definition - Tom sawyer discussion questions - How does ultrasound work bbc bitesize - Cinemax oberon mall kochi ticket rate - Written assignment - Physics formula sheet hsc 2021 - Left sided heart failure concept map - I do not think but desdemona's honest - Rank indicator in lte - Master budget template excel - Famoso adele mi hermana - Snap on vacuum sandblaster - 222:109 - learning studio first floor 109 - Young hare 7 letters - Optiplex 745 ultra small - Ancient greek numeral system - You can grow your intelligence answers - Dr zhen rong siow - Huish episcopi primary school - Business - Can you reuse breathalyzer mouthpieces - Conners 3 self-report questionnaire - Stories of Restoration – When God’s Light Breaks Through Darkness - How to write a play - Workplace training centre pty ltd - Australian fast foods pty limited - The tragic condition of the statue of liberty analysis - Applying the 21 synectics steps examples - What is the specific charge of electron - Case studies for social work students - Easy cello pieces pdf - Density and buoyancy lab - Equivalent markup on selling price - Plato republic book 1 - What is the distance between moab and bethlehem - Kite's nest war assets - Nursing: Qualitative Research/APA Essay Questions - Verizon Communications - Accounting transaction analysis worksheet - DUE IN 4 HRS MAXIMUM - Allis tissue forceps ppt - A fundamental distinction between trend projection and linear regression is that: - Asos swot - Miranda Rights