Excel Address Book

Please complete this Address Book Exercise to get more experience in laying out a page in Excel. Please print it to hand in during the next class.

Here are the skills you need to complete the assignment:

Here is a brief overview of the assignment: /Excel homework.htm

Here is a step by step guide: Excel_address_book_guide.htm

These are the skills you will have when you have completed this exercise and the shopping list:

• All format cell options
• Copy cells
• mathematical formulas
• Sum function (?)
• Cell Borders
• Print layouts (column headings, fitting to one page, landscape/portrait, header/footer)
• Set titles for window (freeze panes)
• Set titles for printing (page setup)
• Fit to width in order to squeeze onto printing one page
• Hyperlink to a web site or e-mail address
• Sort
• If statement
• Concatenating text
• Merge cells