Exam 4: Module 4: Integrating Word and Excel Access

Paste options vary depending on the type of data that is selected.​

CASE 2 Henry is working on the annual fund information for his son's high school. The information consists of an Excel spreadsheet of donations as well as a Word article about where the funds were used to make improvements to the school. He decides to link the two files together so that the school committee members can easily access both items using one file. Henry understands that Word will be the ____ file.

When you copy, paste, and link data between programs, you actually bring the data into the destination file.

You can include text in a(n) ____ that appears when users point to a hyperlink.

When you click a hyperlink from a source file to a location in a destination file, ____.

In Word, you can access the different ____ in an embedded Excel file.

To change the color of a hyperlink, click the Colors button in the Document Formatting group on the Design Tab.​ ____________________

To modify an embedded Excel spreadsheet, you double-click it and then use Excel tools that become available inside the Word program window.

When copying from Excel and pasting to Word, "Picture" is a Paste option.

CASE 1 Jill owns a dog walking business. She has 14 different dogs that she walks on different schedules. To help her organize her schedule, she wants to create an Excel worksheet in Word so that she can add notes about the dogs below the chart. Below the Excel spreadsheet, Jill lists the names of each dog owner. Each owner's last name will be a hyperlink that opens her email program with an email addressed to the owner she has clicked. To get started, she highlights the first last name, then clicks the ____ button in the ____ group on the _____ tab.

Each time you update a link pasted with the Link & Merge Formatting paste option, you need to adjust the spacing.​

The Enter Text dialog box is used to change the ____ location.

When you open a Word file that is linked to an Excel file, you receive the following message: "This document contains links that may refer to other files. Do you want to update this document with the data from the linked files?" You can then click "____________________" to reestablish the links between the two files.

With the ____ paste option, all formatting is removed and no space or paragraph breaks are added.

You use the ____________________ dialog box to change link sources and update links.

CASE 2 Henry is working on the annual fund information for his son's high school. The information consists of an Excel spreadsheet of donations as well as a Word article about where the funds were used to make improvements to the school. He decides to link the two files together so that the school committee members can easily access both items using one file. When Henry closes the Insert Hyperlink dialog box, the hyperlink appears as ____.

When you open a Word file that is linked to an Excel file, you receive the following message: "This document contains links that may refer to other files. Do you want to update this document with the data from the linked files?" You can then click "____________________" to open the Word file without linking to the Excel file.

In the Edit Hyperlink dialog box, you can do all of the following EXCEPT _____.​

With the ____________________ paste option, all formatting is removed and no spaces or paragraph breaks are added.

____ is an example of a range in Excel.