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

Independent project 3 4

29/12/2020 Client: saad24vbs Deadline: 3 days

() 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


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


Applied Sciences

Architecture and Design

Biology

Business & Finance

Chemistry

Computer Science

Geography

Geology

Education

Engineering

English

Environmental science

Spanish

Government

History

Human Resource Management

Information Systems

Law

Literature

Mathematics

Nursing

Physics

Political Science

Psychology

Reading

Science

Social Science

Home

Blog

Archive

Contact

google+twitterfacebook

Copyright © 2019 HomeworkMarket.com

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:

Helping Hand
Writer Writer Name Offer Chat
Helping Hand

ONLINE

Helping Hand

I am an Academic writer with 10 years of experience. As an Academic writer, my aim is to generate unique content without Plagiarism as per the client’s requirements.

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

Principles of advocacy in nursing - Bellmac cartons pty ltd - Smith pdc bit make up torque - Inverted conical tank volume - Why we need database backup - Are government securities assets or liabilities - Melbourne city tram map - Stryker power load system - C# multiple choice questions and answers - Write an article - Mk sentry consumer unit manual - ACCOUNTING FOR MANAGERS2 - Cpa australia study guide - Sample interpersonal process recording nursing - Week 7 plagiarism free - Sw023 ah whm 010 - Latex caption package download - HW 4 - Market leader audio files - Hospitality management in perth - Who are the 12 main greek gods - Supply and demand curve in excel - Hpi soap note example - Chick fil a swot analysis - Htm 08 03 nurse call - Pall hydrophobic vent filter - Career pathway planning worksheet - Ib economics paper 2 example - Is lpg denser than air - The hotel paris case study - Taeass502 assessment examples - Fass fuel system dealers - 2021 exam timetable vce - Land of invented languages - Calculate gdp as the value added in production pizzania - Mechanism of aniline to acetanilide - Desire under the elms synopsis - What is character construction - What is virtualization in cloud computing wikipedia - Examples of irony in the lottery by shirley jackson - W3 Discussion Question 1 - What color does ammonium carbonate burn - New lithographic equipment acquired at a cost of - Organic vs inorganic biology - Mkt 421 five step marketing research approach presentation - Pcos soap note - Consistent carb diet foods - What is op amp saturation - Prosystem fx engagement support - Nursingg - Maximum megahertz project case study - What is a situation audit - How to avoid getting swamped by the manman - Balanced chemical equation for combustion - PS490 Assignment 4 - Managerial accounting - Essay - Sorensen systems inc is expected to pay - How to solve genetic problems - Modern english to shakespeare translation - Module 3 discussion 3 Organizational Theory - Larson and gray project management 7th edition - Lock and key diagram - Border force jobs portsmouth - Marketing campaign simulation - Week 3 conflict resolution paper graded - Healthcare reimbursement - Bmgt 495 quiz 3 - Correctional leadership competencies for the 21st century - My Last Duches - Bus10 - Which is more precise a beaker or a buret - Colgate palmolive promotion strategy - The film experience 5th edition pdf - Ambiguity error on logical key multi match netsuite - Week 4 Journal - Stand up handup pair up poster - Case study 2 collaboration systems at isuzu australia limited - Funnel shaped residual plot - ATI written assignment - Op clear medical abbreviation - Bates pets paradise fyshwick - For My guy - Swallow the air quotes - One sentence summary examples - Is downloading from the pirates bay legal - An old black ram is tupping your white ewe analysis - Nursing portfolio table of contents - Annotated Bio - Math 201 liberty university - Moorebank sports club menu - PHYLOSOPHY - What does the bible say about abnormal behavior - Image processing literature review - Netgear jfs516 manual pdf - Assignment on financial statement ratio analysis - Curtin education building 501 - An introduction to literary criticism richard dutton pdf - Psy 110 university of phoenix - Causal comparative study definition