term1 Definition1term2 Definition2term3 Definition3
Please sign in to your Google account to access your documents:
HOMEWORK BIS155 Lab 4 of 7: Create Address Labels
Create labels for the letters. The XYZ Corporation wishes to use mailing labels to address the envelopes. They own 8 1/2 x 11" sheets of label paper with 1" by 4" labels, which they purchased from Office Depot.
Download the Lab 4, Step 3 Instructions.
A. Create a new file for printing labels.
B. Merge data from your Excel spreadsheet into the new label document.
Submit your completed workbook and the two Word documents (merged letters and merged labels) to the Dropbox. Make sure you post a comment about what you learned when submitting the files.
3: Create Address Labels (15 points)
Scenario/Summary
You work with the XYZ Corporation Charitable Trust allows you todemonstrate your expertise with Excel. The trust is sponsoring an auction, and you have received a list of all donors who have contributed to this auction. The list was pulled from the Corporation's database as a comma separated text file. You have been asked to create a letter that will go out to each of the contributors that will accept their donation. Tickets to the event will be enclosed. The letter requires that you provide the following pieces ofinformation:
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.
http://www.homeworkstudent.com/products/bis-155?pagesize=12
http://www.homeworkstudent.com/ is the web's largest tutorial store. Currently we are providing homework tutorials for universities like Ashford, DeVry, Grantham, Phoenix, Strayer. The tutorials are compiled by experts in various fields of study.
Need help typing ? See our FAQ (opens in new window)
Please sign in to create this set. We'll bring you back here when you are done.
Discard Changes Sign in
Please sign in to add to folders.
Sign in
Don't have an account? Sign Up »
You have created 2 folders. Please upgrade to Cram Premium to create hundreds of folders!