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 capstone

18/03/2021 Client: saad24vbs Deadline: 2 Day

Illustrated Excel 2016 | Modules 9-16: SAM Capstone Project 1a

C:\Users\akellerbee\Documents\SAM Development\Design\Pictures\g11731.png Illustrated Excel 2016 | Modules 9-16: SAM Project Capstone 1a

Breeze Smart Home Devices

AUTOMATING AND ANALYZING DATA

GETTING STARTED
Open the file IL_EX16_CS9-16a_FirstLastName_1.xlsm, available for download from the SAM website.

Save the file as IL_EX16_CS9-16a_FirstLastName_2.xlsm by changing the “1” to a “2”.

0. If you do not see the .xlsm file extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically.

1. To complete this SAM Project, you will also need to download and save the following data files from the SAM website onto your computer:

1. Support_IL_EX16_CS9-16a_Orders.accdb

With the file IL_EX16_CS9-16a_FirstLastName_2.xlsm still open, ensure that your first and last name is displayed in cell B6 of the Documentation sheet.

· If cell B6 does not display your name, delete the file and download a new copy from the SAM website.

If you see a Message Bar with a security warning at the top of the Excel window, click the Enable Content button in the Message Bar to enable the macros contained in the file.

This project requires you to use the Solver and the Analysis ToolPak add-ins. If these add-ins are not available on the Data tab in the Analysis group (or if the Analysis group is not available), click the File tab, and then click the Options button. In the left pane of the Excel Options dialog box, click the Add-Ins option. Click the Manage arrow, click the Excel Add-Ins option, and then click the Go button. In the Add-Ins dialog box, click the Analysis ToolPak and the Solver Add-In check boxes and then click the OK button. Follow any remaining prompts to install the Analysis ToolPak and Solver.

To complete this project you will need to display the Developer tab. To add this tab to the Excel Ribbon, click the File tab to open Backstage View and then click the Options button. In the Excel Options dialog box, click the Customize Ribbon option and click the Developer check box. Click the OK button to close the Excel Options dialog box and confirm that the Developer tab appears in the Excel Ribbon.

PROJECT STEPS
Will Deyes is the sales manager for Breeze Smart Home Devices, a growing company that sells smart devices such as lights, locks, plugs, and thermostats that can be controlled with a smartphone. Will has asked you to update a workbook to show recent sales data and identify trends. He has reviewed the workbook and inserted comments about its contents.

Switch to the Sales Overview worksheet and respond to a comment as follows:

a. Read Will’s comment in cell C5, and then change the value in cell C16 to $416,000 to respond to Will’s request.

b. At the end of Will’s comment in cell C5, press ENTER, and then add OK, it’s done. (including the period).

In response to a comment, modify the Total Sales by Region chart in the range D1:G12 as follows:

c. Read Will’s comment in cell C10, and then change the chart type to a Clustered Bar chart using the first chart option.

d. Add the data in the range B9:C9 to the chart.

e. Apply the Style 5 chart style to coordinate with other charts in the worksheet.

f. Change the colors of the chart to Monochromatic Palette 5 in the Monochromatic section of the Change Colors gallery. (Hint: Depending on your version of Office, the name of the color may appear as Color 9.)

g. Delete Will’s comment in cell C10.

Modify the axes to identify the data in the bar chart as follows:

h. Add 2019 Sales as the primary horizontal axis title.

i. Display the units on the primary horizontal axis in Thousands.

j. Add Inside End data labels to the bars.

k. Remove the legend from the chart.

To show trends in the quarterly sales data for each region, add sparklines to the worksheet as follows:

l. Add Column Sparklines to the range G15:G21 based on data in the range C15:F21.

m. Apply the Blue, Accent 5 sparkline color (9th column, 1st row of the Theme Colors palette) to coordinate with the colors in the other charts.

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:

Engineering Mentor
Math Exam Success
Professional Coursework Help
Coursework Help Online
Top Writing Guru
Top Essay Tutor
Writer Writer Name Offer Chat
Engineering Mentor

ONLINE

Engineering Mentor

I have read and understood all your initial requirements, and I am very professional in this task.

$57 Chat With Writer
Math Exam Success

ONLINE

Math Exam Success

You can award me any time as I am ready to start your project curiously. Waiting for your positive response. Thank you!

$124 Chat With Writer
Professional Coursework Help

ONLINE

Professional Coursework Help

Give me a chance, i will do this with my best efforts

$98 Chat With Writer
Coursework Help Online

ONLINE

Coursework Help Online

I am known as Unrivaled Quality, Written to Standard, providing Plagiarism-free woork, and Always on Time

$97 Chat With Writer
Top Writing Guru

ONLINE

Top Writing Guru

I have read and understood all your initial requirements, and I am very professional in this task.

$81 Chat With Writer
Top Essay Tutor

ONLINE

Top Essay Tutor

I have read and understood all your initial requirements, and I am very professional in this task.

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

Business - The Application of the Saul Alinsky Approach - Qnt 561 week 3 - Lcm music theatre syllabus - Character stuffing in computer networks - Sec questions starbucks about revenue recognition policy - Apple case study harvard business school - Molly's candle shop has several retail stores in the northeast - Marketing plan for solar energy company - 4 5 mastery problem accounting - Neiman marcus loyalty program - Doctor of orthodontics abbreviation - Altruism in society campaign and presentation - How to calculate dilution factor in spectrophotometer - Pink floyd leave those kid alone - Td - The tuff wheels was getting ready to start its development project for a new product - Roy vagelos attacks river blindness - Analysis of Crisis Communications - WEEK 4 DISCUSSION - Unit of earthquake measurement - No mobile phones in school - Iso 27001 mandatory documents - Bus 100 assignment 3 step 4 - Blobz guide to electric circuits - Room on the broom story powerpoint - Educational plan for a school - Taxonomy life's filing system crash course biology video answer key - 520 paper - Abandoned mines frequently fill with water - Zinc reacts with hydrochloric acid - Lobiondo wood and haber 2018 - Mfj screwdriver antenna controller - What are seven consequences of inaccurate coding and incorrect billing - Paper writing - Density and percent error worksheet answers - Technical English 8 - What is the largest capacity - Tips on Discovering Budget-Friendly Book Editing Services - How to make genogram on microsoft word - Form factor of full wave rectifier - Business - Superstorm Sandy health response 500 words due 10.18.2020 - Skin sensitivity lab toothpicks answers - Monthly retirement planning worksheet answers - 1988 martin sheen movie crossword clue - Design an algorithm - Strategically thinking, why might management opt for other than the most economical choice? - Case 43 american greetings excel - Frozen food business plan sample - Important scenes in v for vendetta - Followership and servant leadership compare and contrast army - Business law - Https theconnection sirva com agent training eld eld - Digital Forensics a boon for Investigation - Matlab easy question - Need ASAP - 200 WORDS - Standard operating procedure engineering examples - Akta prime user manual - Explain how big box retailers are logistical trendsetters - Bethany hamilton contributions to society - Small Groups - Project Strategic Management 479 - American History Discussion - Homework - Quickbooks new client checklist - Under armour case study 2017 - Australian consulate jobs overseas - Medication safety education for patients - Capsim global dna - Business name availability qld - 4 2 presentation marketing channel analysis assignment - How I Found a Custom Biography Writing Service with Insights from the Writing Community - Management information system case study - Determination of ascorbic acid in vitamin c tablets lab report - Palisade creek co comprehensive problem 2 - Royal children's hospital graduate nurse program - Difference between cbt and rebt - Logical Structures of Arguments Essay - Economics. - Oliver cromwell relationship with parliament - Cessna caravan type rating cost - Fair is foul and foul is fair literary technique - Tafe nsw code of conduct - Slope of distance vs time graph - Carbon dioxide experiment with lime water - CPO 2100 European Democracies discussion Board about chapter 3 - Paper - Reverse Logistics Revenue - Mount baw baw toboggan - Seattlecloud com account suspended error - We said feminist fairy tales not fractured fairy tales - Analysis of energy sources lab report - Fox body injector harness - Glasswire vs wireshark - Eng 122 week 1 content quiz - Clearly distinguish among temperature heat and internal energy - Nurses advancing telehealth services in the era of healthcare reform - Experiment 3: osmosis - direction and concentration gradients - Bushfire management overlay bmo