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