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

Pick up motors excel

28/04/2021 Client: muhammad11 Deadline: 2 Day

Shelly 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”. o • 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. o If cell B6 does not display your name, delete the file and download a new copy from the SAM website. PROJECT STEPS 1. 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.) 2. Freeze rows 1 and 2. (Hint: Select cell A3 before freezing panes.) 3. Change the width of column A to 31.00. (Hint: Do not use AutoFit.) 4. Select the range B4:D4 and, using the Fill Handle, fill the range E4:G4 with consecutive months. 5. 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. 6. Using the Format Painter, copy the formatting from the range G5:G9 to the range H5:H9. 7. Copy the contents of the range B4:G4 to the range B12:G12. 8. Apply the Percentage number format with zero decimal places to the range B13:G13 and the nonadjacent cell B33. 9. Select the merged range A15:A27, and then rotate the cell contents to 90 degrees (Hint: The text should read from bottom to top). 10. 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. Shelly Cashman Excel 2016 | Module 3: SAM Project 1a 11. 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. 12. 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). 13. Add data labels to the 3-D pie chart using the Outside End style. 14. 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. 15. 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. 16. In the range H31:H32, update the Line Sparklines as described below: a. Change the Sparkline type to Column. b. 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.) 17. In the range A31:A32, increase the indent of the cell contents once.

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:

Professional Accountant
Accounting & Finance Specialist
Calculation Guru
Quick N Quality
Assignment Hut
Smart Tutor
Writer Writer Name Offer Chat
Professional Accountant

ONLINE

Professional Accountant

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

$15 Chat With Writer
Accounting & Finance Specialist

ONLINE

Accounting & Finance Specialist

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

$44 Chat With Writer
Calculation Guru

ONLINE

Calculation Guru

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

$44 Chat With Writer
Quick N Quality

ONLINE

Quick N Quality

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

$27 Chat With Writer
Assignment Hut

ONLINE

Assignment Hut

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

$43 Chat With Writer
Smart Tutor

ONLINE

Smart Tutor

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

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

Custom molds inc case study answers - Mechanical vibrations tutor - Homework - Lord of the flies multiple choice chapter quizzes - Zappos com developing a supply chain to deliver wow - Don marquis why abortion is immoral summary - Keynows - Two different stock exchanges in the united states - Bussiness HW - Southern cross ford toowoomba used cars - Dowling festing and engle 2013 - Who supported the heliocentric model - If a competitive market operates perfectly, it relies on - Geography Assignment - Unit 1 Assignment (HIS101) - 2.5 page summarized - Sea ray v drive problems - Ballroom dancing brisbane southside - Vygotsky's zone of proximal development - Security analysis - Why did john frémont and kit carson destroy a klamath indian village in 1846? - What is the scope of a survey - Software cost estimation ppt - All the king's horses kurt vonnegut summary - Ucl student services contact - Hull university application form - Disgusting hygiene makes gordon pull the fire alarm episode - Homage to my hips analysis - Ima statement of ethical professional practice citation - Statistics - Determination of the hardness of water lab report - Which of the following is a step in the preparation of a production cost report? - 4000 essential english words 3 pdf free download - What was the result of the child study movement - Visual merchandising in retail ppt - Jotun thinner no 7 msds - British council esol nexus - Macmillan palliative care unit sheffield - Discussion - I never sang for my father sparknotes - Milestone1 - Competitive priorities in operations management pdf - Pastoral prayer for valentine's day - Circuit construction kit simulation - Headphones and earbuds paper docx - Concept Analysis in the Nursing Field essay - Biology lab notebook example - Arduino write to csv - The advantages of intercultural communication skills in criminal justice - W1 - Implementing a Public Health Program - How many valence electrons does bromine have - Axe deodorant vs old spice - Case study - Hard candy fitness dvd - Cash flow exercises for students - Landstar carriers load board - 5 3 1 2 days a week - Mil dtl 24308 glenair - FIN/571: Corporate Finance - 143 bus timetable cairns - Isoball 3 level 25 - E commerce regulations 2002 - Briefly describe what the custodian does. - Legal environment ESSAY - Probate application form pa3 - Strayer center city - Ponder the root cause of phenomena and things - Circuit breaker ratings schneider - Experimental design worksheet iv dv controls and control groups - Bowen speech sound development - Latrobe library referencing tool - Interview paper - Help me finalize my 3 main points for my persuasive speech. I already wrote a few things. I need help finalizing DUE 9/18/2020 6pm pacific Usa time - Ntu chinese language course - Will smith pursuit of happiness speech - Erroll garner jazz project - Case Study 6 - Operations Security - Hcooh acid or base - Calculate volume of water - Forms of energy assignment - How to reference the bible chicago - Adafruit 32x32 led matrix - 6645 99 124 2986 - How is durable medical equipment dme reimbursed in the hhpps - Ethica and Legal Aspects of Nursing Practice . Course reflection - 1.6 mm corrosion allowance - Craig polles driving instructor - Hoppy's parts r us geraldton - Plymouth city council safeguarding - 5910_ASS 6 # REwork - Sgs parts plus kurri kurri nsw - How many faces does a coin have - Thinking through the past volume 1 - As 1851-2012 pdf free download - Theoretical and applied climatology impact factor - Consumer equilibrium marginal utility - Discussion#5 - Architecture as space bruno zevi pdf