Soda Report and Pie Chart
Produce a report with a pie chart about soda.
A restaurant is trying to understand what are the most popular soda flavors. Over a week long period, the manager kept track of how many of each soda flavor was ordered. The manager asks you to use Microsoft Excel to produce a pie chart showing the results of the orders of soda over the 7 days. After you are done producing the pie chart, write a report in Microsoft Word.
Video #1 - Produce a pie chart using the data about soda. The data is listed below.
Coke 235
Diet Coke 150
Sprite 150
Root Beer 55
Orange 10
A restaurant is trying to understand what are the most popular soda flavors. Over a week long period, the manager kept track of how many of each soda flavor was ordered. The manager asks you to use Microsoft Excel to produce a pie chart showing the results of the orders of soda over the 7 days. After you are done producing the pie chart, write a report in Microsoft Word.
Video #1 - Produce a pie chart using the data about soda. The data is listed below.
Coke 235
Diet Coke 150
Sprite 150
Root Beer 55
Orange 10
Video #2 - Write a report in Microsoft Word and insert the pie chart at the bottom half of the report.
This report is to start with a general summary of what was done and the results. It should also have answers to the questions below.
Which soda of the five do you like best?
What soda flavors do you think that your family and friends like?
Do you think the restaurant should use Coke and Diet Coke or Pepsi and Diet Pepsi?
If manager was going to replace the orange soda with something else, what do you think it should be?
This report is to start with a general summary of what was done and the results. It should also have answers to the questions below.
Which soda of the five do you like best?
What soda flavors do you think that your family and friends like?
Do you think the restaurant should use Coke and Diet Coke or Pepsi and Diet Pepsi?
If manager was going to replace the orange soda with something else, what do you think it should be?