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.