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

Excel independent project 2-5

28/10/2020 Client: arwaabdullah Deadline: 7 Days

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 Grade Essay
Quality Homework Helper
Top Essay Tutor
Buy Coursework Help
Top Writing Guru
Online Assignment Help
Writer Writer Name Offer Chat
Top Grade Essay

ONLINE

Top Grade Essay

Working on this platform from a couple of time with exposure of dynamic writing skills gathered with years experience on different other websites.

$142 Chat With Writer
Quality Homework Helper

ONLINE

Quality Homework Helper

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

$142 Chat With Writer
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.

$145 Chat With Writer
Buy Coursework Help

ONLINE

Buy Coursework Help

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

$142 Chat With Writer
Top Writing Guru

ONLINE

Top Writing Guru

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.

$140 Chat With Writer
Online Assignment Help

ONLINE

Online Assignment Help

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

$135 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

Epidemiology Case 4 - Griffith cover sheet pdf - Percent composition of aluminum acetate - Discussion : SWOT BLOCKS - Comprehensive Health History - What is culture and communication - The edge of us veronica larsen epub - A desolation called peace voices from kashmir - How to stop translating in packet tracer - 2 - Introduction to Ethics Proposal - Rona goffen titian's venus of urbino - Potential of magnetic dipole - Koppers logs mitre 10 - Kaleidoscope molecular weight ladder - 350 word answer - Corporate level strategies of victory motorcycles - +91-8306951337 get your love back by vashikaran IN Sangli-Miraj&Kupwad - Ops 571 statistical process control methods - Auckland council inspection checklist - Write grammatically correct sentences - But we have this treasure in earthen vessels - Among us skin hack - Why does beethoven now spend all his time erasing music - DB1 MAC - Ps2100 week 4 assignment worksheet - Cat 6 crimping color code - Design a bridge worksheet - N n0e λt derivation - Biozone unit 1 and 2 answers pdf - Consumer behavior by wayne d hoyer deborah j macinnis pdf - When does othello slap desdemona - Mystery and melancholy of a street - Ben and jerry's homemade case study solution - Qnt 561 signature assignment hospital - Where is the vanishing point in the last supper by leonardo da vinci? - Cedar craft apartments broken arrow ok 74012 - Success is a journey not a destination ben sweetland - 9 5/6 as an improper fraction - North or south who killed reconstruction essay - Occupational health nithbank dumfries - Mo yan life and death - Volkswagen swot analysis 2019 - Foundations of Financial Management - Identify theories in business - Aqa italian gcse past papers - Order 2143177: Read Instructions - How to calculate fnet - Euclid v ambler realty case brief - OPERATIONAL PLANNING - FOLLOW ALL THE BELOW POINTS AND NEED ANSWERS FOR ALL THE POINTS BELOW IN APA FORMAT WITH AT LEAST 500 WORDS EXCLUDING REFERENCES, TITLE AND NO PLAGIARISM AND NEED PLAGIARISM REPORT - Adelaide uni past exams - Case response - Health management form nib - Why did the hen run away - Question Answers Marketing 436 - Coddling of the american mind rebuttal - Minerals that crystallize directly from seawater are examples of - Assignment 3: The Presentation - When was the romantic period - Saylordotorg - Capstone Research Companion - Www worldatlas infopage continent htm - In what pursuit is solmization useful or important - Klaus voormann bass gear - 1.5 page - Carlill v carbolic smoke ball co [1893] 1 qb 256 - Hillbilly vs southern metal spinners - What is scope management plan - Discussion #2 - Bates visual guide to physical examination pdf - Air france klm case study - Colbar qsr pty ltd - Management - 705 CLA 1 Assignment - Teddy bunter firm west ham - 747 bus timetable aberdeen - Https www internetsociety org tutorials your digital footprint matters - Rise and fall of toms shoes - Gwendolyn brooks annie allen pdf - Underweight types - Smarter Decision Making through Psychology - Mechatronics engineering unsw handbook - Describe the abercrombie & fitch style - Discussion - Individual success plan - Newcastle university degree weighting - How many groups of 10 milliliters are in 1 liter - Yaw motor wind turbine - Criminal Justice: National Gang Problem - Personal information class python - Example of case note - A1302 hall effect sensor - Juan ramirez sells suits in a major - Hexadecimal Calculator - Operational Excellence: Information Systems for Business and Beyond Questions. - I will upload - Critical thinking activities - Spirituality and Social Work Practice - Soap note for shortness of breath - Modern erp marianne bradford pdf