Excel+Geography

=Population:= Below are two links about world population. List of countries by Population in 2005: http://en.wikipedia.org/wiki/List_of_countries_by_population_in_2005 List of countries by Population in 1907: http://en.wikipedia.org/wiki/List_of_countries_by_population_in_1907 1. Make an Excel worksheet titled World Population 2. Make these subtitles: Countries, 2005,1907 3. List 15 countries with the largest populations in 2005. 4. Type the populations for those countries in 2005. Type the populations for those same countries in 1907. 5. Merge cells on the main title. Bold and center all titles. 6. Make a bar graph comparing the ten countries with the highest population in 2005 & comparing population in 1907. 7. You should have 2 bars for each country and a legend for the years. Make sure the names of all the countries show. 8. Under the graph, describe how the total population of several countries has changed in 100 years. 9. How has the ranking of the countries 1-10 changed in 100 years? 10. How has the total population and the population ranking of the United Kingdom changed since 1907?

=Population of U.S. Cities= The chart at the right shows the ten most populated cities in the US as of the census on July 1, 2007. Below is a link showing cities in the US by population: http://en.wikipedia.org/wiki/List_of_United_States_cities_by_population 1. Make an Excel worksheet titled Large US Cities 2. Make these subtitles: City, State, Population 3. List the 15 cities with the largest population in 2007. 4. Then type the corresponding states and population. 5. Merge cells on the main title. Bold and center all titles. 6. Make a line graph showing the 10 cities with the highest population. 7. Make sure all the city names show. You do not need a legend. 8. Under the graph, give the population of Nashville and tell how it ranks. 9. Tell what other city in Tennessee is larger than Nashville and give its population. =Literacy Rates= To the right is a world map showing literacy by country. Below is a link to a list of countries by literacy rates in 2008. http://en.wikipedia.org/wiki/List_of_countries_by_literacy_rate 1. Make an Excel worksheet titled World Literacy Rates. 2. Make these subtitles: Rank, Country, Literacy Rate 3. List the 10 countries with the lowest literacy rate in column B. 4. Then type the corresponding ranks and literacy rates in columns A and C. 5. Merge cells on the main title. Bold and center all titles. 6. Make a column graph showing the 10 countries with the lowest literacy rates. 7. Make sure all the names show. You do not need a legend. 8. Under the graph, tell how the United States ranks in literacy and its percentage. 9. Tell how many countries have literacy rates above 95%. 10. Tell how many countries have literacy rates below 80%. 11. Which country's literacy rate surprised you? =Size of Continents= To the right is a world map. Below is a link to information about continents. http://www.worldatlas.com/aatlas/infopage/contnent.htm 1. Make an Excel worksheet titled Size of Continents in Sq. Km.. 2. Make these subtitles: Continents, Sizes 3. List the 7 continents by order of size. 4. Then type the size of the continents. 5. Merge cells on the main title. Bold and center all titles. 6. Make a circle graph showing the sizes of the 7 continents. 7. You must have a legend with the names of the continents. 8. Add data labels with percentage. 9. Under the graph, tell which is the largest continent. 10. Tell which is the smallest continent. 11. About how many times larger is North American than Australia?