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

Countable and uncountable food - Van der waals equation of state calculator - Milling machine v blocks - What command will display all connected ospfv2 routers - Whole foods job review - Small server room design - Mobile viewer pro kim's lab - The frivolity of evil - Presented below is an aging schedule for bosworth company - Ees program free download - Ark swift primary academy - Class diagram for pharmacy management system - Veracity definition nursing - Susan glaspell trifles discussion questions answers - Alphabet shift code breaker - Is psychology a hard science - Applied Machine Learning - What's stifling the creativity at coolburst - Vashikaran Specialist In Mumbai +917657874622 - Tech mahindra password policy - 8 - Conflict and culture - Discussion - Wendy Lewis 2 - Benefits of countertrade for a country - Managerial economics - Spectrum sunglass company simulation - Team diagnostic survey development of an instrument - What should be a firm's primary long term financial objective - Bpmn wait for event - La haine character descriptions - Employee discipline letter for absenteeism - Kingspan k10 soffit board - Unit 8 Public administration assignment - Pandora's box 7 game list - PHL/320T week 3 CRITICAL THINKING AND DECISION MAKING IN BUSINESS - Log mean temperature difference for counterflow heat exchanger - Compare and evaluate in 500 words or more qualitative v quantitative risk assessment. - Beverly crusher is a licensed cpa - Russia friend enemy or frenemy worksheet answer key - University of sunderland turnitin - Deliverable 07 R&W - 3 page paper Biography - Edwina the emu lesson plan - Com510 case study - Global digital citizen foundation rebus roundup - Www nationalgeographic org interactive salem interactive - Assignment - Wk1_Discussion - Zahir jooma net worth - Advance Pharmacology - State farm ksao assessment - Sweet paradise put up a parking lot lyrics - Cwv 101 benchmark gospel essentials essay - Research Method Choice for Dissertation Research - Oral Language and Literacy Development PPT - Verandah beam span tables - During a dysphoric manic episode the patient experiences mania and - Denton company manufactures and sells - Physics igcse equation sheet - REP 2 - Teledyne paradise q flex modem - Database design proposal template - Nike inc.cost of capital - one page essay paper - Webcam input or output - Rodent rush level 10 help - Hist289y - Apc written exam results - Indian camp hemingway pdf - Gestalt psychology case study - Food dye chromatography results - Equation for sulfuric acid and copper oxide - Refugee and special humanitarian proposal form 842 - Henry lawson shooting the moon quotes - Ham fen nature reserve - Is 59 a prime or composite number - Jib grading application form - APA format Paper - Employee engagement definition shrm - Is eye color a mendelian trait - Operational excellence refers to companies that ________. - The adventures of Sherlock Holmes research paper - Why does bruno call gretel a hopeless case - Expand and simplify x 5 x 5 - Middletown centre for autism ireland - To assess the accuracy of a laboratory scale - Lord of the flies chapter 2 quotes with page numbers - Tree diagram with and without replacement - Building a learning organization garvin - Stork pmt poultry processing systems - Sace business and enterprise stage 2 - Ideal and quotient rings - Herman survivors boot care kit review - Jonathan adler nixon library table - Stp data transmission category - Www professor garfield com - Cable pull through jeff nippard - Describe the major regulations governing hrm practices - Planning the Project-2