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 project 1

28/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.

n. Display a High Point marker in the sparklines to quickly identify the highest sales quarter for each region.

o. Change the High Point marker color to Orange, Accent 2 (6th column, 1st row of the Theme Colors palette) so that the high points use the orange accent color in the worksheet.

Make the Total Quarterly Sales - 2019 chart in the range I1:O12 easier to interpret as follows:

p. Add Sales as the primary vertical axis title.

q. Increase the font size of the primary vertical axis title to 12 pt.

r. Add Quarters as the primary horizontal axis title.

s. Increase the font size of the primary horizontal axis title to 12 pt.

Will wants to make the Quarterly Sales by Region chart easier to interpret. Format the clustered column chart in the range H14:O27 as follows:

t. Change the chart type to a Stacked Column chart grouped by Quarter.

u. Change the fill color of the Mid-Atlantic data series to Blue in the Standard Colors palette (8th column) to make the data series less prominent.

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:

Financial Solutions Provider
Quick Finance Master
Engineering Guru
Engineering Exam Guru
Online Assignment Help
Finance Homework Help
Writer Writer Name Offer Chat
Financial Solutions Provider

ONLINE

Financial Solutions Provider

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

$23 Chat With Writer
Quick Finance Master

ONLINE

Quick Finance Master

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

$45 Chat With Writer
Engineering Guru

ONLINE

Engineering Guru

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

$27 Chat With Writer
Engineering Exam Guru

ONLINE

Engineering Exam Guru

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

$55 Chat With Writer
Online Assignment Help

ONLINE

Online Assignment Help

Hello, I an ranked top 10 freelancers in academic and contents writing. I can write and updated your personal statement with great quality and free of plagiarism

$48 Chat With Writer
Finance Homework Help

ONLINE

Finance Homework Help

I will cover all the points which you have mentioned in your project details.

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

Integral maths topic assessment answers - Hectors world episode 1 - Mgt 330 week 2 discussion 1 - Math problem - Signs of being in an abusive relationship quiz - A.I "What is Artificial Intelligence?" - Automation anywhere certification questions - Political Science Week 2 Assignment - +91-8306951337 vashikaran specialist near me IN Raipur - Argos pet insurance reviews - Significant quotes in the glass castle - Square root transformation formula - Observation of mitosis in a plant cell - Health Essay - Antivirus inc expects its sales - Fosmid library construction kit - For Essays Guru - - Business forms and governance ppt - The opposite of 0 - Hay group reference level guide - Englishhh - How to calculate reading rate - Really quick turn - Http www bbc co uk news technology 34066941 - Animal farm chapter 5 summary - Tuesdays with morrie worksheet answers - Unit 4 Writing 1 & 2 - Math homework - Reaction of diborane with oxygen - Call pick up group - Foundation of digital marketing - State farm insurance studies show that in colorado - How to add ssr in amadeus - Networks and decision mathematics - Zappos case study - Chapter 7 case study answers - Alh3 lewis dot structure - The microscope slide rests on the __________ while being viewed - Is correlation coefficient r2 - Wiat iii sample report - Network diagram for a college - Daily 5 good fit book lesson - Under armour 10k report 2014 - Unit transformations homework 2 answer key - SuperBox S6 Ultra – Your Ultimate Streaming Companion - Whipps cross hospital ward map - BI - Iso 8573 1 pdf - Open ac uk tutorhome - Organizational structure - Tin fluoride is often added to toothpaste - Brief one page summary on the use of privately owned and run prisons in America - Key organizational enablers for effective demand management - Employee lookup fiori app - Lucian k. truscott iv net worth - Christ be our light easter vigil - Copyrights and wrongs assessment answers - A dry cleaner uses exponential smoothing to forecast equipment - Capella university clinical psychology - Life insurance sales pitch examples - Asml pas 5500 manual - What privileges are afforded to accounts with desktop user privileges? - Marvel parts inc manufactures auto accessories - Are helminths multicellular or unicellular - Texas tech mechanical engineering - Liebert nxc 40kva user manual - Middlesex county college application deadline - Hollate manufacturing case study solution - Manchester academic phrase bank - Elementary diff equations & bound value prob boyce - Equilibrium assignment answers - Cloud computing and business organizations - Standard deviation casio calculator - Experiment 1 determination of specific heat of a metal - Brown and furry caterpillar in a hurry - Determinant of an orthogonal matrix - Dr kazmi st albans - The rain came grace ogot symbolism - Branches of science matching activity worksheet - Europe natural vegetation map - How to tame a wild tongue citation - Researchers who are studying a new shampoo formula plan - Edrolo free practice exams - What percentage is a 4 on the ap exam - A quadrilateral with 2 pairs of parallel sides - Genesis 15 1 6 niv - Poems from different cultures - Zeus poseidon and hades - What is a passing grade at saint leo university - Derry of the past - Assumptions of orem's self care theory - Regulation for Nursing Practice Staff Development Meeting - Baby won't you tell me lyrics - Assignment 3 - Be prepared a practical handbook for new dads epub - Nursing roles graphic organizer gcu - Domestic companies facing competitive pressure from lower cost imports - Deliverable 06 R&W - Multisim digital circuits examples - #15