Homework Bis155 Lab 4 Of 7: Create Address Labels

Front 1

HOMEWORK BIS155 Lab 4 of 7: Create Address Labels

Back 1

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)

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.

Scenario/Summary

You work with the XYZ Corporation Charitable Trust allows you to
demonstrate 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 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.

Front 2

http://www.homeworkstudent.com/products/bis-155?pagesize=12

Back 2

http://www.homeworkstudent.com/products/bis-155?pagesize=12

Front 3

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.

Back 3

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.