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

Design consulting data series excel

02/12/2021 Client: muhammad11 Deadline: 2 Day

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:

Solutions Store
Solution Provider
Top Class Engineers
Coursework Helper
Professor Smith
Finance Professor
Writer Writer Name Offer Chat
Solutions Store

ONLINE

Solutions Store

I am an elite class writer with more than 6 years of experience as an academic writer. I will provide you the 100 percent original and plagiarism-free content.

$19 Chat With Writer
Solution Provider

ONLINE

Solution Provider

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

$45 Chat With Writer
Top Class Engineers

ONLINE

Top Class Engineers

I am an experienced researcher here with master education. After reading your posting, I feel, you need an expert research writer to complete your project.Thank You

$24 Chat With Writer
Coursework Helper

ONLINE

Coursework Helper

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

$28 Chat With Writer
Professor Smith

ONLINE

Professor Smith

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.

$29 Chat With Writer
Finance Professor

ONLINE

Finance Professor

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.

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

The passionate shepherd to his love questions answers - Educ 812 final exam - How to adjust nitrogen shocks - 4 5 10 7 - Draw enantiomer of the compound shown below - Mixed Methods Approach 8381 - Up the coolly keystone answers - My life in you arnold zamora pdf - Imoprtance of strategic IT planning 4 - Kfc industry classification - What strange adaptation does the tufted deer have - William william henry stephen henry richard john - Film techniques in shawshank redemption - Oceanview marine company 30 22 - Langston hughes salvation essay pdf - David mccormack god's gonna cut you down - Greenstar danesmoor 18 25 manual - Lullaby by leslie marmon silko questions and answers - East west family health - Obama nobel peace prize lecture - Ikea's strategies in japan - Two metal balls are the same size - My walden library database - Homeschooling Proposal IRB - Tom dodge talks about texas - DISCUSSION POST 2 - Cell phones should not be allowed in school - Roper superintendent potosi correctional center v simmons - Mt hotham car pass - Activity 1.2 6 555 timer answers - Importance of company secretary ppt - Discussion - Impact of corporate culture ppt - Lisa neville richard marles - Https get2 adobe com reader - Instructions - Wk 2 - Exponential and logarithmic inequalities - Justification defenses crj101 - The bont ella j lyrics - In a laboratory experiment you wish to determine - Looking for Best CV writing services - Parle mango bite price per piece - Religious - Mmu admissions contact email - Picot statement and literature search gcu - A raisin in the sun facts - Christopher newport university tuition - Canmore dental practice lochgelly - Write your 5 paragraph case study - Nursing interventions for kussmaul respirations - Another word for untidy - Business ethics ethical decision making and cases 8th edition - Ghetto miasma - Lenses lab report - Mha/520 - Katzensprung 1 workbook answers - Kingsgate student lock in - Business - Activity week 2 - Walmart ethical dilemma - Robin hood joseph lampel - Safeway self storage ashmore - Lg electronics mobilecomm usa - 8 44 overtime rule alberta - Power circuit theory uts - Decision making under certainty uncertainty and risk - Final Project Submission: Strategic HR Plan - Convergence and the Reshaping of Mass Communication - 10-12 pages - According to philosopher john locke, which of the following statements about human rights is true? - Floating beer pong table spencers - Olive house bacup reviews - Medieval monk daily routine - Cable tray seismic bracing - Master calendar uc davis - How to improve image rating on globus - Deborah tannen gender theory - Sanctuary of apollo at amyklai - As of december 31 2017 armani company's financial - Why is there a pop sound when hydrogen is burnt - Northern bay college abn - Two towns shiraz dan murphy - Tertiary student concession card nsw - Despicable me 3 124movies - Bb imperial ac uk - The art of wall e - Pitcher & piano menu - Behaviour change wheel model - Qbcc mechanical plumbing licence - Essentials of sociology 2nd edition george ritzer pdf - Dr kimberly levels of attraction quiz - Diane baxter university of oregon - Nurs 6650 midterm exam questions and answers - Identifying verbs in a passage - The presidential character james david barber pdf - Www rafe videos com - Tutorial questions-Marketing research - Anemia in pregnancy case study - The ultimate anabolic cookbook 2.0 pdf free