Question 1

To change a theme, click the _____ tab, then click the Themes button.​
A)Page Layout
B)Insert
C)Design
D)Home

Accepted Answer

The answer of To change a theme, click the _____...

Question 2

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

Accepted Answer

Henry selects the Excel file that has the donations worksheet in the Current Folder to link it with the Word document, allowing easy access to both files.

Question 3

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

Accepted Answer

The answer of You use the ____________________ dialog box to...

Question 4

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

Accepted Answer

The correct sequence is to click the "Hyperlink" button in the "Links" group on the "Insert" tab in Word to create a hyperlink.

Question 5

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

Accepted Answer

By default, the "Existing File or Web Page" option is selected in the Insert Hyperlink dialog box in Microsoft Word.

Question 6

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

Accepted Answer

The Word article is where the information about the funds was written, so it is the destination file. The Excel spreadsheet is the source file, as it contains the information that is being linked to the Word article.

Question 7

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

Accepted Answer

You cannot change the hyperlink name in the Edit Hyperlink dialog box.

Question 8

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

Accepted Answer

Hyperlinks in Word documents typically appear as light blue and underlined by default.

Question 9

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.

Accepted Answer

The answer of When you use the ____________________ command, you...

Question 10

The Link & Merge Formatting button adds  ____________________  breaks.

Accepted Answer

The answer of The Link & Merge Formatting button adds ...

Question 11

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

Accepted Answer

The answer of With the ____________________ paste option, all formatting...

Question 12

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.

Accepted Answer

The answer of When you open a Word file that...

Question 13

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

Accepted Answer

The first step is to create some text in Word that will serve as the anchor for the hyperlink, such as "View Donations." This text will be used to create the hyperlink to the Excel spreadsheet.

Question 14

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

Accepted Answer

Jill uses Excel tools to format the text in the spreadsheet because she is creating an Excel worksheet.

Question 15

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

Accepted Answer

To access the Table button in Word, Jill should click on the Insert tab.

Question 16

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.

Accepted Answer

The answer of In the ____________________ dialog box, you can...

Question 17

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.

Accepted Answer

The answer of When you open a Word file that...

Question 18

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

Accepted Answer

Jill wants to create an Excel worksheet within Word, so she wants to embed it. This means that the Excel spreadsheet will be inserted into the Word document, making it easier to keep both documents together and organized.

Question 19

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.

Accepted Answer

The answer of When you don't need to store spreadsheet...

Question 20

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.

Accepted Answer

The answer of A(n) ____________________ is a text element or...

Quiz 4: Module 4: Integrating Word and Excel Access

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

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

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

The Link & Merge Formatting button adds ____________________ breaks.

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

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.

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.

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.

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

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