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 4

01/12/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:

Academic Master
Helping Hand
High Quality Assignments
Calculation Master
Helping Engineer
Engineering Help
Writer Writer Name Offer Chat
Academic Master

ONLINE

Academic Master

I am an academic and research writer with having an MBA degree in business and finance. I have written many business reports on several topics and am well aware of all academic referencing styles.

$49 Chat With Writer
Helping Hand

ONLINE

Helping Hand

I have worked on wide variety of research papers including; Analytical research paper, Argumentative research paper, Interpretative research, experimental research etc.

$22 Chat With Writer
High Quality Assignments

ONLINE

High Quality Assignments

I have read your project description carefully and you will get plagiarism free writing according to your requirements. Thank You

$34 Chat With Writer
Calculation Master

ONLINE

Calculation Master

I am a professional and experienced writer and I have written research reports, proposals, essays, thesis and dissertations on a variety of topics.

$24 Chat With Writer
Helping Engineer

ONLINE

Helping Engineer

I am a professional and experienced writer and I have written research reports, proposals, essays, thesis and dissertations on a variety of topics.

$37 Chat With Writer
Engineering Help

ONLINE

Engineering Help

I will provide you with the well organized and well research papers from different primary and secondary sources will write the content that will support your points.

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

Stages of the lifespan cafs - Paper - Wallace thrasher unsolved mysteries - Cultural genogram symbols - What are the measures for meeting the challenges of implementing knowledge managementprogramme?Explain the role of knowledge management in industry. - What is the density of 53.4 wt aqueous naoh - NUR512-Reply to this discussion - Edwine - Visual basic chapter 3 programming projects answers - Federal reserve bank of st louis liber answers - Is 121 a rational number - I need 1800 words in Quantitative PCR assay better than traditional culturing methods - Caterpillar swot analysis 2016 - Under what circumstances might fair trade actually cause harm - Work within legal and ethical framework - Was John owed a duty of care by bowling alley? - Marketing management project on sunglasses pdf - Submission identifying your thesis - Pearson vue south africa - Investment corporation of bangladesh branches - Social work case studies foundation year 2013 pdf - ET WK4 - Research Paper on how information and communication innovation drives change in educational settings. - Post graduation adventure - 5 domains of recovery-oriented practice - Sample of article critique using apa format - Dr dawoud rowais flemington - Week 8 HUM101: World Religion and Cultures - Young goodman brown annotated pdf - In the long run changes in the money supply - Nursing informatics infographic - Up down counter jk flip flop - Avantgardeitcbybt mediumoblique - Nfpa 99 2012 chapter 15 - Shapes of sp and d orbitals pdf - The tell tale heart inference test answers - Journal Analysis - Half caste annotated poem - An organization pursuing a loyal soldier hr strategy - Apa position paper template - Solution Development - Easy mousetrap car designs - Kristen swanson theory - Source documents in accounting - What is the first pillar of islam - 在線購買氯胺酮,購買MXM粉末,購買1P-LSD粉末,購買美沙酮,在線購買MDPV購買DMT粉末。 - V2500 engine training manual - Nancy drew the deadly device masons password - Negative feedback tone control - Jb hi-fi mobile plan $65 - Compression test of cast iron - Suppose that people consume only three goods - Vodka cruiser vanilla pine lime - Lake press distribution pty ltd - Personal finance chapter 12 investing in stocks vocabulary answers - Perform a Vulnerability Assessment of your place of employment or living area. - Gcu integration of faith and work - Help need for research class (2) - Can you feel the - Ins 32007 oracle home contains invalid characters - Who is forever 21 target market - Cytogenetics report for g banded karyotype - Odd todd and even steven poster - 471 wiltshire lane delacombe - Tuggeranong recycling drop off centre - Griffith university pass percentage - Scotiabank student gic refund - Marketing Management - Product life cycle of coca cola assignment - Donahue angry white men - Business Communication - Three stages of production function ppt - Discussion - Lindamood bell phoneme sequencing program - The electron configuration of carbon - Brilliant Answers - Direct tv qvc channel - Characters of 10 things i hate about you - Law - Dr david badov gastroenterologist - Stainless steel nut and bolt torque settings - Rawson homes price list - E business is part of e commerce true false - Homework solutions fees - Nutramigen lipil for colic - Gotoquiz com create a quiz - Health and human development exam - Coastal medical center case study - The great italian trivia game - Baltimore waltz script - Con 290 pre course work nswers - Using exhibit 1.3 as a model describe the source-make-deliver-return relationships - Difference between protista and fungi - Classwork for English - Corporate Finance - Zeitoun part 2 summary - Powerflex 700 installation manual - 6 year old child observation report - David hyatt psychologist ballarat - Yale sr 320 installation - Openvellum.ecollege.com