5th Grade Excel - Texas Cities

 

Useful website -

https://www.tsl.state.tx.us/ref/abouttx/popcity5.html

1. Your assignment is to create a spreadsheet of the population of 10 Texas cities.
2. Use the map above and the internet to find your information.
3. Open Microsoft Excel
4. In cell A1 type - Texas Cities. In cell B1 type 2010 population and in C1 type 2011 population.
5. Then add up the populations to find the sum of Texas population.
6. Find the average, the minimum and maximum population.
7. Change the page orientation to Landscape
8. Click on Page Layout View and insert your name in the header.
9. Create a line chart.
10. Make sure your chart has a title
11. Print and save work in your folder. Also save your work in your Flash Drive.
12. Due on Thursday Nov 14 (5B) and Friday Nov 15 (5A). Late submission will be penalized - 10 points off for each late day.