integration

you can collect up to ____ items to the clipboard and then switch to another program to paste it.

24

in excel, the formula ____________ will calculate the average of the values in cells B14 through F14

=AVERAGE(B14:F14)

if you need to remove all the items on the clipboard task pane, click _______ _____________?

clear all

you can edit an embedded file by ____________ it in a destination program to open the source program

double-clicking

office technology allows you to ______, or place an unlinked copy of, the contents of a word file into an excel worksheet.

embed

when a word object is ___________ in excel, the word ribbon and tabs appear within the excel window

embed

you can ____ an entire file that you create in one office program in a document created in another office program.

embed

when you use the copy and paste command, by default an object copied from one program to another program the ______ of the original object

formatting

Microsoft office programs are designed to work together through a process called________?

integration

you use the paste options button labeled _________ if you want the pasted chart to assume the formatting of the destination document.

keep source formatting and embed workbook

after you create an object in one program, you can chose to either _____ the object or embed it in another program.

link

if a text value in a word document is automatically updated after a corresponding text value is updated in an excel source document, you can determine that the text value in word is _______ the source document.

linked

when you want to copy an object without a data connection to the source file, you should use the ______ integration method.

paste

as you paste a chart from excel to word use the paste options button labeled ___________ if you want the theme of the destination document applied to the chart, and the chart is linked in the source document.

paste special

in the ________ ______ dialog box you have more options for pasting a value and controlling its appearance in a destination file.

paste special

when you are editing an embedded file, you can determine the names of the destination file by examining the ____________ _______.

title bar

the paste options button labeled ____________ is used if you want the paste chart not to be linked to the source document but u want the pasted chart to assume the formatting of the destination document

use destination theme and embed workbook

the paste options labeled ____________ is selected by default when a chart is pasted into a destination document.

use destination theme and link data button

when a chart is pasted into the destination document, the ____________________ button is selected by default.

use destination theme and link data button