Student Center
|
Instructor Center
|
Information Center
|
Home
Data Files
Buzz in IT
Updates
Choose one...
Lab 1
Lab 2
Lab 3
Lab 4
Lab 5
Lab 6
Lab 7
Lab 8
Lab 9
Working Together 1
Working Together 2
Working Together 3
Flashcards
Multiple Choice Quiz
Puzzlers
Feedback
Help Center
Office XP Excel 2002, 2/e
Timothy O'Leary, Arizona State University
Linking, Embedding, and E-mailing
Working Together 1- Quiz
Click on the correct response for each question below.
1
When an object is linked, the data is stored in the
A)
source file.
B)
destination file.
C)
active file.
D)
object file.
2
A connection between the information in the destination file and the source file is established by the creation of a
A)
formula.
B)
cell reference.
C)
worksheet reference.
D)
link.
3
This occurs when changes are made in the source file that affect the linked object. The changes are automatically reflected in the destination file when it is open.
A)
Open link
B)
Object link
C)
Live link
D)
Reference link
4
The field code in the Links dialog box specifies all of the following except
A)
the range of linked cells or object name.
B)
absolute references in the destination file.
C)
the path and name of the source file.
D)
the update status.
5
This option in the Links dialog box prevents a linked object from being updated.
A)
Automatic
B)
Manual
C)
Break Link
D)
Locked
6
You can modify an entire file without affecting the source document where the original object resides when an object that is
A)
embedded is stored in the destination file and becomes part of that document.
B)
copied is stored in the destination file and becomes part of that document.
C)
formatted is stored in the destination file and becomes part of that document.
D)
linked is stored in the destination file and becomes part of that document.
7
This application is used to edit the data in an embedded object.
A)
Format
B)
Server
C)
Formula
D)
Linking
8
To be able to open and edit an embedded object in an workbook, you must have this on your system.
A)
Macros
B)
Linking capabilities
C)
Server application
D)
Cell format features
9
To send an e-mail message to multiple recipients, separate the e-mail addresses with
A)
semicolons.
B)
colons.
C)
commas.
D)
backslashes.
2002 McGraw-Hill Higher Education
Any use is subject to the
Terms of Use
and
Privacy Policy
.
McGraw-Hill Higher Education
is one of the many fine businesses of
The McGraw-Hill Companies
.