Click here to learn about our presidents.
ENTER THE FOLLOWING INFORMATION ON THE SPREADSHEET:
CELL A1 - President's Last Name
CELL B1 - President's Year of Birth
CELL C1 - President's Year of Death
The first two presidents have been done for you. You only have 41 more to go!
FOLLOW DIRECTIONS TO:
Highlight all the information on this spreadsheet. Copy and paste it into a Microsoft Works Spreadsheet. (Right click in Cell A-1 in MS Works and paste.)
Click on the gray header for Column A. Click insert>column.
Type the number one in cell A-1. Hit enter.
Click and drag down from cell A-1 to cell A-43 to highlight the whole empty column.
Click edit>fill series>number>OK.
Sort the list of presidents in alphabetical order.
Sort the list of birthdates in chronological order.
Type a formula in cell D-1 that will make the computer subtract each man's date of birth from his date of death. (Formulas always start with =). Hit enter.
Now sort column D to find out which presidents lived the longest and the shortest.