Access over 20 million homework & study documents

Cmr Final Workbook Exam Spring 2020

Content type
User Generated
Subject
Business
School
Miami University
Type
Homework
Rating
Showing Page:
1/37

Sign up to view the full document!

lock_open Sign Up
Showing Page:
2/37

Sign up to view the full document!

lock_open Sign Up
Showing Page:
3/37

Sign up to view the full document!

lock_open Sign Up
End of Preview - Want to read all 37 pages?
Access Now
Unformatted Attachment Preview
Copy Formulas and Chart 1. Yellow-shaded cells require formulas. The D9 formula must copy down column D. E9 formula must copy down column E. B17 2. Create a chart that places Sales on the primary axis, and Profit on the secondary axis. See the example below. Remember, if you are unsure of what "as a percent" means, just replace it with "divided by". Year Average Sales Profit 2013 $ 1,000 $ 354 2014 1,423 401 2015 1,698 407 2016 1,544 476 2017 2,091 652 2018 2,015 798 2019 2,308 806 2020 2,477 845 Profit as a This Year's Sales Percent as a Percent of of Sales Average Sales 35.4% 28.2% 24.0% 30.8% 31.2% 39.6% 34.9% 34.1% 6.9% 9.8% 11.7% 10.6% 14.4% 13.8% 15.9% 17.0% $ 14,556 $ 14,556 Sales and Profit $3,000 $900 $800 $2,500 $700 $2,000 $600 $500 $1,500 $400 $1,000 $300 $200 $500 $100 $- $2013 2014 2015 2016 2017 2018 2019 2020 Profit Sales Conditional Formatting Sort each table in Z to A order by Salesperson Create conditional formats for the total sales columns in the tables below For Version 1, use one of the stop light conditional formatting sets For Version 2, use one of the data bars or color scales conditional formatting sets Which of the two conditional formats do you think is better? Why? The data bars is better . This is because its acts as abar chart.Its length is equal to the value in the cell hence it is easeir dur comparasion analysis. Version 1 Salesperson Xanthus I. Serrano Veronica G. Sullivan Veda I. Herrera Theodore L. Mccall Divis ...
Purchase document to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Anonymous
Nice! Really impressed with the quality.

Studypool
4.7
Indeed
4.5
Sitejabber
4.4