Intermediate Spreadsheet Concepts Exercise 2-3
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 Color, Number Formats and Color, 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.
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 Color, Number Formats and Color, 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.
