1) Using Excel, create a spreadsheet that displays the following information.
- Dave sold: 4 Red Widgets, 2 Green Widgets, and 5 Blue Widgets
- Sue sold: 2 Red Widgets, 5 Green Widgets, and 3 Blue Widgets
- Rick sold: 1 Red Widgets, 3 Green Widgets, and 4 Blue Widgets
- Helen sold: 2 Red Widgets, 3 Green Widgets, and 3 Blue Widgets
(Widget is a general term for an imaginary product. They could be anything)
2) You will want to include a title centered above the data and totals.
3) Create a stacked bar chart to display what each sales person has sold.
4) Create a Pie Chart displaying which widgets sales best.
5) Use Word to create a memo about why your widgets are the best and summarize the sales results.
6) Using Power Point Create a presentation using the charts created in Excel to create a short presentation on Widget Sales.