Excel homework - Address List

Make an address list

• include the following columns:  first name, last name, address, city, state, zip phone, type,  full name
• note: type = F (for family), W (for work), S (for school), X (for friend)
• make each column a reasonable size for the data
• make at least one entry in the address column wrap
• sort first by type and then by last name.
• Put your name in the header
• Have the title "Address List" centered across all the columns (and have it be in the worksheet, not header)
• Put the page number, date and filename in the footer
• align everything to the left, even the zip code
• create the full name automatically column using the first and last name columns.
• fit to 1 page wide to print it.
• At the bottom, put a count of the number of people, using the count function
• If you can, show a count of each type.