Go to:  Level 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17

Level 6: Practice

Create a Form Letter, part one Challenge Exercise Open the sample Excel list, Friends and Family.xls When prompted, SAVE to My Documents Go to My Documents Double click on Friends and Family.xls to open the spreadsheet in Excel Review the Data   A B C D 1 FirstName LastName Company JobTitle 2 Todd Borek Bell-Borek Home Director 3 Mary McCrickard Charity Social Services Manager 4 Bonnie Bondy Brighton Towne Co Sales Associate   Sort the Data Select the entire spreadsheet by clicking on the gray square at the corner of the columns and rows Go to Data -> Sort Choose your topics from the drop down lists. Note: if the first row in your spreadsheet has labels, this is the Header Row. That's what Excel uses for the drop down boxes. If you do not have a header, you will only see Column A, Column B, etc.   more on the next page