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 2019 in practice ch 2 independent project 2 5

11/11/2021 Client: muhammad11 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:

Coursework Helper
Top Quality Assignments
Phd Writer
A+GRADE HELPER
Homework Guru
Financial Hub
Writer Writer Name Offer Chat
Coursework Helper

ONLINE

Coursework Helper

After reading your project details, I feel myself as the best option for you to fulfill this project with 100 percent perfection.

$38 Chat With Writer
Top Quality Assignments

ONLINE

Top Quality Assignments

I have written research reports, assignments, thesis, research proposals, and dissertations for different level students and on different subjects.

$47 Chat With Writer
Phd Writer

ONLINE

Phd Writer

As per my knowledge I can assist you in writing a perfect Planning, Marketing Research, Business Pitches, Business Proposals, Business Feasibility Reports and Content within your given deadline and budget.

$33 Chat With Writer
A+GRADE HELPER

ONLINE

A+GRADE HELPER

As per my knowledge I can assist you in writing a perfect Planning, Marketing Research, Business Pitches, Business Proposals, Business Feasibility Reports and Content within your given deadline and budget.

$26 Chat With Writer
Homework Guru

ONLINE

Homework Guru

I have written research reports, assignments, thesis, research proposals, and dissertations for different level students and on different subjects.

$28 Chat With Writer
Financial Hub

ONLINE

Financial Hub

I have read your project details and I can provide you QUALITY WORK within your given timeline and budget.

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

22 abbey st leura - Word of the week - Saudis expand regional power as others falter summary - Squatty potty sales 2018 - Westminster city council housing - Institute of medicine iom report - Southwest airlines cost leadership strategy - How to calculate cell size - Louis Vuitton Outlets - Chem Lab, Introduction to molecules - Research paper - After an entry in the medical record has been written or keyed and an error is discovered - Medical radiation technologist nz - What rule does ralph set for the tribe - Technology in the Human Service Field - Cloud infrastructure architecture case study - Gas turbine iso rating - Fat leo restaurant brighton - Intake manifold runner control circuit - Dynamics in nursing art and science of professional practice - Mentoring Philosophy - Bayside obstetrics and gynaecology - Activation synthesis theory examples - The whole health cairn - Cross cultural psychology - Ch3cooh caco3 equation balanced - Ktea 3 scoring manual - Evil jireh the voice - Russell seal fitness centre - What is bonding molecular orbital - Business ethics case studies and selected readings ebook - Paradise lost study questions - Ari weinzweig and paul saginaw illustrate that good leadership is - Standardization of 0.1 m sodium hydroxide - Leaf under microscope 400x - Qut wil placement agreement - The firm movie ethical issues - Globe telecom number of subscribers - Romeo and juliet news report assignment - Ghetto until proven fashionable black vogue - Bar mark shape codes - 2. how has dna sequencing affected the science of classifying organisms? - Canada steamship lines ltd v the king - Contemporary international problems wk 5 discussion - Density of a gummy bear - Coffee contract negotiation - Unit 2 IP PC - Rosella tomato soup woolworths - Burn marlon brando full movie - What is compromised data integrity - Lord goring character analysis - Mpa to kn mm2 - Teaching period 3 swinburne - How to order hol lab kit - Criminal profiling cases solved - Beats by dre swot analysis - Context level data flow diagram for perfect pizza - Dynamic processes support operational activities - Hris cost benefit analysis matrix - Genie z45 22 parts manual - The legacy of ancient greece and rome answer key - Excel - Difference matters brenda allen pdf - L estrange v graucob - Eaton lighting control systems - Long necked lute from modern greece crossword clue - Expression of interest for phd - Use case diagram for calculator - Captain thunderbolt and his lady - Caravan storage brierley hill - Oranges by gary soto - What are concepts nurses should consider when prioritizing care - International journal of offshore and polar engineering - Precis writing exercises - Hacker techniques tools and incident handling 2nd edition pdf - URS 6003/NURS 6003A/NURS 6003F/NRSE 6003C/NURS 6003N/NURS 6003C: Transition to Graduate Study for Nursing - Cube edges faces vertices - Gay and capitalism. - Project management 3 - The financial industry uses business intelligence to predict hardware failures - Comparing the articles of confederation and the constitution worksheet answers - Personification in the village blacksmith - Www gpwonline co za visa forms - Assessment 2 - Colin tribe ukulele arrangements - Tensile test of mild steel lab report - A level media grade boundaries - Initiating the Project - Problem Set 7 - Clearfox sewage treatment plant cost - Create a scenario summary report excel 2013 - Perseus and the lightning thief - Legal ethical & social environment - United community bank bluffton sc - Thermo scientific material safety data sheet - Swinburne semester 2 start date 2021 - Whistleblowing in publicly traded companies within the last 12 months - Aeneid book 2 translation - Cmit 425 risk assessment paper - Homework computer - What is the slope of the line 8x 6y 12