Microsoft Office Word 2016 – Illustrated Complete Word - 1

Solutions to Word 2016 Module 12 EOU Exercises

MODULE 12

Integrating Word with Other Programs

Table of Contents

Concepts Review...........................................................................................................................................2

Skills Review.................................................................................................................................................3

Independent Challenge 1..............................................................................................................................6

Independent Challenge 2..............................................................................................................................7

Independent Challenge 3..............................................................................................................................8

Independent Challenge 4: Explore................................................................................................................9

Visual Workshop.........................................................................................................................................10

Microsoft Office Word 2016 – Illustrated Complete Word - 2

Solutions to Word 2016 Module 12 EOU Exercises

Module 12: Integrating Word with Other Programs

Concepts Review

Screen Labeling Matching Items Multiple Choice

1. d 6. a 13. d

2. e 7. c 14. b

3. a 8. e 15. b

4. b 9. b

5. c 10. g

11. d

12. f

Microsoft Office Word 2016 – Illustrated Complete Word - 3

Solutions to Word 2016 Module 12 EOU Exercises

Skills Review

WD 12-Pathway Tours Report.docx

WD 12-Pathway Tours Data.xlsx

WD 12-Pathway Tours Customer Profile.rtf

WD 12-Pathway Tours Cover Letter.docx

WD 12-Pathway Tours Cover Letter_Merged.docx

At the end of section 6, the completed project file should span five pages, as shown below. Verify that a PowerPoint slide appears on page 1, the embedded Excel worksheet appears on page 2, the linked Excel chart appears on page 3, the data from the inserted Word file appears on page 4, and the table published from Access appears on page 5. At the end of section 7, students save letters 5 and 6. Shown below is completed letter 5 for Sofia Carelli.

WD 12-Pathway Tours Report.docx

Microsoft Office Word 2016 – Illustrated Complete Word - 4

Solutions to Word 2016 Module 12 EOU Exercises

Microsoft Office Word 2016 – Illustrated Complete Word - 5

Solutions to Word 2016 Module 12 EOU Exercises

Microsoft Office Word 2016 – Illustrated Complete Word - 6

Solutions to Word 2016 Module 12 EOU Exercises

WD 12-Pathway Tours Cover Letter_Merged.docx

Microsoft Office Word 2016 – Illustrated Complete Word - 7

Solutions to Word 2016 Module 12 EOU Exercises

Independent Challenge 1

WD 12-Recreation Commission Minutes.docx

Students insert an Excel worksheet into a Word document as an embedded object, insert a file from Word, create a hyperlink, and modify the color of the hyperlink. The completed document spans two pages as shown below.

Estimated completion time: 40 minutes

WD 12-Recreation Commission Minutes.docx

Microsoft Office Word 2016 – Illustrated Complete Word - 8

Solutions to Word 2016 Module 12 EOU Exercises

Independent Challenge 2

WD 12-Grand Canyon Camp Report.docx

WD 12- Grand Canyon Camp Data.xlsx

Students insert a PowerPoint slide on the first page of a Word report, copy a chart from Excel and paste it into Word using the Use Destination Theme & Link Data (L) option, update the chart in Excel, then break the link in Word, and view the document in Read Mode.

Verify that the completed report appears as shown below in Word.

Estimated completion time: 20 minutes

WD 12-Grand Canyon Camp Report.docx

Microsoft Office Word 2016 – Illustrated Complete Word - 9

Solutions to Word 2016 Module 12 EOU Exercises

Microsoft Office Word 2016 – Illustrated Complete Word - 10

Solutions to Word 2016 Module 12 EOU Exercises

Independent Challenge 3

WD 12-Crafts Memo.docx

WD 12-Crafts Sales.rtf

WD 12-Craft Database.accdb

WD 12-Crafts Memo_Merged.docx

The completed memo includes a linked Excel worksheet and a table created in Access and then exported to Word. In addition, the memo is merged with a database to produce individually addressed memos. The memos to Elizabeth Montague and Amelia Leriche appear as shown below.

Estimated completion time: 20 minutes

WD 12-Crafts Memo_Merged.docx

Microsoft Office Word 2016 – Illustrated Complete Word - 11

Solutions to Word 2016 Module 12 EOU Exercises

Microsoft Office Word 2016 – Illustrated Complete Word - 12

Solutions to Word 2016 Module 12 EOU Exercises

Independent Challenge 4: Explore

WD 12-Event Planning.docx

WD 12-Event Guests.rtf

The completed document includes a table imported from Access, a hyperlink from text in the document to a heading in the document, and an embedded Excel worksheet. In addition, create a chart in Word from data in the embedded Excel file.

Estimated completion time: 40 minutes.

WD 12-Event Planning.docx

Microsoft Office Word 2016 – Illustrated Complete Word - 13

Solutions to Word 2016 Module 12 EOU Exercises

Microsoft Office Word 2016 – Illustrated Complete Word - 14

Solutions to Word 2016 Module 12 EOU Exercises

Visual Workshop

WD 12-JT Consultants Data.xlsx

WD 12-JT Consultants Report.docx

Students embed a PowerPoint slide into a new Word document, add text to the document, copy a pie chart from Excel and paste it as a link into the Word document, update a chart value in Excel, then break the link to the Excel file in Word. Finally, students view the document in Read Mode. In Word Print Layout view, the document should appear as shown below.

WD 12-JT Consultants Report.docx

Microsoft Office Word 2016 – Illustrated Complete Word - 15

Solutions to Word 2016 Module 12 EOU Exercises