Reference no: EM131578884

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.