Question 1

The choices on the Paste Options button that appears next to a pasted object are ____ the choices seen when clicking the Paste button arrow.
A) usually, but not always, different from
B) more varied than
C) compressed versions of
D) the same as

Accepted Answer

The choices on the Paste Options button are the same as those seen when clicking the Paste button arrow, offering consistent paste options.

Question 2

When pasting an Excel chart into a Word document, using the ____ button makes the formatting the same as the Word document's and keeps the source file separate.
A) Keep Source Formatting & Embed Workbook
B) Use Destination Theme & Embed Workbook
C) Link & Use Destination Styles
D) Link & Keep Source Formatting

Accepted Answer

Using the "Use Destination Theme & Embed Workbook" button will ensure that the chart formatting matches the Word document's theme and the source Excel file is kept separate but still embedded in the Word document. This option provides a cleaner and more consistent format for the overall document.

Question 3

If an Excel table is likely to change, and you want to make sure that its information is updated in any files in which it is used, it is best to ____.
A) embed the table
B) link the table
C) paste the table as a picture
D) manual re-paste the table each time it is updated

Accepted Answer

Linking the table ensures that any changes made to the original table will automatically update in any files where it is used. Embedding the table creates a copy of the table in the file, so any changes to the original will not be reflected in the embedded table. Pasting as a picture is a static image and cannot be updated with any changes to the original table. Manual re-pasting is time-consuming and increases the risk of errors.

Question 4

When you simply click the Paste button to insert an Excel chart into Word, ____.
A) you cannot alter the way it was pasted
B) you can only alter the orientation of the pasted object
C) you can only alter the way the object was pasted by using Ribbon commands
D) you can easily alter the way the object was pasted by using the Paste Options button that appears at the lower-right corner of the object

Accepted Answer

When you paste an Excel chart into Word, a Paste Options button appears at the lower-right corner of the object. Clicking this button allows you to easily alter the way the object was pasted, such as adjusting the size, layout, and formatting. Therefore, the best choice is D.

Question 5

When you click an embedded object, the ____ changes to include tabs and commands from the embedded object's source program.
A) ribbon in the destination program
B) ribbon in the source program
C) Paste Options menu in the source program
D) Paste Options menu in the destination program

Accepted Answer

When you click an embedded object, the ribbon in the destination program changes to include tabs and commands from the embedded object's source program, allowing you to edit the object using the source program's tools.

Question 6

Use embedding if you want ____.
A) to edit the object without affecting the source file
B) to store the object in the source file
C) the destination file size to remain fairly small
D) to have changes to the source file appear in the destination file

Accepted Answer

Embedding allows you to edit the object without affecting the source file, as the object is stored independently within the destination file.

Question 7

To change the default paste option, click ____ on the Paste menu.
A) Set Default Paste
B) Revert to Default
C) Advanced
D) Paste Options

Accepted Answer

The correct answer is A because "Set Default Paste" is the option on the Paste menu that allows you to change the default paste option.

Question 8

When linking an Excel chart into a Word document, using the ____ button makes the formatting the same as the Word document.
A) Keep Source Formatting & Embed Workbook
B) Use Destination Theme & Embed Workbook
C) Link & Use Destination Styles
D) Link & Keep Source Formatting

Accepted Answer

The "Link & Use Destination Styles" option ensures that the chart adopts the formatting style of the Word document, making it consistent with the document's theme.

Question 9

The ______ contextual tabs appears on the Word ribbon when an embedded Excel chart is selected.
A) CHART TOOLS
B) HOME
C) OLE
D) PAGE LAYOUT

Accepted Answer

The Chart Tools contextual tabs appear on the Word ribbon when an embedded Excel chart is selected. These tabs include Design, Layout, and Format, which allow users to make adjustments to the chart. The Home, OLE, and Page Layout tabs do not specifically relate to working with embedded Excel charts.

Question 10

When you paste an object into an Office document, you can choose how that object will be pasted before you paste it by using the ____.
A) Paste Preview button
B) Object button arrow
C) Paste buton arrow
D) Live Options button

Accepted Answer

The Paste button arrow in Office applications allows you to choose how an object will be pasted, such as keeping source formatting or merging formatting, before actually pasting it.

Question 11

If you have clicked the Paste button to insert an object, you can still change the way an object is pasted by clicking the ____ button that appears just below and to the right of the pasted object.
A) Revert
B) Paste Preview
C) Paste Options
D) Special Tools

Accepted Answer

The "Paste Options" button appears after clicking the Paste button and allows you to change the way an object is pasted, such as choosing to keep the formatting or selecting only the text. Revert and Special Tools are not options that appear after pasting, and Paste Preview is not a button that appears below and to the right of the pasted object.

Question 12

If you plan to send a file with a linked object to someone who will not have access to the linked object's source file, you should ____.
A) bundle the files as a PDF
B) break the link
C) hard-paste the link
D) not try to send the file, as an error will result

Accepted Answer

Breaking the link will remove the dependency on the source file and embed the object within the file, allowing the recipient to view it without access to the original source file.

Question 13

____ fields contain instructions for replacing these field placeholders with the variable information from a data source.
A) Embedded
B) Merge
C) Query
D) Tapped

Accepted Answer

Merge fields are specifically designed to incorporate variable data from a data source, such as a database or spreadsheet. They work by replacing field placeholders with the actual data during the merging process.

Question 14

To break a link, you use the Links command on the ____.
A) Manage Data menu in the source file
B) Link & Embed menu in the destination file
C) Edit menu in the destination file
D) Link & Embed menu in the source file

Accepted Answer

To break a link, you must edit the destination file where the link has been inserted. Therefore, the Links command can be found in the Edit menu of the destination file.

Question 15

A disadvantage of linking is that ____.
A) the source file and destination file must be stored separately
B) the source file and destination file must be stored together
C) the destination file size increases to reflect the addition of the object from the source file
D) the destination file size remains fairly small

Accepted Answer

Linking requires that the source and destination files be stored together to maintain the link, which can be a disadvantage if files need to be moved or shared independently.

Question 16

If your document does not show nonprinting characters, click the Show/Hide button in the Paragraph group on the ____ tab.
A) TABLE TOOLS
B) FILE
C) DESIGN
D) HOME

Accepted Answer

The Show/Hide button is located in the Paragraph group on the HOME tab in Microsoft Word.

Question 17

An advantage of embedding is that ____.
A) the source file and destination file may be stored separately
B) the source file and destination file are automatically stored together
C) the destination file size increases to reflect the addition of the object from the source file
D) the destination file size remains fairly small

Accepted Answer

An advantage of embedding is that the source file and destination file may be stored separately, allowing for more flexibility and easier management of files.

Question 18

If you have a source document and a destination document open, and you change information in a linked source document, a quick way to see the changes in the destination document is to ____.
A) right-click the taskbar and click Update Links
B) click the changed object in the source file and then select Refresh from the Options button that appears
C) triple-click the object in the source file
D) right-click the object in the destination file and then click Update Link

Accepted Answer

Right-clicking the object in the destination file and selecting "Update Link" will refresh the data to reflect changes made in the linked source document.

Question 19

-Clicking ____ in the accompanying figure will open a gallery displaying chart styles.
A) A
B) B
C) anywhere in the chart
D) C

Accepted Answer

The answer of 
-Clicking ____ in the accompanying figure will...

Question 20

The location of a source file is known as its ____.
A) file path
B) URL
C) domain
D) root

Accepted Answer

The location of a source file is commonly referred to as the file path, which indicates the location of the file within the file system of a computer or network. A URL (B) is a type of web address that may include a file path as part of the address, but it specifically refers to a web resource. A domain (C) is a part of a web address that identifies the website or server hosting the resource, but it does not indicate the location of a specific file. Root (D) generally refers to the top-level directory or folder within a file system, but it is not specific enough to indicate the location of an individual file.

Quiz 11: Integrating Word, Excel, Access, and Powerpoint

The choices on the Paste Options button that appears next to a pasted object are ____ the choices seen when clicking the Paste button arrow.

When pasting an Excel chart into a Word document, using the ____ button makes the formatting the same as the Word document's and keeps the source file separate.

If an Excel table is likely to change, and you want to make sure that its information is updated in any files in which it is used, it is best to ____.

When you simply click the Paste button to insert an Excel chart into Word, ____.

When you click an embedded object, the ____ changes to include tabs and commands from the embedded object's source program.

Use embedding if you want ____.

To change the default paste option, click ____ on the Paste menu.

When linking an Excel chart into a Word document, using the ____ button makes the formatting the same as the Word document.

The ______ contextual tabs appears on the Word ribbon when an embedded Excel chart is selected.

When you paste an object into an Office document, you can choose how that object will be pasted before you paste it by using the ____.

If you have clicked the Paste button to insert an object, you can still change the way an object is pasted by clicking the ____ button that appears just below and to the right of the pasted object.

If you plan to send a file with a linked object to someone who will not have access to the linked object's source file, you should ____.

____ fields contain instructions for replacing these field placeholders with the variable information from a data source.

To break a link, you use the Links command on the ____.

A disadvantage of linking is that ____.

If your document does not show nonprinting characters, click the Show/Hide button in the Paragraph group on the ____ tab.

An advantage of embedding is that ____.

If you have a source document and a destination document open, and you change information in a linked source document, a quick way to see the changes in the destination document is to ____.

-Clicking ____ in the accompanying figure will open a gallery displaying chart styles.

The location of a source file is known as its ____.