Question 1

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

Question 2

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

Accepted Answer

When you edit an Excel spreadsheet in Word, the Word document name appears in the title bar, indicating the active application and the document currently being edited.

Question 3

In Word,the Table button appears on the ____ tab.
A) EDITING
B) DATA
C) TOOLS
D) INSERT

Accepted Answer

The Table button is found on the "Insert" tab in Microsoft Word, which allows users to insert tables into their documents.

Question 4

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

Accepted Answer

The "Colors" button on the DESIGN tab in the Document Formatting group allows users to change theme colors, including hyperlink colors, in a document.

Question 5

An Excel spreadsheet that you create in Word is formatted with the ____ theme.
A) default
B) Accent 60
C) Business
D) Ion

Accepted Answer

When you create an Excel spreadsheet in Word, it uses the default theme for its formatting. This ensures consistency with the default styles and colors of Excel, unless the user decides to change the theme manually.

Question 6

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

Question 7

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 insert a table in a document, you typically use the "Insert" tab, where you can find the Table button among other options for inserting various elements into your document.

Question 8

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

To create a hyperlink in Excel, you would use the "Hyperlink" button, which is located in the "Links" group on the "INSERT" tab.

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

Question 10

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 11

When you embed a Word file in an Excel spreadsheet,the original Word formatting is ____.
A) updated
B) retained
C) lost
D) replaced

Accepted Answer

When you embed a Word file in an Excel spreadsheet, the original Word formatting is retained. This means that the document will keep its original layout, fonts, colors, and other formatting options.

Question 12

In Word,the Object button appears in the ____ group of the INSERT tab.
A) Advanced
B) Text
C) Other
D) Embed

Accepted Answer

The Object button is located in the Text group of the INSERT tab in Microsoft Word. This option is used to insert objects like equations, symbols, or objects from other programs.

Question 13

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

Question 14

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

Accepted Answer

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

Question 15

In Word,you can access the different ____ in an embedded Excel file.
A) title bars
B) worksheets
C) scroll bars
D) file sizes

Accepted Answer

In an embedded Excel file within Word, you can access the different worksheets, allowing you to view and edit data across multiple sheets within the embedded Excel object.

Question 16

Jill understands that the Excel spreadsheet is ____ in Word.
A) embedded
B) linked
C) locked
D) just a graphic

Accepted Answer

When an Excel spreadsheet is inserted into a Word document, it can be embedded, meaning it becomes part of the Word document and can be edited within Word while maintaining its Excel functionality.

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 reestablish the links between the two files.

Accepted Answer

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

Question 18

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

The answer of Jill enters each dog's name into the...

Quiz 9: Integration : Integrating Word and Excel

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

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

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

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

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

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.

After creating a title and formatting it,Jill inserts a new paragraph space,and then clicks the ____ tab to access the Table button.

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.

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

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

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.

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

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

Jill understands that the Excel spreadsheet is ____ in Word.

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.