Exam 4: Module 4: Integrating Word and Excel Access

In Word, the Table button appears on the ____ tab.

A(n) ____ can be a graphic that you click to display another place in a file.

When you embed a Word file in an Excel spreadsheet, the original Word formatting is ____.

To insert a new Excel spreadsheet in Word, click the ____ button and then click Excel Spreadsheet.

The Link & Merge Formatting button adds page breaks.​ ____________________

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 keeps the default option selected and then he selects the ____.

The Microsoft Excel Worksheet option allows you to easily modify the size of a pasted object.​

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. To get started creating a new Excel worksheet in Word, Jill ____.

In general, when you create a file in one program and embed it into another program, the formatting of the original file is lost.

When you use the ____________________ command, you can choose to retain the original formatting of the pasted object, you can remove all the formatting, or you can even paste the object as a picture that you can enhance with special effects, border styles, fill colors, 3D formatting, shadows, and rotation effects.

To change the color of a hyperlink, click the ____ button on the Design tab in the Document Formatting group.

The ____ option opens a dialog box in which you can choose to paste a link.

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. Jill understands that the Excel spreadsheet is ____ in Word.

In the ____________________ dialog box, you can create a link to an existing file or to a place in the current document, or you can create a hyperlink that opens a new document or opens an email program so you can send an email.

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 selects the text that will act as the hyperlink, clicks the Hyperlink button on the INSERT tab to open the Insert Hyperlink dialog box. What is selected by default?

To change a theme, click the _____ tab, then click the Themes button.​

You cannot change the color assigned to a followed hyperlink. ____________________​

A(n) ____________________ is a text element or graphic that you click to display another place in a file, other files created in the same or other programs, or a location on the Internet.

When you paste an object into an Office program using the ____ command, you can specify how you want that object to appear.