be enclosed . The letter requires that you provide the following pieces of information :
Full Name and Address First Name Donated Item Value Number of tickets requested Deliverables
You will turn in one spreadsheet and two Word documents . You will locate the following files in DocSharing ( Lab Materials folder ): wk4 _ trust . txt and wk4 _ trust _ letter . docx . You will submit the following three items : one Excel spreadsheet ( Lab4 _ yourlastname . xlsx ), one letter ( Lab4 _ yourlastname . docx ), and one sheet of labels ( Lab4 _ yourlastname _ labels . docx ). When submitting the workbook and Word documents , provide a comment in the Dropbox comments area explaining what you learned from completing this lab activity .
B S T E P S
STEP 1 : Import text file into a spreadsheet and clean up data ( 20 points )
Download the Lab 4 , Step 1 Instructions .
A . Import the text file into Excel and save as lab4 _ yourlastname . xlsx . Import only the data you will need for your letter .
B . Separate the first and last names into two columns so that you may use the first name in a Mail Merge . Make sure the fields are named LastName and FirstName .
C . Check the accuracy of all data by using the Spelling tool in the Proofing group .