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

26/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:

A+GRADE HELPER
Custom Coursework Service
Coursework Helper
Financial Solutions Provider
Write My Coursework
Quality Homework Helper
Writer Writer Name Offer Chat
A+GRADE HELPER

ONLINE

A+GRADE HELPER

I have assisted scholars, business persons, startups, entrepreneurs, marketers, managers etc in their, pitches, presentations, market research, business plans etc.

$40 Chat With Writer
Custom Coursework Service

ONLINE

Custom Coursework Service

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.

$20 Chat With Writer
Coursework Helper

ONLINE

Coursework Helper

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.

$20 Chat With Writer
Financial Solutions Provider

ONLINE

Financial Solutions Provider

This project is my strength and I can fulfill your requirements properly within your given deadline. I always give plagiarism-free work to my clients at very competitive prices.

$29 Chat With Writer
Write My Coursework

ONLINE

Write My Coursework

This project is my strength and I can fulfill your requirements properly within your given deadline. I always give plagiarism-free work to my clients at very competitive prices.

$41 Chat With Writer
Quality Homework Helper

ONLINE

Quality Homework Helper

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

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

143 empress terrace bardon - Horizontal and vertical analysis excel - Difference between content theory and process theory of motivation - Paper - RS - The runaway pancake tumblebooks - Concluding observations on the sixth periodic report of australia - The child care professional textbook - Competitor myopia definition - European patent office munich jobs - WD5 - What is rehashing in data structure - Is 33 a rational number - Matlab state space simulation - Competitive advantages of starbucks - Big brother is watching you - What is evocative language - Bone Diseases - Week four financial performance worksheet - Abas 3 reliability and validity - Hiroshima lovers watchmen - Help with assignment - Quotes from deadly unna - How to make a cross section in google earth - What would be an optimum wavelength for measuring the absorbance - Principles of advocacy in nursing - How to calculate average stockholders equity - Sro vic gov au paylandtax - A rose for emily summary shmoop - Libs 150 research log project 2 answers - Layout and flow in operations management - Exam - A summary of the outsiders - BA Assignment - Lär dig nya språk med hjälp av Chat GPT Svenska Gratis - Two Discussions - Rachael ray sauteed red cabbage - Goethe institut kuala lumpur - 180 bourke road umina beach - Marketing Global - Questions about the food chain - Themes and growth for healthcare management - Reponse nope quiz question 93 - Pictures of non metals - Stick and poke tattoo kit hobby lobby - Phases of matter worksheet answers - Fusion king aberystwyth telephone number - Why did matt and monni leave travel guides - Crm winback hilton honors 5 offer - Cuco3 h2so4 cuso4 h2o co2 - Kids shoe sizes conversion - What is a pdp - Apple company leadership style - Ccna 200-301 exam questions pdf - Frik oosthuizen sg coal - Uber organizational culture case study - Images com is a small internet retailer - Nursing C-W-P (due 24 hours) - MISS PROFESSOR ONLY - Reading fluency iep goals examples - How would you describe sunset boards cash flows for 2014 - Leven swimming pool refurbishment - Final Summative Assignment - A synthetic fiber used in manufacturing carpet has tensile - Curriculum and Motivation - Chemistry matter and change chapter 9 study guide answers - Man edc 03850 01 - Peter ronson cause of death - Common root words and word origins - Magic of science essay in english - Human services - Principles of service marketing and management lovelock - Extron cable cubby 500 cut out template - P1v1 t1 p2v2 t2 - Www agendaweb org verbs - Quality management for organizational excellence introduction to total quality - Igcse history paper 4 candidate response - Reflection paper 1 - Applying snp profiles to drug choices - Week 5 Assignment: Journal - Cyclohexene and cyclohexane experiment - Finance - Maternal nursing and women health practice - Invalid program counter value mips - Pattison sign group heath springs sc - Calculate compa ratio excel - Strayer university acc 100 syllabus - Htc and virtual reality case analysis - Pyridinium hydrobromide perbromide msds - Family focused functional assessment questionnaire - Todd lubitsch boy in the plastic bubble - Sandro salsano net worth - Heathfield infant school whitton - 500 words in APA format, with reference article on Exploring Social Media in Health Care: Beyond Its Pervasiveness - Lesson 2 BMGT - 11 pavia place augustine heights - Week 2 Project - Aswath damodaran personal portfolio - Penn foster college early childhood education - Abb dcs800 firmware manual