Excel: Winter Olympics Survey
•Survey 25 people about their favorite Winter Olympics Sport to watch on TV. 2 pts
•Use a spreadsheet to display a list of sports, votes for each sport, and percentages. Include totals (see below). Outline table and cells with borders. 3 pts.
•Totals and percentages should be calculated using functions. For example,
=Sum(B10:B24) (=B10/B25) 5 pts.
•Format Percentages to the hundredths place. 2 pt.
•Insert Chart (make either a pie chart or a bar graph) 3 pts.
•Change the fill of one slice of the pie / bar fill effect to a pattern. 2 pts
•Add a title to the page using word art. 1pt.
•Add an appropriate graphic to page. 1pt.
•Named correctly (Last_first Graph) and turned in. 1pt.