Deck 9: Integration : Integrating Word and Excel

Question 1

In the accompanying figure,item 1 points to a(n)____.

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

Answer 1

C

Question 2

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

Answer 2

False

Question 3

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

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

Answer 3

D

Question 4

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

Question 5

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 6

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 7

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

Question 8

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 9

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 10

____ is an example of a range in Excel.

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

Question 11

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

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

Question 12

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 13

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 14

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 15

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 16

The dialog box shown in the accompanying figure is used to change the ____ location.

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

Question 17

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 18

In the accompanying figure,item 2 points to a(n)____.

A) hyperlink
B) ScreenTip
C) ToolTip
D) popup

Question 19

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

Question 20

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 21

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

Question 22

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 23

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

A) EDITING
B) DATA
C) TOOLS
D) INSERT

Question 24

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 25

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

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

Question 26

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 27

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 28

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 29

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 30

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 31

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

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

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

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.

Question 34

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

Question 35

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

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

Question 36

Jill understands that the Excel spreadsheet is ____ in Word.

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

Question 37

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 38

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