McGraw-Hill OnlineMcGraw-Hill Higher EducationLearning Center
Student Center | Instructor Center | Information Center | Home
Data Files
Buzz in IT
Updates
Flashcards
Multiple Choice Quiz
Puzzlers
Feedback
Help Center


Office XP Excel 2002
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.




McGraw-Hill/Irwin