CIS 120 – Introduction to Computer Applications
Assignment #4 – Word & Excel in Perfect Harmony
15 Points
Due by 5:30PM on Thursday, February 18, 2016
As a 2016 New Year’s resolution, you decide to send birthday cards to each of your family and friends.
Utilizing your newly acquired mail merge skills, perform the following:
Download “assignment_four_data.docx” from the Modules section of Canvas™
Part One: Labels [10]
1. Create an Excel workbook for your label mail merge. The column headings in the worksheet must be the
following: [1]
Last Name First Name Address 1 Address 2 City State Zip Code
2. Populate the worksheet with actual or fictitious data. You must have at least 15 rows. You must also name the
tab “mailmerge”. [3]
3. Create a label mail merge using Avery 5160 labels. The labels must be centered, Cailbri font, 11 point, bold, laid
out accordingly: [4]
Last Name, First Name
Address 1
Address 2
City, State, Zip
4. Save the sheet of labels to a new document called “labels_lastname” (ex: labels_kleine.docx)[1]
5. Autofit the worksheet and save the workbook as “mailmerge_lastname” (ex: mailmerge_kleine.xlsx) [1]
Part Two: Form Letter [5]
Utilize the “assignment_four_data.docx”, found in the Modules section of Canvas™, to create a recruitment letter for
Todd’s fall 2016 section of CIS-120.
6. Replace all items highlighted in green with the information from one record of your created worksheet in part
one. [3]
7. Format, if necessary, the document to remove all green and blue highlighting [1]
8. Save the letter as a new document and call it “formletter_lastname” (ex: formletter_kleine.docx) [1].
Upload all three items (Labels, Form Letter and Workbook_ to Canvas™.