Question 1

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.

Accepted Answer

A) True 
 B)False  False

Question 2

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

Accepted Answer

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

Question 3

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?

Accepted Answer

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

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

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

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

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 8

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.

Accepted Answer

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

Question 9

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.

Accepted Answer

A) True 
 B)False

Question 10

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.

Accepted Answer

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

Question 11

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

Accepted Answer

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

Question 12

Match between columns
                        Premises:  Keep Text Only
 Keep Source Formatting button
Picture
 Merge Formatting
 Link and Keep Source Formatting
 Unformatted Text
 Formatted Text (RTF)
 HTML Format
 Link and Merge Formatting
Microsoft Excel Worksheet Object

Accepted Answer

The Answer of Paste list arrow and Paste special dialog is...

Question 13

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

Accepted Answer

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

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

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

Accepted Answer

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

Question 16

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.

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

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

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

Accepted Answer

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

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

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

Accepted Answer

A) True 
 B)False

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.

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

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

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

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

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.

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.

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.

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

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

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

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

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.

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

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

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

Productivity Apps for School and Work Word, Analyzing Data Using Formulasmodifying the Database Structureintegrating Word, Excel, and Access

Illustrating Documents With Graphics Managing Workbook Dataimproving Queriesenhancing Chartsintegrating Word, Excel, Access, and Powerpoint

Working With Themes and Building Blocksusing Tablesenhancing Formsinserting Graphics, Media, and Objects

Merging Word Documents Analyzing Table Dataanalyzing Data With Reportsusing Advanced Features

Filters

Exam 4: Module 4: Integrating Word and Excel Access

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.

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

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

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

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

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.

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.

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.

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

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

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

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

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.

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

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

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

Productivity Apps for School and Work Word, Analyzing Data Using Formulasmodifying the Database Structureintegrating Word, Excel, and Access

Illustrating Documents With Graphics Managing Workbook Dataimproving Queriesenhancing Chartsintegrating Word, Excel, Access, and Powerpoint

Working With Themes and Building Blocksusing Tablesenhancing Formsinserting Graphics, Media, and Objects

Merging Word Documents Analyzing Table Dataanalyzing Data With Reportsusing Advanced Features

Filters

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

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

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

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

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