Working with Data Tables and Charts Practice.xlsx

# Working with Data Tables and Charts Practice.xlsx - Samsung...

• 12

This preview shows pages 1–4. Sign up to view the full content.

Samsung Corporation Sales (Millions of Dollars) 2008 to 2017 2017 2016 2015 2014 2013 2012 2011 2010 Sales 97849 93723 89943 82484 88437 87440 87960 85692 Net Inco 41863 36978 43150 38760 34569 38350 39021 40773 Net Profit Margin Sales Gro 4.00% Net Inco 8.62% % Change in Sales Sales Gr #VALUE!

This preview has intentionally blurred sections. Sign up to view the full version.

2009 2008 83459 80420 36295 27681 Instructions: 1. Format the table so that the data is easily readable. formatting to differentiate between the column header 2. Format the data in the rows, "Sales" and "Net Incom 3. In row 7, Net Profit Margin for 2017 = (Net Income f Express the result as a percentage. Copy this formula a 4. In row 10, the % Change for 2017 = (Sales for 2017)/(Sale a percentage. Copy this formula across row 7, except for ce since there is no data for the sales in 2007. 5. Now that these calculations have been made, cell B11 wi 6. In cell L4, enter a new column header titled, "Trend". Ma consistent with the other column headers. 7. Create sparklines in column L to demonstrate the trends the "Insert" tab, then choose "Line". In the dialog box that the data range, check the location (destination) cell, then cli 8. Create a bar chart below the data table to show the Sales and the Millions of Dollars on the vertical axis. Choose an a a legend. 9. Create another chart that will demonstrate the trends ov a Scatter Chart with the Sales Income on the horizontal ax the vertical axis. Choose an appropriate chart title and inclu 10. Save and proceed to the second worksheet.
Make sure that you add some rs and the financial data. me" as currency. for 2017)/(Sales for 2017). across row 7. es for 2016). Express the result as ell K10. This cannot be calculated ill correct itself. ake sure that the formatting is in rows 5 - 7. To do this, click on pops up, highlight cells B5:K5 for ick on "OK".

This preview has intentionally blurred sections. Sign up to view the full version.

This is the end of the preview. Sign up to access the rest of the document.
• Fall '15
• Victor

{[ snackBarMessage ]}

### What students are saying

• As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

Kiran Temple University Fox School of Business ‘17, Course Hero Intern

• I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

Dana University of Pennsylvania ‘17, Course Hero Intern

• The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

Jill Tulane University ‘16, Course Hero Intern