Homework answers / question archive / New Perspectives Word 2016 | Modules 5–7: SAM Capstone Project 1a Addams Opera Company COMPLETING A REPORT AND PERFORMING A MAIL MERGE GETTING STARTED ? Open the file NP_WD16_CS5-7a_ FirstLastName _1

New Perspectives Word 2016 | Modules 5–7: SAM Capstone Project 1a Addams Opera Company COMPLETING A REPORT AND PERFORMING A MAIL MERGE GETTING STARTED ? Open the file NP_WD16_CS5-7a_ FirstLastName _1

MS Word

Share With

---

New Perspectives Word 2016 | Modules 5–7: SAM Capstone Project 1a

Addams Opera Company

COMPLETING A REPORT AND PERFORMING A MAIL MERGE

GETTING STARTED

?

Open the file

NP_WD16_CS5-7a_

FirstLastName

_1.docx

, available for

download from the SAM website.

?

Save the file as

NP_WD16_CS5-7a_

FirstLastName

_2.docx

by changing the

“1” to a “2”.

o

If you do not see the

.docx

file extension

in the Save As dialog box, do not

type it. The program will add the file extension for you automatically.

?

To complete this Project, you will also need to download and save the following

support files from the SAM website:

o

Support_NP_WD16_CS5-7a_Audience.xlsx

o

Support_NP_WD16_CS5-7a_Revenue.xlsx

o

Support_NP_WD16_CS5-7a_Notice.docx

?

With the file

NP_WD16_CS5-7a_

FirstLastName

_2.docx

still open, ensure that

your first and last name are displayed in the footer.

o

If the footer does not display your name, delete the file and download a

new copy from the SAM website.

PROJECT STEPS

1

You are creating a form letter with an enclosed report to send to members of the

Addams Opera Company Foundation, an organization supporting opera in

Providence, Rhode Island.

To add interest to the document, apply the

Lines (Simple)

style set, which

formats headings using an underline.

1.

In the first body paragraph of the letter, in the sentence beginning “Your

continuing support...” and ending “...eastern New England.”, use the Thesaurus

to replace the word “fineness” with a synonym that starts with the letter “e”.

2.

Format the list of Board of Directors members and their roles (beginning

“Jonathan Colucci” and ending “Member at large”) by setting a left tab stop at

2.5"

using the

4____

solid line leader option to make the list easier to read.

3.

On page 3, accept or reject the tracked changes as follows:

a.

In

the

first paragraph after the heading “Strategic Highlights”, accept the

change.

b.

In the bulleted item beginning “La Boheme”, reject the change.

c.

Accept the remaining changes in the document.

4.

Turn on Track Changes and display

All Markup

for review. On page 4, apply the

Heading 1

style to the heading “Financial Highlights”.

5.

On page 4, after the “Addams Opera Company” heading, apply

italic

to the

three paragraphs containing the name “Ryan Edwards”, Ryan’s position and

title, and the organization’s web address.

6.

Turn off Track Changes. Read the first comment in the document, and then

continue editing as follows:

a.

Use

Microsoft

Excel to open the workbook

Support_NP_WD16_CS5-

7a_Audience.xlsx

, available for download from the SAM website.

b.

In the New Patrons worksheet,

copy cells A2:B6

.

c.

Return to the file

NP_WD16_CS5-7a_

FirstLastName

_2.docx

, and then

move the insertion point to where Ryan’s comment instructs you to insert

the audience data.

d.

Use the Paste Special feature to embed the worksheet selection in the

Word document as a

Microsoft Excel Worksheet Object

because the

data in the source file is unlikely to change.

e.

Modify the embedded worksheet by changing the number in cell B5 to

13,000

to use accurate data.

7.

Read the next comment in the document, and then continue editing as follows:

a.

Use Microsoft Excel to open the workbook

Support_NP_WD16_CS5-

7a_Revenue.xlsx

, available for download from the SAM website.

b.

In the Operating Revenues worksheet,

copy the 3-D pie chart

.

c.

Return to the file

NP_WD16_CS5-7a_

FirstLastName

_2.docx

, and then

move the insertion point to where Ryan’s comment instructs you to insert

the chart.

d.

Link the chart to the document using the destination theme because the

data in the source file is likely to change.

8.

Delete all of the comments in the document because they are no longer

needed, and then display

No Markup

for review.

9.

Create and apply a new style as follows to draw attention to text:

a.

On page 4, apply the font color

Lavender, Accent 4, Darker 50%

(8

th

column, 6

th

row of the Theme Colors palette) to the “Special Programs”

heading.

b.

Change the character spacing of the “Special Programs” heading to

Expanded

by

1.5 pt.

c.

Save the formatting of the “Special Programs” heading as a new style

using

Notes

as the name.

d.

Apply the new

Notes

style to the “Addams Opera Company” heading.

2

On page 4, convert the four paragraphs describing the educational efforts

(beginning “Adult programs” and ending “15,400”) to a table with two columns

by separating the text at each tab.

10.

Insert a new header row at the beginning of the table, and then enter the text

shown in bold in Table 1 below.

Table 1: Header Row

Educational Program

2018

11.

Insert a column to the left of the “2018” column, and then enter the text shown

in bold in Table 2 below.

Table 2: New Column

Header row

2017

Row 2

2

Row 3

3

Row 4

6

Row 5

10,000

12.

Format the header row using

bold

for the text and

Lavender, Accent 4,

Lighter 60%

(8

th

column, 3

rd

row of the Theme Colors palette) for the shading.

13.

In the paragraph after the

table

, format the word “Notice” as a hyperlink that

targets the document

Support_NP_WD16_CS5-7a_Notice.docx

, available for

download from the SAM website.

14.

At the beginning of page 4, select the first word in the paragraph before the

chart (“The”), and then insert a bookmark using

Revenue

as the name.

15.

In the second paragraph on page 1, in the sentence beginning “As shown in...”

and ending “...endowment support.”, format the text “chart” as a hyperlink

linked to the “Revenue” bookmark.

16.

On page 2, move the insertion point to the blank paragraph before the page

break

, and then insert a table of contents as follows:

a.

Insert a custom table of contents.

b.

In the Table of Contents Options dialog box, change the TOC level of the

Notes style to

2

.

c.

In the Table of Contents Options dialog box and Table of Contents tab,

accept all other defaults, and then finish inserting the table of contents in

the document.

17.

On page 1, start a mail merge, and then select

Letters

as the type of main

document. Next, type a new recipient list as follows:

a.

Customize the columns by deleting the

Company Name

,

Country or

Region

, and

Work Phone

fields.

b.

After the

E-mail Address

field, add a new field using

Production

as the

name.

c.

Enter the recipient information shown in bold in Table 3 below.

d.

Save the data source using a name of your choice.

Table 3: Recipient Information

Title

Ms.

First Name

Emma

Last Name

Vogel

Address Line 1

1190 Pine Street

Address Line 2

Apt. 202

City

Providence

State

RI

ZIP Code

02904

Home Phone

(401) 555-1227

Email Address

vogel@mail.cengage.ne

t

Production

La Traviata

18.

At the beginning of the letter, delete “[INSIDE ADDRESS]”, but not the

paragraph mark, and then insert the eight merge fields shown in Figure 1 on the

next page. Include the paragraph marks, punctuation, and spaces between the

merge fields as shown.

Figure 1: Merge Fields for the Inside Address

19.

In the greeting line, delete “[TITLE]”, and then insert the Title merge field. Next,

delete “[LAST NAME]”, and then insert the Last_Name merge field.

20.

In the paragraph after the greeting line, delete “[PRODUCTION]”, and then

insert the Production merge field.

21.

In the paragraph that begins “You will soon...”, delete “[EMAIL ADDRESS]”, and

then insert the Email_Address merge field.

22.

Complete the mail merge as instructed in the lettered steps below. You will

merge to a new document and then copy the contents of the merged file to the

bottom of your original document, so that all of your assignment appears in the

same file.

a.

Finish and merge all records to a new document.

b.

In the new document

Letters1.docx

, which contains the merged form

letter, press

CTRL+A

to select all contents in the document, and then

copy the merged form letter to the Office Clipboard.

c.

In the file

NP_WD16_CS5-7a_

FirstLastName

_2.docx

, move the

insertion point to the blank paragraph at the end of the document, insert

a page break, and then paste the merged form letter into the main

document.

d.

To remove the extra blank page at the end of your main document, delete

the section break. Verify that the pasted merged form letter appears on

pages 5–8 of the file

NP_WD16_CS5-7a_

FirstLastName

_2.docx

, and

then turn off the preview of the mail merge results if the preview is on.

Close the new, merged document without saving it.

Your document should look like the Final Figure on the following pages. Save your

changes, close the document, and then exit Word. Follow the directions on the SAM

website to submit your completed project.

Note: When opening your Graded Summary report for this Project, you may be prompted

to Select From “Office Address List”. Select

No

in the dialog box to view your report.