Microsoft Class

An object can be linked between Word and PowerPoint with options in this dialog box.

Object

You want to embed an Excel worksheet in a Word document. The _____ option should be chosen from the Paste button drop-down list, and _____ should be selected in the As list box.

Paste Special; Microsoft Excel Worksheet Object

An Excel chart can be copied and linked to

a Word document and/or a PowerPoint presentation

When you link data from one program to another, changes made to the data in the source program

are reflected in the destination program.

When integrating programs, cycle through the open programs by using this keyboard command.

Alt + Tab

The Excel button is in the _____ group on the External Data tab.

Export

You want to create handouts as a Word document from a PowerPoint presentation. You need to click the Create Handouts option at this backstage area and then click the Create Handouts button

Export

In the Get External Data - Excel Spreadsheet dialog box, there are three options for how to store the data in the Access database. Which of the following is not one of them?

Import the source data into a new table in a different database

How is an embedded object different from a linked object?

It resides in the document in the source program and in the destination program.

To specify that a linked object should not automatically update, select this option at the Links dialog box.

Manual update

When linking an Excel chart in a Word document, click the _____ option in the As list box at the Paste Special dialog box, click the Paste link option, and then click OK.

Microsoft Excel Chart Object

When an object is embedded into a Word file, Word converts the object into a(n)

Windows metafile (.wmf)

A Word outline exported to PowerPoint creates a presentation using a(n) _____ design template.

blank

When you link an Excel chart into a Word document, you must be sure to select the entire chart area, and not just a specific chart element. When you have selected the chart area, it will be surrounded by a

border

You want to display a linked Excel worksheet as an icon within Word. Begin by right-clicking the linked worksheet, pointing to Linked Worksheet Object on the shortcut menu, and then clicking

convert

Integration refers to the ability to combine, or integrate, data from two or more different programs into a single file.

data from two or more programs can be combined into one file.

When you export a Word outline to a PowerPoint presentation, PowerPoint creates new slides based on the _____ used in the Word outline

heading styles

The display of the linked data in the destination program can be changed to a(n)

icon

A(n) _____ resides in the source program but not as a separate object in the destination program.

linked object

The advantage of _____ data instead of _____ data is that editing the data in the source program will automatically update the data in the destination program.

linking; copying

You are creating handouts in Word from a PowerPoint presentation. The Paste link option is available in the Send to Microsoft Word dialog box for all page layouts except

outline only

When exporting a report from Access to Word, you must _____ before clicking the More button in the Export group and then clicking Word at the drop-down list.

select the report in the Navigation pane

When copying data between programs, the program containing the data to be copied is called the _____ program and the program where the data is pasted is called the destination program.

source

When you export a Word outline to a PowerPoint presentation, if styles are not applied to the Word outline text, PowerPoint uses _____ to place text on slides.

tabs or indents

Office updates a link automatically when the linked data is edited in the destination program or

the destination program is opened.

Which of the following is the keyboard shortcut for cycling through open programs on your computer?

Alt + Tab

When exporting a database object to Word, what dialog box displays when you select the object, click the External Data tab, click the More button, and then click Word at the drop-down list?

Export - RTF File

On which tab in Access will you find buttons for exporting data?

External Data

From the list below, choose the option that best completes the following advice given in the text: If you know you will use the data only in Access, _____ it; if you want to update the data in a program other than Access, _____ it.

Import:Link

Where does an embedded object reside?

In the source program and the destination program.

To break a link to a worksheet from within Word, begin by right-clicking the linked worksheet, pointing to Linked Worksheet Object on the shortcut menu, and then clicking

Links

To update a link manually, open a Word document containing a linked object. Right-click the object, point to Linked (type of object) Object, and then click

Links

If you do not want a linked object to be updated automatically, insert a check mark in the _____ check box in the Links dialog box.

Locked

If you want to delete the link to a table, open the database and then click the table in the Navigation pane, click the Home tab, and then click the Delete button in this group.

Records

What is the advantage to embedding an object rather than copying and pasting it?

The object can be edited in the destination program using the tools of the source program.

Microsoft Office is a suite that allows integration. This means that

data from two or more programs can be combined into one file.

You can embed an object using the Copy and Paste features, or you can use options from the _____ button drop-down list in the Text group on the Insert tab.

object

Which of the following types of Access database objects cannot be exported to Excel?

report

When data is linked, the data exists in the _____ program but not as separate data in the _____ program.

source; destination

When you export a query from Access to Excel using the Export wizard, what name does Access automatically give the exported object?

the name of the query

When an Access table is exported to Word, the resulting Word table might need to be adjusted with the AutoFit button. This button contains all the following options except

Variable Column Width

When data is linked between programs, changes made to the data in the source program

are reflected in the destination program.

In the third Import Spreadsheet Wizard dialog box, there are three options for handling the primary key in the imported data. Which of the following is not one of them?

choose multiple primary keys

When you import data into Access from Excel, the imported data

is not connected to the original data in Excel.

Linking data, rather than copying and pasting it, is useful when the data to be copied

is updated often.

To select an entire Excel chart object to be linked to a document in another program, click

just inside the chart border

When an Access object is exported to Word, it is saved with the .rtf file extension. What does rtf stand for?

rich-text format

When you copy data from one Office program to another, the program containing the data to be copied is called the _____ program, and the program where the data is to be pasted is called the _____ program. Select one:

source; destination

When linked data is displayed as an icon, what does the icon represent?

the document and program to which the object is linked

When you delete a linked table in Access, you are deleting

the information Access uses to open the table

To edit a linked object, open the file containing the object in

the source program

When an object is linked from one Microsoft Office program to another, the object exists in

the source program but not as a separate object in the destination program.

By default, when you open a Word document containing a link to an Excel worksheet, a message box appears asking if you want to

update the document with data from the linked file.

Which of the following is cited in the text as the only advantage of embedding an object instead of simply copying and pasting it?

An embedded object can be edited in the destination program using the tools of the source program.

If a linked chart does not update automatically when you edit the source program, click the chart to select it and then press this function key to update the chart.

F9

Which of the following is mentioned as an advantage of exporting a report from Access to Word?

You can apply Word's formatting features to the report

You are creating handouts as a Word document from a PowerPoint presentation. The Send to Microsoft Word dialog box asks you for two pieces of information: whether to paste or link the content, and

which layout you want to use.

If you make a change to an embedded object at the source program, the change

will not be made in the destination program