Excel Spreadsheet Assignment

--------------------------------------------------------------------------------

I have an assignment that I'm not quite understanding how to do, and would like some clarification. I would appreciate anyone's help please. Here goes:

This is an Excel Spreadsheet Assignment.

The directions:

1. "Modify a spreadsheet to "include percentage use calculations of Internet use for shopping over the Internet for age, education level, and income category." (Only the Education Level Section's %'s are given).

2. "Create appropriate graphs to illustrate how the distribution of use of the Internet for shopping varies across age, income, and education level categories."


For example: Section1

Education Level/ Yes Have Used / No Have Not Used /% Using Internet to Shop/Pay Bills
-----------------------------------------------------------------------------------------
Less than HS / 598824 / 32354711 / 1.8%
HS Grad / 5104952 / 60930000 / 7.7%
Some College/No Degree/ 6613400 / 32290000 / 17.0%
Assoc. Degree / 7840540 / 38855612 / 16.8%
Bach. Degree / 9581979 / 22830000 / 29.6%
Masters Degree or Higher/ 5196040 / 10280934 / 33.6%

For the above section, the %'s are given, but for the next two sections (2nd section: Age), (3rd section: Household Income), the %'s are not given.


For example: Section2

Age / Yes / No / (this area is blank)
-------------------------------------------------------------------------------------
10-14 / 557160 / 19646353 / blank
15-19 / 1607513 / 18251159 / blank
20-24 / 2670194 / 15597505 / blank

and it continues all the way to age 75 and older.

Section 3:

Household Income / Yes / No / (this area is blank)
------------------------------------------------------------------------------------
Less than $5000 / 285666 / 4960488 / blank
$5000 to $7499 / 152549 / 4727749 / blank
$7500 to 9999 / 95264 / 4833534 / blank

and it continues all the way to $75000 or more.

So I would like to know how:

1. "Modify a spreadsheet to "include percentage use calculations for age, education level, and income category." (Only the Education Level Section's %'s are given).

2. "Create appropriate graphs to illustrate how the distribution of use of the Internet for shopping varies across age, income, and education level categories."