Int Spreadsheets EX 3


	Int Spreadsheets EX 3

Intermediate Spreadsheet Concepts Exercise 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 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

View Model Answer

| BODMAS Exercises | Word Exercises | Excel Exercises |