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

Bygone japanese camera brand that merged with konica - Minority student clubs segregation or integration - 978 0 07 183597 8 - Week 3 Project - Explicit costs of an ipo tend to be around ______ of the funds raised. - Dot matrix led display circuit diagram 8 32 - What might a french peasant have grumbled about in 1789 - 100 thousand dollar candy bar - Signature Assignment: Infrastructure, Best Practices, and Security - Australian journal of basic and applied sciences - John cabot early life - Conflict in romeo and juliet - Whole foods market supplier portal - Investment banking cover letter - Accelerated combined bsn msn program for foreign educated physicians fep - Two long coaxial solenoids each carry current i - Scilab pid controller example - Toyota segmentation - Bigger than enron worksheet answers - What is 1 345 rounded to the nearest integer - Amoeba sisters video recap alleles and genes answers - Outcasts united chapter 3 summary - Upper management's interest in outcome evaluation data is focused on - Wacc of tesla - Ronald rivest net worth - Models for writers 12th edition answers - Conclusion of the poem the road not taken - Healthcare Informatics - WEEK 6 SOAP NOTE - Nursing Shortage Case - 3d trigonometry gcse exam question practice - Muslim Molvi 7340613399 OnLine No 1 FaMOUs VashIKaraN sPecIaLIsT IN Kurnool - Depreciation worksheet for students - ECON Question - Calculating cell size worksheet - Booster pump selection guide - Palmolive shave stick tesco - Lección 1 lesson test answers - Business latter - Active bodies active minds indoor playground & education centre - Branches of physical science ppt - How to read literature like a professor chapter 24 examples - Density of rational numbers - Pfizer organizational design - Efficiency of dc shunt motor - Economics and Society - Need help with capstone final project - Outsourcing - Area director visit report - Developing the public relations campaign pdf - Journal Entry - Baking soda to vinegar ratio - Michelle fleshner worked for pepose vision institute - Enviro gas fireplace manual - Proactive approaches to behavioral challenges - A baseball is thrown from the roof of - Tjs inc makes three nut mixes - Which stage of life is the most nutritionally challenging - Hsc extension english syllabus - How to measure abiotic factors - Cell phone battery charger circuit - A nurse is providing preoperative teaching - Living with the earth gary moore - Free sites like pirate bay - Terminal digit filing example - From bottom to top how one provider retooled its collections - Where does chemical digestion start - Onlineforms vodafone ie employee advantage - Poetry explication assignment - 9.10 stone in pounds - Beth moore daniel session 10 speechless vimeo - Definition of Leadership - Mass up guru mann pdf - Presenting problem example treatment plan - Vic police air wing scanner - How to critique an article nursing - V for vendetta orchestra scene - Criminal justice - Race& Ethnicity - University of johannesburg law faculty - Six sigma acca p5 - Organizational Behavior - Resumen - Gcu essay template - Changing images of violence in rap music lyrics - Jim greco neck tattoo - Stewart and cash interviewing pdf - Module 04 Quiz - Brothers and sisters riddle - Reflection paper on human relations - Denver baggage system case study - Round 4.639 to 1dp - 1621 reedy creek road rockleigh - Bug club reading assessment - Jeep target market - Colpitts crystal oscillator design - Express your answer as an isotope - How has contemporary culture influenced the humanities - Stick diagram of xor gate - An ant on a picnic table travels 30cm eastward