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

The csirt is also known as the ir reaction team - Atraumatic care in pediatric nursing - It planning at modmeters case study - Pyramus and thisbe worksheet - Discussion Board 1 - If budgets are to be effective, there must be - MAT - Oei management services inc - Peoplesoft uct ac za - Animal farm exam questions and answers pdf - How much acetic acid is in vinegar lab - Human Resource (tutorjass) - Magic science and religion malinowski summary - What h3o+ concentration corresponds to each ph value - Cell homeostasis virtual lab worksheet - All three models of urban structure - Speech - Mother teresa myer briggs - Sample six sigma project report - research questions - What primary goal does kroger company's quevision system help accomplish? - Management - Nursing. - Boston matrix for tesco - Emirates airlines marketing case study - After the accounts have been adjusted at april 30 - Dr pepper snapple group competitive advantage - Rain man doctor scene - Percent composition of aluminum acetate - Like niobe all tears - Cirque du soleil macau 2013 - Econometric. Stata. - Urasenke chanoyu handbook one - Red cabbage lab report - Natural gas condensate msds - SOCIAL MOVEMENT - Assignment: The Nurse Leader as Knowledge Worker - The importance of exit interviews to both parties cipd - How many islands in the philippines - Annotated Bibliography - That his virtues will plead - How to apply for an extension qut - Simpson taxonomy of psychomotor domain - All souls day origin - 4 phases of digestion - Ulsan university graduate admission - Define family resource management - Adelaide to robe bus timetable - Criminology exam questions and answers - Dr sassa calthrop owen - Prepare a cash budget for the first quarter - Q & Q D7 - Therapeutic communication nursing scenarios - Cuda fortran programming guide - Adobe digital learning services - +91-8890675453 love marriage problem solution IN Aizawl - Hershey case study analysis - Matlab code for huffman coding pdf - Statutory reporting requirements australia - Write a few sentences explaining what you think makes someone a hero. - In monopolistically competitive industries economic profits are competed - Rachel stassen berger bio - Volleyball line judge flag signals - Genogram nursing health history - The little seagull handbook inquizitive - Managing customer relationships a strategic framework free pdf - A pension fund manager decides to invest - Michael jordan arm span - Geography Assignment - Creation - Epidemiology for public health practice fifth edition - An integrated labor management system for taco bell - How to prepare master budget - Moctezuma and cortes guiding questions document a answers - Final Project - Fin 534 homework set 1 - Wk 16 - Handbook of informatics for nurses & healthcare professionals 6th edition - What is a nursing diagnosis - Human impact on ecosystems worksheet answer key - Natural selection lab answer key - Leadership and conflict management presentation - Marketers and senior managers like to see graphical - Common monomial factor meaning - Literary analysis essay questions - Website content brief template - What is 102f in celsius - Shadow health abdominal assessment subjective - What word does the adjective clause modify - Sugar skull art lesson plan - Gb shotgun cartridges australia - Dallat funeral directors ballycastle - FINANCE DISCUSSION QUESTION - Mcdonald's recently made productivity gains by cutting the - Example of variety seeking buying behavior - Rmit international application form - Ms groves has trays of paints for students - The Role of Nursing Leadership in Patient Care - Why did the teacher open a window company - Milieu therapy is based primarily on the principles of ______ psychology.