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

Remove design consulting data series excel

22/11/2021 Client: muhammad11 Deadline: 2 Day

() Print Info

Student Name: Gullickson, Finn

Student ID: D41122036

Username: D41122036 Excel 2019 In Practice - Ch 3 Independent Project 3-4 COURSE NAME BIS155 SEP20 Master | Data Analysis with Spreadsheets with Lab - 11964

Start Date: 09/05/2011:59 PMUS/Mountain Due Date: 09/13/2011:59 PMUS/Mountain End Date: 10/25/2011:59 PMUS/Mountain

Independent Project 3-4 For this project, you create a column chart to illustrate April–September revenue for Classic Gardens and Landscapes. You also build a pie chart sheet to graph the proportion that each category contributes to total revenue. [Student Learning Outcomes 3.1, 3.2, 3.3, 3.4, 3.5, 3.6]

File Needed: ClassicGardens-03.xlsx (Available from the Start File link.) Completed Project File Name: [your name]-ClassicGardens-03.xlsx

Skills Covered in This Project Create a chart object. Size and position a chart object. Edit and format chart elements. Edit the source data for a chart. Build a pie chart sheet. Use texture as fill. Add and format data labels in a chart.

This image appears when a project instruction has changed to accommodate an update to Microsoft 365 Apps. If the instruction does not match your version of Office, try using the alternate instruction instead.

1. Open the ClassicGardens-03.xlsx start file. If the workbook opens in Protected View, click the Enable Editing button so you can modify it. 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 group titles are not visible on your Ribbon in Excel for Mac, click the Excel menu and select Preferences to open the Excel Preferences dialog box. Click the View button and check the Group Titles check box under In Ribbon, Show. Close the Excel Preferences dialog box.

2. Create a Clustered Column chart object for cells A4:G9.

3. Move the chart object so that its top-left corner is at cell A12. Size the bottom of the chart to reach cell H30.

4. Edit the chart title to display CGL Major Sales Revenue and press return. On the second line, type Second and Third Quarters.

SIMnet - Excel 2019 In Practice - Ch 3 Independent Project 3-4 https://devry.simnetonline.com/sp/embed/#pr/5573828

1 of 3 10/23/20, 12:00 PM

Figure 3-71 Resize the chart by dragging the resize pointer

5. Apply chart Style 14 to the chart.

6. Format the first line and the second line of the chart title to a font size of 20 pt.

7. Apply a 1 pt Black, Text 1 (second column) outline to the chart area.

8. Verify that the chart is still selected. In the highlighted range in the worksheet, drag the resize pointer to remove the Design Consulting data series from the chart (Figure 3-71).

9. Create a 3-D Pie chart sheet for cells A4:A9 and cells H4:H9. Move the chart to its own sheet named Revenue Breakdown. Hint: Use the Move Chart button [Chart Design tab, Location group].

10. Edit the chart title to display Revenue by Category. Change the font size to 32.

11. Select the legend and change the font size to 12.

12. Apply the Woven mat texture fill (first row, fourth column) to the Patio and Furniture slice.

13. Select the pie shape and add data labels to display in the center of each slice.

a. Display the Format Data Labels task pane, choose the Accounting format [Label Options button, Number group], and set 0 decimal places.

b. Change the data label font size to 14 pt and apply bold [Home tab, Font group].

14. Deselect the chart.

15. Save and close the workbook (Figure 3-72).

Figure 3-72 Excel 3-4 completed worksheet and chart

16. Upload and save your project file.

17. Submit project for grading.

SIMnet - Excel 2019 In Practice - Ch 3 Independent Project 3-4 https://devry.simnetonline.com/sp/embed/#pr/5573828

2 of 3 10/23/20, 12:00 PM

SIMnet - Excel 2019 In Practice - Ch 3 Independent Project 3-4 https://devry.simnetonline.com/sp/embed/#pr/5573828

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:

Maths Master
Top Quality Assignments
Exam Attempter
A Grade Exams
Solutions Store
Coursework Help Online
Writer Writer Name Offer Chat
Maths Master

ONLINE

Maths Master

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.

$49 Chat With Writer
Top Quality Assignments

ONLINE

Top Quality Assignments

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.

$48 Chat With Writer
Exam Attempter

ONLINE

Exam Attempter

I reckon that I can perfectly carry this project for you! I am a research writer and have been writing academic papers, business reports, plans, literature review, reports and others for the past 1 decade.

$30 Chat With Writer
A Grade Exams

ONLINE

A Grade Exams

Being a Ph.D. in the Business field, I have been doing academic writing for the past 7 years and have a good command over writing research papers, essay, dissertations and all kinds of academic writing and proofreading.

$27 Chat With Writer
Solutions Store

ONLINE

Solutions Store

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

$33 Chat With Writer
Coursework Help Online

ONLINE

Coursework Help Online

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

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

Prof dan healy private clinic - Moral model of ethical decision making - Recommendation and conclusion - Ideia kde definition of gifted and talented twice exceptionality - Waren sports supply bank reconciliation 2017 - Used foxbat for sale australia - Average speed formula with two speeds - A streetcar named desire study guide answers - Common bond christian band - Bsg online 3 year strategic plan - Bourdieu journal - Bob cherry billy bunter - Expansion strategy and establishing a reorder point excel - Major concepts of nursing theory - Fep executive search jessica hogan - Geo 3030 - 17 elements of iso 14001 - Anatomy - Main characters in bend it like beckham - Famous Bubbles - In cell biology what does the word queue describe - Bablock hythe caravan site flooding - 6 4 historical analysis essay progress check 2 - Hdmi 2.1 cable jaycar - Chapter 10 - Gang leader for a day essay - Midterm - Blackwood pool werribee gorge - 6500 steps in miles - My maths angles in parallel lines homework answers - Designing effective presentations part iii - Is earith bridge open - What's eating gilbert grape psychology - Manrose 1350 fan speed controller - Strategic audit worksheet example - Grocery shop program in python - Rules by cynthia lord chapter 3 summary - Racist quotes in to kill a mockingbird - Where sears went wrong - Joslyn clark fire pump controller troubleshooting - Bushbuckridge local municipality logo - Field pattern of antenna - MIS Discussion 14 - How many times has the current texas constitution been amended - [email protected] OPTION approved Abortion Pills +27835179056 in durban soweto springs mayfair benoni limpopo polokwane vaal - Ben and jerry's vision statement - Calculate inrush current of motor - Deshawn has five base ten blocks - Belbin team roles test questionnaire free - Daimler chrysler merger case study analysis - Panic disorder severity scale - Geometry sin cos tan worksheet - E compensation tools in the job evaluation process - Gallons per acre inch - Heroes with a mission bumppo and batman answers - Timber framing span tables - Asurion pre recorded interview questions - What is the meaning of polar molecule - One page memo - Creating shared value hbr - Tina jones abdominal objective data - Shadow health musculoskeletal assessment - Chapter eighteen and nineteen assessment preparation connotation answers - Cat critically appraised topic - History - Www unswglobal unsw edu au educational assessments - Diego velazquez surrender of breda analysis - Friendship knot step by step - IT Related Question - Article summary - Eve online odin synthetic eye - How positive team culture can correct the impact of lagging leadership creativity - Flexo printing line screen - How to cite strengthsfinder assessment - Discussion questions for the other wes moore - Explain the importance of establishing credibility for business communications - The mission statement of coca cola - York county skate rattle and roll - Discussion - Help 1 - French Class - Case study online education peter drucker - Garden city cotton on body - Composing an essay of at least 500 words. - Unit 4 - Pelvic exam soap note example - St augustines coffs harbour - Vcaa 2017 eal exam - Chcccs006 facilitate individual service planning and delivery - What have you learned about research at an introductory level - Power Point - Using Research to Inform Professional Practice - Health care information systems terms - John zappia net worth - Gabriel gloo wine glasses - Operating principle of a defibrillator - Cinahl database gcu - Dimensionality reduction reduces the data set size by removing ___ - JOURNAL REPORT - St brides east kilbride bulletin