Question 1

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Stored within the destination file and is no longer part of the source file
A)linked object
B)embedding object
C)PDF (Portable Document Format)
D)Standard properties
E)Custom properties
F)Object linking and embedding (OLE)
G)Encryption
H)digital certificate
I)certificate authority (CA)
J)source file

Accepted Answer

An embedding object is stored within the destination file and is no longer part of the source file.

Question 2

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-An attachment to a document that authenticates the source of the signature
A)linked object
B)embedding object
C)PDF (Portable Document Format)
D)Standard properties
E)Custom properties
F)Object linking and embedding (OLE)
G)Encryption
H)digital certificate
I)certificate authority (CA)
J)source file

Accepted Answer

A digital certificate is an attachment to a document that authenticates the source of the signature, and it is typically issued by a certificate authority (CA).

Question 3

____________________ is the process by which a file is encoded so that it cannot be opened without the proper password.

Accepted Answer

The answer of ____________________ is the process by which a...

Question 4

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Associated with all Office files and include the author,title,and subject
A)linked object
B)embedding object
C)PDF (Portable Document Format)
D)Standard properties
E)Custom properties
F)Object linking and embedding (OLE)
G)Encryption
H)digital certificate
I)certificate authority (CA)
J)source file

Accepted Answer

Standard properties are associated with all Office files and include the author, title, and subject.

Answer: E
 Custom properties are also associated with Office files but are added by the user with specific information like keywords and comments.

(Note: the other options are not related to file properties)

Question 5

Describe how you can control Excel recalculating Formulas.Discuss the Automatic,Automatic except for data tables,and Manual options.

Accepted Answer

The answer of Describe how you can control Excel recalculating...

Question 6

Describe the steps to review tracked changes in a shared workbook.

Accepted Answer

The answer of Describe the steps to review tracked changes...

Question 7

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Provider of verified digital signatures
A)linked object
B)embedding object
C)PDF (Portable Document Format)
D)Standard properties
E)Custom properties
F)Object linking and embedding (OLE)
G)Encryption
H)digital certificate
I)certificate authority (CA)
J)source file

Accepted Answer

A certificate authority (CA) is an entity that issues digital certificates, which are used to verify digital signatures and establish trust in electronic transactions.

Question 8

Each column of a database table,called a(n)____________________,stores information about a specific characteristic of a person,place,or thing.

Accepted Answer

The answer of Each column of a database table,called a(n)____________________,stores...

Question 9

A(n)____________________ file contains the object that is displayed in the destination file.

Accepted Answer

The answer of A(n)____________________ file contains the object that is...

Question 10

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-A file format developed by Adobe Systems for displaying formatted documents containing text,graphics,and complicated layouts
A)linked object
B)embedding object
C)PDF (Portable Document Format)
D)Standard properties
E)Custom properties
F)Object linking and embedding (OLE)
G)Encryption
H)digital certificate
I)certificate authority (CA)
J)source file

Accepted Answer

PDF (Portable Document Format) is a file format developed by Adobe Systems for displaying formatted documents containing text, graphics, and complicated layouts.

(Note: The other choices are unrelated to the definition given.)

Question 11

The ____________________ acts like a notary public,verifying signatures and tracking those that have expired or been revoked.

Accepted Answer

The answer of The ____________________ acts like a notary public,verifying...

Question 12

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Defined and created specifically for a workbook
A)linked object
B)embedding object
C)PDF (Portable Document Format)
D)Standard properties
E)Custom properties
F)Object linking and embedding (OLE)
G)Encryption
H)digital certificate
I)certificate authority (CA)
J)source file

Accepted Answer

Custom properties are defined and created specifically for a workbook, allowing users to add specific metadata or information unique to that workbook.

Question 13

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-The process by which a file is encoded so that it cannot be opened without the proper password
A)linked object
B)embedding object
C)PDF (Portable Document Format)
D)Standard properties
E)Custom properties
F)Object linking and embedding (OLE)
G)Encryption
H)digital certificate
I)certificate authority (CA)
J)source file

Accepted Answer

Encryption is the process of encoding a file so that it can only be accessed by someone who has the correct password or key.

Note: The other options listed are not related to the process of encoding a file with a password.

Question 14

A workbook marked as ____________________ has the editing,typing,and proofing commands turned off.

Accepted Answer

The answer of A workbook marked as ____________________ has the...

Question 15

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Stored within the destination file and remains connected to the source file
A)linked object
B)embedding object
C)PDF (Portable Document Format)
D)Standard properties
E)Custom properties
F)Object linking and embedding (OLE)
G)Encryption
H)digital certificate
I)certificate authority (CA)
J)source file

Accepted Answer

Linked objects are stored within the destination file and remain connected to the source file. This allows any changes made to the source file to be automatically reflected in the destination file.

Question 16

If you cannot obtain a digital certificate from a third party,you can create your own ____________________ certificate,which is a certificate created and signed by the person it certifies.

Accepted Answer

The answer of If you cannot obtain a digital certificate...

Question 17

____________________ refers to the technology that allows one to copy and paste objects,such as graphics files,cells and ranges,and charts,so that information about the program that created the object is included with the object itself.

Accepted Answer

The answer of ____________________ refers to the technology that allows...

Question 18

Explain which of the following screen elements are part of the Excel window,the workbook window,and the worksheet: formula bar,ScreenTips,chart element names on hover,horizontal and vertical scroll bars,row and column headers,sheet tabs,and gridlines.

Accepted Answer

The answer of Explain which of the following screen elements...

Question 19

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Refers to the technology that allows one to copy and paste objects
A)linked object
B)embedding object
C)PDF (Portable Document Format)
D)Standard properties
E)Custom properties
F)Object linking and embedding (OLE)
G)Encryption
H)digital certificate
I)certificate authority (CA)
J)source file

Accepted Answer

Object linking and embedding (OLE) is the technology that allows one to copy and paste objects.

(Note: A linked object is a file that is linked to a document rather than embedded in it. PDF is a file format for representing documents. Standard and custom properties refer to the metadata attached to a file. Encryption, digital certificate, and certificate authority refer to security measures. A source file is the original file from which a copy or variant is derived.)

Question 20

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Contains the object that is displayed in the destination file
A)linked object
B)embedding object
C)PDF (Portable Document Format)
D)Standard properties
E)Custom properties
F)Object linking and embedding (OLE)
G)Encryption
H)digital certificate
I)certificate authority (CA)
J)source file

Accepted Answer

The answer of MATCHING
Identify the letter of the choice that...

Quiz 12: Collaborating on a Shared Workbook

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Stored within the destination file and is no longer part of the source file

MATCHING Identify the letter of the choice that best matches the phrase or definition. -An attachment to a document that authenticates the source of the signature

____________________ is the process by which a file is encoded so that it cannot be opened without the proper password.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Associated with all Office files and include the author,title,and subject

Describe how you can control Excel recalculating Formulas.Discuss the Automatic,Automatic except for data tables,and Manual options.

Describe the steps to review tracked changes in a shared workbook.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Provider of verified digital signatures

Each column of a database table,called a(n)____________________,stores information about a specific characteristic of a person,place,or thing.

A(n)____________________ file contains the object that is displayed in the destination file.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A file format developed by Adobe Systems for displaying formatted documents containing text,graphics,and complicated layouts

The ____________________ acts like a notary public,verifying signatures and tracking those that have expired or been revoked.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Defined and created specifically for a workbook

MATCHING Identify the letter of the choice that best matches the phrase or definition. -The process by which a file is encoded so that it cannot be opened without the proper password

A workbook marked as ____________________ has the editing,typing,and proofing commands turned off.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Stored within the destination file and remains connected to the source file

If you cannot obtain a digital certificate from a third party,you can create your own ____________________ certificate,which is a certificate created and signed by the person it certifies.

____________________ refers to the technology that allows one to copy and paste objects,such as graphics files,cells and ranges,and charts,so that information about the program that created the object is included with the object itself.

Explain which of the following screen elements are part of the Excel window,the workbook window,and the worksheet: formula bar,ScreenTips,chart element names on hover,horizontal and vertical scroll bars,row and column headers,sheet tabs,and gridlines.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Refers to the technology that allows one to copy and paste objects

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Contains the object that is displayed in the destination file