Deck 4: Module 4: Integrating Word and Excel Access

Question 1

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

Answer 1

True

Question 2

Each time you open a Word document, the size of any copied Excel worksheet object reverts to the original size.​

Answer 2

True

Question 3

When you click a hyperlink from a source file to a location in a destination file​, the destination file opens.

Answer 3

True

Question 4

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

Question 5

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

Question 6

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

Question 7

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

Question 8

If you copy a range of cells from an Excel worksheet, there is only one format you can use when pasting the content into Word.

Question 9

To delete a hyperlink, right-click it and then click Delete Hyperlink. ____________________​

Question 10

You often create hyperlinks between two files that you plan to send electronically.​

Question 11

When you don't want to include Excel data in your Word document, but you still want your readers to access the information, you can create a(n) ____ from a Word document to an Excel worksheet.

A) connection
B) hyperlink
C) relationship
D) embedded object

Question 12

The Hyperlink button is in the Links group on the Design tab.​ _____________________

Question 13

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

Question 14

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

Question 15

You can change the source of any link that you create between two files as long as the files are created in the same source program.

Question 16

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

Question 17

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

Question 18

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

Question 19

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

Question 20

When you use the Table command to create an Excel spreadsheet in Word, the Excel spreadsheet object is an embedded object in the Word file.

Question 21

When ____ are turned on, you can easily see where the paste option adds paragraph breaks and extra spaces.

A) paragraph marks
B) gridlines
C) guides
D) insertion marks

Question 22

You can create hyperlinks to access ____ from other documents and programs.

A) references
B) data
C) formulas
D) codes

Question 23

An Excel spreadsheet that you create in Word is formatted with the ____ theme.

A) default
B) Accent 60
C) Business
D) Ion

Question 24

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

A) dialog box
B) ScreenTip
C) ToolTip
D) popup

Question 25

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

A) the source file opens
B) the source file merges with the destination file
C) the destination file opens
D) the destination file closes

Question 26

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

A) Text Color
B) Themes
C) Colors
D) Hyperlinks

Question 27

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

A) Editing
B) Data
C) Tools
D) Insert

Question 28

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

A) title bars
B) worksheets
C) scroll bars
D) file sizes

Question 29

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

A) Paste Object
B) Paste Special
C) Paste Advanced
D) Advanced Paste

Question 30

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

A) Keep Source Formatting button
B) Formatted Text (RTF)
C) Keep Text Only
D) Unformatted Unicode Text

Question 31

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

A) hot spot
B) range
C) hyperlink
D) object

Question 32

In Word, the Object button appears in the ____ group of the Insert tab.

A) Advanced
B) Text
C) Other
D) Embed

Question 33

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

A) Paste Link
B) Paste Special
C) Paste
D) Link

Question 34

When you edit an Excel spreadsheet in Word, ____ appears in the title bar.

A) Word/Excel
B) the Word document name
C) the Excel spreadsheet name
D) Untitled 1

Question 35

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

A) Insert
B) Place
C) Table
D) Excel

Question 36

____ is an example of a range in Excel.

A) G22
B) =A17*F17
C) A10-A13
D) G18:G21

Question 37

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

A) source
B) destination
C) program
D) words

Question 38

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

A) updated
B) retained
C) lost
D) replaced

Question 39

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

A) comment
B) icon
C) label
D) ScreenTip

Question 40

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 ____.

A) starts the Word program
B) starts the Excel program
C) both a. and b.
D) neither a. nor b.

Question 41

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

A)Page Layout
B)Insert
C)Design
D)Home

Question 42

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 ____.

A) Create New Document button
B) Hyperlinks folder
C) Make Hyperlink check box
D) Excel file that has the donations worksheet in the Current Folder

Question 43

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

Question 44

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.

A) Hyperlink, Hyperlink, Link
B) Hyperlink, Insert, Home
C) Hyperlink, Links, Insert
D) Insert, Hyperlink, Links

Question 45

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?

A) E-mail Address
B) Existing File or Web Page
C) Recent Files
D) Place in This Document

Question 46

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.

A) destination
B) source
C) contact
D) primary

Question 47

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

A)change the destination of the hyperlink
B)remove the hyperlink
C)modify the ScreenTip
D)change the hyperlink name

Question 48

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 ____.

A) light blue and underlined
B) light blue and bold
C) purple
D) purple and underlined

Question 49

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.

Question 50

The Link & Merge Formatting button adds  ____________________  breaks.

Question 51

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

Question 52

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.

Question 53

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.
What is the first step Henry should take to create a hyperlink to the Excel spreadsheet?

A) In Excel, right-click the range of data, then click Hyperlink.
B) In Word, click the Insert tab, then click Object in the Text group.
C) In Word, click the Insert tab, then click Insert Hyperlink.
D) Create some text in Word that will indicate a way to link to the Excel spreadsheet, such as "View Donations."

Question 54

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 enters each dog's name into the first column and the days and times she walks them into the second column. She uses the ____ tools to format the text in the spreadsheet.

A) Format
B) Word
C) Design
D) Excel

Question 55

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.
After creating a title and formatting it, Jill inserts a new paragraph space, and then clicks the ____ tab to access the Table button.

A) Excel
B) Tables
C) Insert
D) File

Question 56

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.

Question 57

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.

Question 58

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.

A) embedded
B) linked
C) locked
D) just a graphic

Question 59

When you don't need to store spreadsheet data in a separate Excel file, you can use the ____________________ command to create an Excel spreadsheet in Word and then use Excel tools to enter labels and values and make calculations.

Question 60

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.