Question 1

-In the accompanying figure,item 1 points to a(n)____.
A) hot spot
B) range
C) hyperlink
D) object

Accepted Answer

Item 1 pointing to a hyperlink is indicated by the context of the question, which suggests a link or connection to another document or page, typical behavior of a hyperlink in digital documents or web pages.

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.

Accepted Answer

Embedding a file from one program into another typically preserves the formatting of the original file, as the purpose of embedding is to maintain the original appearance and functionality within the new document.

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

Accepted Answer

ScreenTips are the small text boxes that appear when users hover over a hyperlink, providing additional information about the link.

Question 4

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

Accepted Answer

The answer of When you copy,paste,and link data between programs,you...

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

Accepted Answer

The answer of To insert a new Excel spreadsheet in...

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

Accepted Answer

Paragraph marks, when turned on, show where paragraphs end, including paragraph breaks and extra spaces, making it easier to see the formatting in a document.

Question 7

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

Accepted Answer

When copying content from Excel and pasting it into Word, "Picture" is indeed one of the paste options, allowing the content to be pasted as an image.

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.

Accepted Answer

The ability to change the source of a link between files depends on the program's features and settings, not just the fact that the files were created in the same 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

Accepted Answer

When you click a hyperlink from a source file to a location in a destination file, the destination file opens. This allows you to view or interact with the content that the hyperlink points to.

Question 10

____ is an example of a range in Excel.
A) G22
B) =A17*F17
C) A10-A13
D) G18:G21

Accepted Answer

A range in Excel is defined by a group of cells, typically denoted by the starting cell and the ending cell separated by a colon, such as G18:G21.

Question 11

You can create hyperlinks to access ____ from other documents and programs.
A) references
B) data
C) formulas
D) codes

Accepted Answer

Hyperlinks can be used to access data from other documents and programs, allowing users to quickly navigate to specific information or resources.

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

Accepted Answer

The "Paste Special" option in various software applications, including Microsoft Office programs, opens a dialog box that allows users to choose from several paste options, including pasting content as a link. This enables the pasted content to update automatically if the original source changes.

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

Accepted Answer

The "Paste Special" command in Office programs allows you to specify how you want the pasted object to appear, offering various options for formatting and handling the pasted content.

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.

Accepted Answer

When pasting content from Excel into Word, you can choose from multiple formats such as keeping the original formatting, merging formatting, pasting as a picture, or even pasting as plain text, among others.

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

Accepted Answer

The "Keep Text Only" paste option removes all formatting, including font, color, size, and also removes any space or paragraph breaks, leaving only the plain 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

Accepted Answer

The answer of 
-The dialog box shown in the accompanying...

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.

Accepted Answer

When you use the Table command to create an Excel spreadsheet in Word, the Excel spreadsheet object becomes an embedded object within the Word document, allowing you to work on it using Excel tools while it remains part of the Word file.

Question 18

-In the accompanying figure,item 2 points to a(n)____.
A) hyperlink
B) ScreenTip
C) ToolTip
D) popup

Accepted Answer

The answer of 
-In the accompanying figure,item 2 points to...

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.

Accepted Answer

When you double-click an embedded Excel spreadsheet in a Word document, it opens in an Excel-like environment within Word, allowing you to use Excel tools for modification without leaving the Word program.

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

Accepted Answer

A hyperlink in a Word document can link to an Excel worksheet, allowing readers to click the link to access the Excel data without including the actual data in the Word document.

Quiz 9: Integration : Integrating Word and Excel

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

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

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

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

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

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

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

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 click a hyperlink from a source file to a location in a destination file,____.

____ is an example of a range in Excel.

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

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

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

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.

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

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

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.

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

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

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.