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

Shelly cashman excel 2016 module 3 sam project 1a

22/11/2021 Client: muhammad11 Deadline: 2 Day

Shelly Cashman Excel 2016 | Module 3: SAM Project 1a

C:\Users\akellerbee\Documents\SAM Development\Design\Pictures\g11731.pngShelly Cashman Excel 2016 | Module 3: SAM Project 1a

Pick Up Motors

WORKING WITH LARGE WORKSHEETS, CHARTING, AND WHAT-IF analysis

GETTING STARTED
Open the file SC_EX16_3a_FirstLastName_1.xlsx, available for download from the SAM website.

Save the file as SC_EX16_3a_FirstLastName_2.xlsx by changing the “1” to a “2”.

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

With the file SC_EX16_3a_FirstLastName_2.xlsx still open, ensure that your first and last name is displayed in cell B6 of the Documentation worksheet.

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

PROJECT STEPS
Charlie is a salesman at Pick Up Motors car dealership. He is performing a detailed analysis of his sales for the first half of 2018, including representing his sales and commissions with graphs.

Switch to the 2018 Jan-Jun Sales worksheet, and then remove the panes from the worksheet. (Hint: Deselect the Split option from the View tab.)

Freeze rows 1 and 2. (Hint: Select cell A3 before freezing panes.)

Change the width of column A to 31.00. (Hint: Do not use AutoFit.)

Select the range B4:D4 and, using the Fill Handle, fill the range E4:G4 with consecutive months.

In cell H5, create a Column Sparkline based on the data in the range B5:G5. Copy the Sparkline you created in cell H5 to the range H6:H9.

Using the Format Painter, copy the formatting from the range G5:G9 to the range H5:H9.

Copy the contents of the range B4:G4 to the range B12:G12.

Apply the Percentage number format with zero decimal places to the range B13:G13 and the nonadjacent cell B33.

Select the merged range A15:A27, and then rotate the cell contents to 90 degrees (Hint: The text should read from bottom to top).

In the stacked column chart (with the title Monthly Sales per Vehicle Type), add Month as the primary horizontal axis title and Sales Amount as the primary vertical axis title.

In the stacked column chart (with the title Monthly Sales per Vehicle Type), change the number format of the vertical axis to Accounting style with zero decimal places.

In the 3-D pie chart (titled Monthly Sales Contribution to Six-Month Sales Total) change the chart style to Style 1 (1st column, 1st row of the Chart Styles palette).

Add data labels to the 3-D pie chart using the Outside End style.

Charlie wants to calculate his gross monthly sales commissions. The rule is that he receives a commission of 2.5% of his total monthly sales if he sold more than $400,000 worth of vehicles. Otherwise, he only gets 1.5% of his total monthly sales amount.

In cell B31, create a formula using the IF function to check whether the value of cell B9 is greater than 400000.

a. If this condition is true, the function should multiply cell B9 by 2.5% to determine Charlie’s commission. (Hint: For the if true value, use B9*0.025.)

b. If this condition is false, the function should multiply the value in cell B9 by 1.5% to determine Charlie’s commission. (Hint: For the if false value, use B9*0.015.)

Copy the formula in B31 to the range C31:G31.

After deductions, Charlie’s net monthly commission is only 85% of his gross monthly commission.

In cell B32, create a formula that multiplies the value of cell B31 (Charlie’s gross monthly commission) by the value of cell B33 (Charlie’s net commission percentage). Use an absolute reference to cell B33 (because the net commission percentage won’t change) and a relative reference to cell B31.

Copy the formula in cell B32 to the range C32:G32.

In the range H31:H32, update the Line Sparklines as described below:

c. Change the Sparkline type to Column.

d. Change the Sparkline style to Sparkline Style Dark #4 (4th column, 5th row of the Sparkline Styles palette [Mac Hint: 7th column, 4th row]). (Hint: Depending on your version of Office, the Sparkline style may appear as Black, Sparkline Style Dark #4.)

In the range A31:A32, increase the indent of the cell contents once.

Charlie’s goal is to make a net commission of $60,000 for the second half of 2018 (July through December), using the estimate that his gross commission rate will be an average of 2% (cell B37) across the second half of the year.

Select cell B39, and then use Goal Seek to determine what value of cell B36 (Estimated 6 Month Sales Total) is necessary to set the value of cell B39 to 60000. Leave the result of the Goal Seek analysis as the new value of cell B36.

In cell B40, insert a formula using the NOW function to enter the system current date into the cell, and then apply the Short Date number format (e.g., 3/15/2019).

Use the Recommended Charts tool to create a Clustered Column chart based on the range A30:G32 with the following options:

e. Move the chart to its own chart sheet, and then enter Commissions 2018 as the name of the new chart sheet. If necessary, reposition the worksheet so it is located before the 2018 Jan-Jun Sales worksheet.

f. Use Sales Commissions - January to June 2018 as the chart title.

g. In the clustered column chart add Month as the primary horizontal axis title and Commission as the primary vertical axis title.

Your workbook should look like the Final Figures on the following pages. (The value in cell B36 generated by the Goal Seek analysis has been intentionally blurred in Final Figure 1.) Save your changes, close the workbook, and then exit Excel. Follow the directions on the SAM website to submit your completed project.

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:

Math Guru
Math Specialist
Buy Coursework Help
Accounting Homework Help
Smart Accountants
Peter O.
Writer Writer Name Offer Chat
Math Guru

ONLINE

Math Guru

As an experienced writer, I have extensive experience in business writing, report writing, business profile writing, writing business reports and business plans for my clients.

$31 Chat With Writer
Math Specialist

ONLINE

Math Specialist

I have read your project details and I can provide you QUALITY WORK within your given timeline and budget.

$18 Chat With Writer
Buy Coursework Help

ONLINE

Buy Coursework Help

Being a Ph.D. in the Business field, I have been doing academic writing for the past 7 years and have a good command over writing research papers, essay, dissertations and all kinds of academic writing and proofreading.

$24 Chat With Writer
Accounting Homework Help

ONLINE

Accounting Homework Help

I have done dissertations, thesis, reports related to these topics, and I cover all the CHAPTERS accordingly and provide proper updates on the project.

$28 Chat With Writer
Smart Accountants

ONLINE

Smart Accountants

Being a Ph.D. in the Business field, I have been doing academic writing for the past 7 years and have a good command over writing research papers, essay, dissertations and all kinds of academic writing and proofreading.

$26 Chat With Writer
Peter O.

ONLINE

Peter O.

I will be delighted to work on your project. As an experienced writer, I can provide you top quality, well researched, concise and error-free work within your provided deadline at very reasonable prices.

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

Adding two cosine functions - Response - Michael and rose chaney - Taylor classical mechanics chapter 10 solutions - Wizard sv gel and pcr clean up system - Graham woodhouse conveyancing burnie tas - CHRISTIAN SERVANT LEADERS - Human Physiology Unit 2 Exam - A21 fault on worcester boiler - Biblical meaning of the name tracey - Salvation army international mission statement - Ashworth college medical coding - A job order cost sheet for ryan company is shown below. - Math help - Course designer job description - Fitness test for power - Resurrecting sex resolving sexual problems and rejuvenating your relationship - La plaza cataluña es pequeña y está rodeada de callejones (surrounded by narrow streets). - Supernode analysis with dependent source - Examples of irony in the lottery by shirley jackson - Scaled instruments for mass - “Opposites attract,” - Business Accounts - Cell city phone specials - Walking with the wind john lewis sparknoteswalking with the wind john lewis sparknotes - Principal component analysis python pandas - Explain Nola Pender's model and how can you apply it to your nursing practice. Explain in 150 words - Fundamentals of small group communication - Kroger 5s of key retailing - Din tai fung liquidation - Cal g to kcal g - 5 - Antisocial Personality Disorder - Frito lay assessment test answers - Charles sturt university timetable - Welfare principle in uganda - Leadership - Systematic and random error examples - Orthopedic soap note example - Edith jacobson vsim - ¿sabes? el concierto al aire libre fue un éxito. yo creía que (1) , pero hizo sol. - Jamieson medical clinic mortlake - Genius child langston hughes - Colchester borough council planning - 25639 larkins street southfield mi - The humanities volume 1 7th edition pdf - Toyota prius target market segment - Patent kind codes by country - Aqa history grade boundaries - During air cooling of oranges grapefruit and tangelos - Sydney water backflow web lodgement - Soweto gospel choir darwin entertainment centre 17 july - Professional Nursing and State-Level Regulations - Galileo projectile motion analysis - Plan of care for a client who has gastroenteritis ati - Batten spacing for plasterboard ceiling - Death of a salesman soliloquy - Positive risk examples in software project - What is the confidence interval for the population mean muμ - Hyperbole in julius caesar - Aseba youth self report - University of montana villages - Class status and party - My singing monsters dawn of fire breeding candelabra - The test scores of 32 students are listed below - Python coding help - Night father-son relationship essay - Obai sparta - Sarah orne jewett biography - Formulating leadership part ii powerpoint - Ikarus c42 build manual - What is information deficiency - Capricorn coast netball association - Mary and kay inc a distributor of cosmetics throughout florida - Help needed - Labeled parts of a microscope - Capital budgeting analysis is very important because it - Recurrence relation for compound interest - Pizza pricing strategies - Tutorial 4 case problem 1 sky dust stories - Defy gemini petit chef multifunction thermofan oven manual - Toward a monopoly horizontal and vertical integration answers - Armstrong and miller brabbins and fyffe - Lumo energy gas rates - Dpd formularz reklamacyjny pdf - Pglo plasmid transformation e coli - Www rjframing com au - The intersection of the wbs and the obs is called the - New general mathematics pdf free download - Discussion - Anth journal - Texas assessment practice the poor and their betters answers - American business women's association - WEEK 1 DISCUSSION - Accounting chapter 11 comprehensive problem 3 - Communicating effectively with aboriginal and torres strait islander people - Basketball player evaluation form - Who is the famous entrepreneur - 11 cadorna street mowbray - 3 Minute Research Report