1) | Enter the raw data below, applying as many presentation Features (Font, Font Size, Font Colour, Number Formats and Colour, Cell Shading, Text Rotation, etc) to it as you wish. |
2) | Apply appropriate number formats to your numbers. |
3) | Center your spreadsheet horizontally on the page |
4) | Give your spreadsheet an appropriate title and center it across your spreadsheet. |
5) | Select the best page orientation for your spreadsheet. |
6) | Adjust the column width and row height to suit the layout you have selected. |
7) | Create formula's to calculate the percentage of the total number of people surveyed that preferred a specific fizzy drink as their first preference. |
8) | Create formula's to calculate the percentage of the total number of people surveyed that preferred a specific fizzy drink as their second preference. |
9) | Setup an appropriate header for this spreadsheet. |
10) | Setup a page number for this spreadsheet and place it in the footer. |
Drink | 1st Preference | 2nd Preference | ||
Pepsi | 342 | 403 | ||
Coca Cola | 359 | 367 | ||
7Up | 238 | 290 | ||
Lift | 215 | 190 | ||
Mountain Dew | 321 | 311 | ||
Fanta | 103 | 80 | ||
Ginger Beer | 180 | 380 | ||
Leed Lemonade | 217 | 120 | ||
Lemonade | 215 | 105 | ||
L&P | 425 | 414 | ||
Vanilla Coke | 203 | 67 | ||
Don't Knows | 182 | 273 | ||