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 army crew team harvard business school - A leader should provide structure when establishing a constructive climate. - Times are a changin lyrics - I will here for you lyrics - Courier tribune mugs and thugs - Costco centrum silver women's - Study Questions and Essays - Www luton gov uk parking - Machining fundamentals workbook answers - The real cost of cheap fashion worksheet answers - A loving partner is a safe sheltera loving partner is a safe shelter - Business paper - Chapter 3 jekyll and hyde - Nupage gel loading volume - G2 - Achievement and Benevolence - Joe dolce you toucha my car i breaka you face - Job sculpting harvard business review - Lorem, ipsum - The proverbs tell us how to live life successfully - Samsung first product dried fish - Testout network+ certification practice exam answers - How to calculate product margin under traditional costing system - Acme anvils has a newly patented - Positive response due tomorrow 08/07/20 at 3pm - Blue in great gatsby - Lighting and electrical symbols - Certificate of registration strata management - Physics igcse equation sheet - Loading and unloading employment - The hobbit chapter 14 - Organisational problem solving - Traditional methods of harvesting - Tic tac toe java program code - Case Brief Assignment 1 - Telstra byo tablet plans - Zara strengths and weaknesses - Chalk and wire saint leo university - Linux native file system - Higher physics specimen paper - Five service quality dimensions - Rhizobium inoculant suppliers australia - Lone wolf tattoo meaning - Assignment - Socialization - Hci cognitive walkthrough example - Safety gloves protect your fingers and crossword answers - Pronunciation of letters in spanish - Standard costing exam questions - 1506 main north road salisbury sa 5108 - I'm still here poem - Child safety practice manual - How are babies made in the giver - Assignment: Regulation for Nursing Practice Staff Development Meeting - COMM THEORY - GENDER DIFFERENCES/LISTENING SKILLS - Candy first aid kit - Darwin's natural selection worksheet answers rabbit - Forecasting problems in operations management - Lean unit 2 answers - Network infrastructure design example - Lab equipment matching worksheet - Blue dream hotel via orti 7 c 35043 monselice - Derivatives using power rule worksheet answers - Str/581 - Introduction to healthcare science - At&t swot analysis 2015 - The danger of a single story analysis essay - Philosophy W5-Rough Draft of Signature Assignment - Reality vs appearance macbeth - Square and triangular numbers - Centurion d5 status light red - Ford car exploding gas tank - Which of the following statements about crafting a strategy to be competitively successful - Resistors in series and parallel circuits lab answers - The shannon weaver model - Intervention Plan Practice #1: Sample Learners - Mt albert postcode nz - American express investor day presentation 2019 - Standard Assignment 5 - Concert Review - Mcminn bridge club amersham - Business contingency and disaster recovery - Who is covered under employment act 1955 - COM303 Week 7 Discussion 18 - A pig's tale book - The dulac box plant produces 500 - What are the four strategic alternatives - Disney world informative speech outline - Paper - Mary and the angel - How to calculate approximate real rate of interest - Www thecoca colacompany com citizenship index html - Mcdonald's debt to equity ratio - Introducing organizational behaviour and management - Interaction design 5th edition pdf - Diagram of a rock - Cos in exponential form - She's come undone wally lamb sparknotes - In situ nick translation - Scientific method m&m lab answers - Direct address lead examples - Lake windermere water temperature