Watch the following Excel remediation videos:

Histograms in Excel
Pie Chart using a summary table in Excel
Time Series
Pareto Chart
An optional supplementary textbook is the OpenIntro Statistics, and you can read the concepts there.
Use the lab file WS2Practice to practice the Excel skills (includes an Excel hands-on video inside the spreadsheet as a link).
Use the file WS2Homework to demonstrate the Excel skills.
There are 60 points awarded for this exercise, 10 points for each problem.
When you have completed your assignment, save a copy for yourself and submit a copy to your instructor by the end of the workshop.