Weather - using weather.com find the appropriate weather information for the cities below:

• Brandon
• USA, city of your choice
• Central America, Panama, Howard AFB
• Central America, city of your choice
• South America, Ecuador, Manta
• South America, city of your choice (countries)
• Australia, Sydney
• Canada, city of your choice
• Europe, city of your choice
• Asia, city of your choice
• Africa, city of your choice

At the bottom of Column A on the spreadsheet, place the following labels and in Column B use the appropriate function:

• # of cities - count the number of cities (remember the rule...what must the cells contain that you count?)
• Average Temp - format the cell to 0 decimals
• Average Humidity - format the cell to 0 decimals

Formatting:

• title:  font size = 18 (row 1) and merge/center to column H
• column headings:  center and bold (row 2)
• font:  your choice, just not the default (may apply to all cells)
• border:  apply different line style, different color (around A1:H20)
• center temp, humidity, sunrise and sunset numbers

Place name in A20

Landscape

Create the charts.

Sort by Country (ascending), then by City (descending)...only sort once

Use conditional formatting for the following:

• Temps less than 60:  font to bold and blue, fill the shading as red
• Humidity greater than 65:  format your choice

To TURN IN:

• autofit your content in each column

• your name is on it

• it is fitting on one page

• print only the Data Sheet to the 4200

• put your printout in the red tray

• put the Weather file into the grading folder

• DELETE your web pages from the grading folder (if they have been graded)

Back

Place an If statement in column H to say if the temp is greater than 65, then "it is warm", else "it is cold"

Sort by Country (ascending), then by City (descending)...only sort once

Use conditional formatting for the following:

• Temps less than 60:  font to bold and blue, fill the shading as red
• Humidity greater than 65:  format your choice

 Create the charts.

To TURN IN:

• your name is on it

• it is fitting on one page

• print only the Data Sheet to the 4200

• put the Weather file into the grading folder

• DELETE your web pages and anything else in the grading folder