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

Excel guided project 3 3

07/01/2021 Client: saad24vbs Deadline: 10 Days

Excel - Chapter 3 - Creating and Editing Charts


Guided Project 3-1 Life’s Animal Shelter (LAS) is an animal care and adoption agency that accepts unwanted and abandoned domestic animals. For this project, you create expense charts and insert sparklines to help the agency track expenses for the first six months of the year. You also build a waterfall chart to graph cash flow for a month. [Student Learning Outcomes 3.1, 3.2, 3.3, 3.4, 3.5, 3.6, 3.7, 3.8]


DO NOT use the files below if you are completing an autograded SIMnet Project. Using the linked files below will prevent you from uploading and submitting your work in SIMnet. The files for all autograded SIMnet Projects MUST be downloaded from your class assignment.


File Needed: LAS-03.xlsx (/content/assets/InPractice2016/ex16_ip/documents/LAS-03.xlsx) [Student data files are available in the Library of your SIMnet account.] Completed Project File Name: [your initials] Excel 3-1.xlsx


Skills Covered in This Project


Create a chart object. Create a chart sheet. Apply Quick Layout and chart styles. Add and format chart elements. Change the chart type. Filter the data series. Insert a shape in a chart. Create and format a combination chart. Insert and format sparklines in a worksheet. Create and format a waterfall chart.


1. Open the LAS-03 workbook from your student data files and save it as [your initials] Excel 3-1.


2. Create a pie chart object.


a. Select the Jan-June sheet and select cells A5:A10. Press Ctrl and select cells I5:I10.


b. Click the Insert Pie or Doughnut Chart button [Insert tab, Charts group].


c. Select the 2D-Pie chart subtype.


3. Create a chart sheet.


a. Select the pie chart object.


b. Click the Move Chart button [Chart Tools Design tab, Location group].


c. Click the New sheet button.


d. Type Pie Chart in the text box.


+


+


+


+ +


+


+


+


+


https://www.coursehero.com/file/24469479/Guided-Project-3-1pdf/


Th is


stu dy


re so


ur ce


w as


sh are


d v ia


Co ur


se He


ro .co


m


https://www.coursehero.com/file/24469479/Guided-Project-3-1pdf/

e. Click OK.


4. Apply a chart style.


a. Click the More button [Chart Tools Design tab, Chart Styles group].


b. Select Style 12.


5. Edit and format chart elements.


a. Click the chart title element.


b. Click the Formula bar, type January through June Expenses, and press Enter.


c. Triple-click the new label in the chart and change the font size to 28 pt.


d. Click the legend element to select it and to deselect the title element.


e. Click the Font Size arrow [Home tab, Font group] and change the legend size to 12 pt.


f. Select the Chart Area element, the chart background.


g. Click the Shape Outline button [Chart Tools Format tab, Shape Styles group].


h. Choose Black, Text 1 as the color.


i. Click the Shape Outline button again.


3-57 Pie Chart sheet with format changes


j. Choose Weight and select 1 pt.


k. Click outside the chart background to see the outline (Figure 3-57).


6. Create a bar chart object.


a. Click the Jan-June sheet tab.


b. Select cells A4:G9 as source data, omitting the Rent expense.


c. Click the Quick Analysis button and select Charts.


d. Select Clustered Bar.


e. Point to the chart border to display a move pointer.


f. Drag the chart object so that its top left corner is at cell A13.


g. Point to the bottom right selection handle to display a resize arrow.


h. Drag the pointer to reach cell I30 (Figure 3-58).


3-58 Bar chart object sized and positioned


7. Change the chart type.


a. Click the bar chart object.


b. Click the Change Chart Type button [Chart Tools Design tab, Type group].


c. Click the Recommended Charts tab.


d. Choose Clustered Column in the left pane.


e. Click OK.


8. Filter the source data.


a. Click the column chart object.


b. Click the Chart Filters button in the top right corner of the chart.


c. Deselect the January, February, and March boxes.


d. Click Apply in the Chart Filters pane (Figure 3-59).


e. Click the Chart Filters button to close the pane.


9. Edit, format, and add chart elements.


a. Click the chart title object. https://www.coursehero.com/file/24469479/Guided-Project-3-1pdf/


Th is


stu dy


re so


ur ce


w as


sh are


d v ia


Co ur


se He


ro .co


m


https://www.coursehero.com/file/24469479/Guided-Project-3-1pdf/

3-59 Chart filters applied


b. Click the Formula bar.


c. Type Second Quarter Variable Expenses and press Enter.


d. Click the Chart Elements arrow [Chart Tools Format tab, Current Selection group] and choose Chart Area.


e. Click the Shape Outline button [Chart Tools Format tab, Shape Styles group].


f. Choose Black, Text 1 as the color.


g. Click the Shape Outline button again and choose Weight and 1 pt.


h. Click the Change Colors button [Chart Tools Design tab, Chart Styles group].


i. Choose Color 3 in the Colorful group.


j. Click the Chart Elements arrow [Chart Tools Format tab, Current Selection group] and choose Plot Area.


k. Click the Shape Fill button [Chart Tools Format tab, Shape Styles group].


l. Choose Gold, Accent 4, Lighter 80% as the color.


m. Click a worksheet cell.


10. Create a combination chart sheet.


3-60 Combo chart and a secondary axis


a. Select cells A9:G9. Press Ctrl and select cells A11:G11.


b. Click the Insert Combo Chart button [Insert tab, Charts group].


c. Select the Clustered Column-Line chart subtype.


d. Click the Move Chart button [Chart Tools Design tab, Location group].


e. Click the New sheet button, type Combo Chart as the name, and click OK.


f. Double-click the line marker in the chart.


g. Click the Series Options button in the Format Data Series task pane.


h. Select the Secondary Axis box in the task pane (Figure 3-60).


i. Close the task pane.


11. Edit and format chart elements.


a. Edit the chart title placeholder to Utilities Expense and Total Expenses.


b. Select the chart area.


c. Apply a 1 pt. Black, Text 1 outline to the chart area.


d. Click one of the column markers to select the data series.


e. Click the More button [Chart Tools Format tab, Shape Styles group].


f. Select Moderate Effect – Black, Dark 1 in the Theme Styles group.


g. Click the line marker.


h. Click the Shape Outline button [Chart Tools Format tab, Shape Styles group].


i. Choose Gold, Accent 4 as the color.


j. Click the Shape Outline button again and choose Weight and 3 pt (Figure 3-61).


12. Insert sparklines in the worksheet. https://www.coursehero.com/file/24469479/Guided-Project-3-1pdf/


Th is


stu dy


re so


ur ce


w as


sh are


d v ia


Co ur


se He


ro .co


m


https://www.coursehero.com/file/24469479/Guided-Project-3-1pdf/

3-61 Line and column formatted in combo charta. Click the Jan-June sheet tab.


b. Select cells B5:G9 as the data range.


c. Click the Column Sparkline button [Insert tab, Sparklines group].


d. Select cells H5:H9 for the Location Range and click OK.


e. Click the Sparkline Color button [Sparkline Tools Design tab, Style group].


f. Choose White, Background 1, Darker 50%.


3-62 Text box shape inserted in chart


13. Insert a shape in a chart.


a. Select the column chart object.


b. Click the More button [Chart Tools Format tab, Insert Shapes group].


c. Select the Text Box shape [Basic Shapes group].


d. Draw a text box like the one shown in Figure 3-62.


e. Type Utilities are to be removed from an updated chart per management request.


f. Drag a selection handle to size the text box shape if necessary.


g. Point to a border of the Text Box shape to display a four-pointed arrow and position it if needed.


14. Click a worksheet cell and press Ctrl+Home.


15. Create a waterfall chart object.


a. Select the Apr Cash sheet tab.


b. Select cells A5:B14. This data represents cash coming in and going out for April.


c. Click the Insert Waterfall or Stock Chart button [Insert tab, Charts group].


d. Select Waterfall.


16. Size and position a chart object.


a. Point to the chart border to display the move pointer.


b. Drag the chart object so that its top left corner is at cell C1.


c. Point to the bottom right selection handle to display the resize arrow.


d. Drag the pointer to cell L20.


17. Format chart elements.


a. Double-click the Net Cash column marker and then click the marker again to open the Format Data Point pane.


b. Click the Series Options button in the task pane and expand the Series Options group.


c. Select the Set as total box.


d. Triple-click the chart title placeholder text and type April Cash Flow.


e. Select the chart area and apply a 1 pt. black outline.


f. Click a worksheet cell and press Ctrl+Home.


18. Save and close the workbook (Figure 3-63).


https://www.coursehero.com/file/24469479/Guided-Project-3-1pdf/


Th is


stu dy


re so


ur ce


w as


sh are


d v ia


Co ur


se He


ro .co


m


https://www.coursehero.com/file/24469479/Guided-Project-3-1pdf/

Page(s) ID ex16_ip_03_gp_3-1


3-63 Excel 3-1 completed worksheets and charts


https://www.coursehero.com/file/24469479/Guided-Project-3-1pdf/


Th is


stu dy


re so


ur ce


w as


sh are


d v ia


Co ur


se He


ro .co


m


Powered by TCPDF (www.tcpdf.org)


https://www.coursehero.com/file/24469479/Guided-Project-3-1pdf/

http://www.tcpdf.org

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
University Coursework Help
Top Essay Tutor
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.

$100 Chat With Writer
University Coursework Help

ONLINE

University Coursework Help

Hi dear, I am ready to do your homework in a reasonable price.

$102 Chat With Writer
Top Essay Tutor

ONLINE

Top Essay Tutor

I have more than 12 years of experience in managing online classes, exams, and quizzes on different websites like; Connect, McGraw-Hill, and Blackboard. I always provide a guarantee to my clients for their grades.

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

Mohr circle excel template - Kelvin giormani sofa for sale - Sudarshan kriya side effects - 978 1506362311 - Pacific trails resort css - Intercultural communication film analysis essay - Dixell controller xr02cx manual - Economic Concentration Evaluation - Situation problem solution evaluation examples - Interpretive simulations hr management - An Extraordinary Experience - Plc based bottle filling system - Discussion Questions Media Impact 1-2 paragraph - Sony battling the marketing environment - Two factor theory of emotion - Eygpt and early Greece - Can someone help me with Week 2 Assignment in Principle of Marketing? - Flat stanley travel journal - Sears holdings swot analysis 2018 - Essay about china culture - Coca cola vs pepsi financial analysis - Employee discipline letter for absenteeism - Module 01 Assignment - Certified food scientist exam questions - Igcse biology scheme of work - 19 baton rouge drive mindarie - Character evolution essay examples - Assignment 2.1: Liberty Challenged in Nineteenth Century America Thesis and Outline - WK-7 - Captain van zanten last words - Module 05 Written Assignment - Final Project Submission - Gradualism vs punctuated equilibrium - Http www blueplanetbiomes org tundra htm - The new and everlasting covenant - Provide a brand analysis report on Nissan Leaf and the Tesla Model 3. - Heros journey structure - Capstone simulation help - Takeexamsonline - Why did kentucky fried chicken change to kfc - Preparing a buret for titration - Ict equipment list for office - Advertising's goal is to enhance - (Course Name) Security Architecture and design - Ecstasy of fumbling meaning - 16 700 in scientific notation - Chinn and kramer model - Implementation plan resource allocation - How to calculate stopping voltage - Bartels corp.produces wood carvings - Myenglishlab pearson intl rumba login - Religious literacy stephen prothero chapter summary - Aim institute of health and sciences - Metsec lattice beams brochure - Dorian majied - Factoring without recourse journal entry - Project 2 - Flight safety foundation alar - Cases in health services management 6th edition - African caribbean care group - Australian standards tiling falls - Discussion 1 250 words by 08/18/20 at 6:00 pm please add references and citations - Mariam operates a machine that weaves rugs - How to measure air pressure - Examples of chronosystem in child development - Attar of roses by tahira naqvi summary - Shadow health musculoskeletal interview guide - Document on marketing business strategy. needs reworking - Assignment - Which promotional activity will sell the most products - Humn 8660 - Argumentative Essay-Rough Draft (SLO 1-8) - Caesar cipher decoder c++ - Research Critiques and PICOT Statement Final Draft - Escape the ripper compound - Loading and unloading employment - Https ci3 googleusercontent com proxy - Agenda Setting - The african american odyssey volume 1 7th edition pdf - Why might fire extinguishers exhibit positive externalities - Can we feel the love tonight - Marine plastic pollution in asia - 500 words - Emmaus christian college term dates - Maria´s Project Plan - Case36999 - Dell sc420 spec sheetdell sc420 spec sheet - Child family and community 7th edition chapter 2 - I need a discussion - Comal county environmental health department - Irac example duty of care - Cause of fatigue aerobic system - What was howard schultz's original strategic vision for starbucks - Solidworks stress analysis tutorial - Sec 450 week 1 ilab - Solving fractional equations homework answers - Precise and Clear - Penn foster writing exam - The sea the sea analysis - Tri quad penta hexa hepta octa - Competitive strategies enabled by information systems