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