ASSIGNMENT

Your work supervisor has given you the data below and has asked you to create an Excel file with the following details.

1. Copy the headings and values into a new spreadsheet
   1. Name the first worksheet Sales Data (copying the data below)
   2. Calculate total units sold for each product category (books, bicycles and clothing) for the previous five years
   3. Calculate the total 2018 revenue for all products
   4. Calculate the percentage of total revenue for each country
2. Create the following additional worksheets
   1. Unit sales by year
   2. 2018 Revenue by Product Type
   3. 2018 Revenue by Country
3. On the Unit Sales by Year worksheet insert a line chart for all three products over the past five years. (Note: You can create the line chart on the Sales Data worksheet and then cut and paste onto the Unit Sales by Year worksheet)
4. On the 2018 Revenue by Product Type worksheet, insert a clustered column chart (aka a histogram chart) showing revenue by books, bicycles and clothing for 2018
5. On the 2018 Revenue by Country worksheet, insert a pie chart that shows distribution of 2018 sales by country. (Note: it is not necessary to show the percentages, just the pie chart.)
6. Save the Excel file using the following naming convention: WS3_Last Name

	Units Sold	2013	2014	2015	2016	2017	2018
	Books			33842	42935	32859	41542
	Bicycles	8964	9175	9858	7611	14799	11372
	Clothing			19970	22478	19389	21870
	Sales Category	2018 Revenue
	Books	$1511799
	Bicycles	$6178213
	Clothing	$837088
	Total Revenue
	Country	2018 Revenue	% of total
	Canada	$993570
	France	$843120
	Germany	$1825750
	United Kingdom	$1067610
	United States	$3797050