Working with Data Tables and Charts Practice.xlsx

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

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

View Full Document Right Arrow Icon
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!
Image of page 1

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

View Full Document Right Arrow Icon
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.
Image of page 2
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".
Image of page 3

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

View Full Document Right Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    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.

    Student Picture

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

  • Left Quote Icon

    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.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    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.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern