Randolph Middle School

Technology Literacy

Sort video.


1. Create a NEW document in Excel.
2. Place your name in cell A!.
3. In the next row second column create the bold column titled First Name, the next column should be titled Last Name, continue with years he was president (2000-2004), hometown, state, birthday and finally party (Democrat, Republican, both, neither).
4.List all the Presidents information under the columns.
5. Create a new sheet named alphabetically and copy the Presidents information to that sheet.
6. Sort the Presidents alphabetical by last name.
7. Create a new sheet named year and copy the Presidents information to that sheet.
8. Sort the Presidents by the years they were President.
9. Create a new sheet named state and copy the Presidents information to that sheet.
10. Sort the Presidents by state.
11. Create a new sheet named birthday and copy the Presidents information to that sheet.
12. Sort the Presidents by birthday.
13. Create a new sheet named party and copy the Presidents information to that sheet.
14. Sort the Presidents by party.