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

Which statement is true of the 1862 homestead act - A0 size in mm - Recycled plastic tiles machine - Inherit conflicts - Chunking refers to the process whereby: - Heart of darkness themes and symbols - Gibbs reflective cycle example essay business - Www technologystudent com wood - Business ethics case studies and selected readings 8th edition pdf - Balanced and unbalanced forces - Journal-200 words - Paper - Comparative balance sheet and income statement of any company - Bathroom floor slope to drain in australia - Number 14 - Advantages and disadvantages of system analysis and design - Mhhe virtual labs paramecium - How to input chinese characters in windows 7 - The dgi data governance framework - Bac si dien sunshine - Speech for vice captain - 0417 12 m j 16 ms - Driven to destruction cheats - Business process management (with SAP)assignment - MA GD1 - Propesa - Pictures of stitch fix clothes - Diageo case study capital structure - Celf 4 subtests explained - A warrantless search for evanescent evidence is permissible when - Accounting concepts are known as - WITBANK ABORTION CLINIC +27717852514 SAFE ABORTION PILLS FOR SALE IN SOUTH AFRICA & ABORTION CLINICS IN SHOSHANGUVE, MAMELODI, SUNNYSIDE - Case Study and Essay - Cultural studies multiculturalism and media culture kellner - Cruzan v. Director, Missouri Department of Health, 497 U.S. 261 (1990) - Caffeine solubility in hexane - Khalid mohammed abdul rahim net worth - Analyzing processor performance in computer architecture - Merthyr tydfil housing association - Disney theme park case study - Preston manor sixth form - On what basis are misdemeanors and felonies distinguished - Madurai kamaraj university textbooks - (DQ) Biz News - Consumer behavior - Problem cause solution speech examples - The theory and practice of mental health consultation - Cisco 5500 series wireless controller - A in diameter horizontal jet of water - Chapter 2 the market system and the circular flow - Effective or Ineffective Team member - Chicken egg production business plan - Discussion Response (AG) - English Comp I - Gravitational field strength on jupiter - Gold coast planning scheme - Bill rogers decisive discipline - Commercial spacelift operations - Levi strauss binary opposition - Similarities between tv and radio - Why is training a critical strategic issue for organizations - State machine diagram ppt - Aspt army - Forms of business organization with references - What are the strategic and technical security measures for good database security? one security model to properly develop databases for organizational security. Create a diagram of a security model - Social justice art lesson plans - Eagle arduino mega 2560 - Health Care Management - InfoTech in a Global Economy - 11 7 challenge problem accounting - How does jollibee affect economics in the philippines - As 2601 the demolition of structures - Lean production is a management philosophy and a pull system throughout the plant. - Iv x pv factorial design example - Nursing professional development review and resource manual 4th edition - Business - Ufo sightings in san jose ca - Under armour return on assets - Mise en scène meaning - Highfield awarding body for compliance habc - Code black documentary quotes - Cradle to kinder program - Unit VIII Journal Org BH - Peep for disabled persons - Evidence based practice for nurses schmidt and brown - Tom segura bellco theatre september 28 - Council clean up liverpool - Team Assignment: Organizational Performance Management Presentation - Freedom on my mind pdf - Water by the spoonful pdf - Worksheet on time zones - Setting up your own business reading answer - Module 2 Assigment - Perceptual distortion - Japanese Civilization - Procedural email - Meta Themes Draft - Charting method of note taking - Macbeth hires murderers to kill banquo quote - Lishman unit maudsley hospital - Marketing chapter 9 test questions