Create a spreadsheet using the following information.  You have been asked to prepare a spreadsheet using the results of a survey on the types of fizzy drinks people prefer.  3000 people where asked what their favorite fizzy drink is, and what their next preference would be if their favorite was not available. 

 
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