Question 1

The following condition must be met to merge two or more workbooks:

Accepted Answer

A) The copies must originate from different shared files. 
B) The copies cannot have different filenames. 
C) The Track Changes feature must be turned off for all copies. 
D) The copies must either have the same password or not be password-protected. 
A) The copies must originate from different shared files. 
B) The copies cannot have different filenames. 
C) The Track Changes feature must be turned off for all copies. 
D) The copies must either have the same password or not be password-protected.

Question 2

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Contains data in an XML document

Accepted Answer

A) delimiter 
B) database 
C) record 
D) field 
E) table
F)query
G)criteria
H)common field
I)element
J)Rich Text 
A) delimiter 
B) database 
C) record 
D) field 
E) table
F)query
G)criteria
H)common field
I)element
J)Rich Text

Question 3

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

Accepted Answer

A) linked object 
B) embedding object 
C) PDF (Portable Document Format) 
D) Standard properties 
E) Custom properties
F)Object linking and embedding (OL
E) 
G)Encryption
H)digital certificate
I)certificate authority (C
A) 
J)source file 
A) linked object 
B) embedding object 
C) PDF (Portable Document Format) 
D) Standard properties 
E) Custom properties
F)Object linking and embedding (OL
E) 
G)Encryption
H)digital certificate
I)certificate authority (C
A) 
J)source file

Question 4

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Collection of data organized to be easily retrieved and used by the end user

Accepted Answer

A) delimiter 
B) database 
C) record 
D) field 
E) table
F)query
G)criteria
H)common field
I)element
J)Rich Text 
A) delimiter 
B) database 
C) record 
D) field 
E) table
F)query
G)criteria
H)common field
I)element
J)Rich Text

Question 5

The Document Inspector will remove comments,annotations,document properties,and personal information from a shared workbook.

Accepted Answer

A) True 
 B)False

Question 6

-In the accompany figure,item _______ identifies the date and time of the edit.

Accepted Answer

A) 1 
B) 2 
C) 3 
D) 5 
A) 1 
B) 2 
C) 3 
D) 5

Question 7

A(n)____________________ is a data location that Excel will access without prompting you to confirm that the connection is secure.

Accepted Answer

The answer of A(n)____________________ is a data location that Excel...

Question 8

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

Accepted Answer

A) linked object 
B) embedding object 
C) PDF (Portable Document Format) 
D) Standard properties 
E) Custom properties
F)Object linking and embedding (OL
E) 
G)Encryption
H)digital certificate
I)certificate authority (C
A) 
J)source file 
A) linked object 
B) embedding object 
C) PDF (Portable Document Format) 
D) Standard properties 
E) Custom properties
F)Object linking and embedding (OL
E) 
G)Encryption
H)digital certificate
I)certificate authority (C
A) 
J)source file

Question 9

Data ____________________ can be databases,text files,or other Excel workbooks.

Accepted Answer

The answer of Data ____________________ can be databases,text files,or other...

Question 10

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Format that allows for text formatting styles including boldface,italic,and color

Accepted Answer

A) delimiter 
B) database 
C) record 
D) field 
E) table
F)query
G)criteria
H)common field
I)element
J)Rich Text 
A) delimiter 
B) database 
C) record 
D) field 
E) table
F)query
G)criteria
H)common field
I)element
J)Rich Text

Question 11

_______ displays and stores an object within the destination file.

Accepted Answer

A) Copy and Paste 
B) Linking 
C) Embedding 
D) Inserting 
A) Copy and Paste 
B) Linking 
C) Embedding 
D) Inserting

Question 12

What are the steps to filter data in a query?

Accepted Answer

In the first step of the Query Wizard,se

Question 13

-In the accompanying figure,item _______ displays the description of the edit.

Accepted Answer

A) 1 
B) 3 
C) 4 
D) 5 
A) 1 
B) 3 
C) 4 
D) 5

Question 14

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

Accepted Answer

A) Custom 
B) Standard 
C) Automatically updated 
D) Organization 
A) Custom 
B) Standard 
C) Automatically updated 
D) Organization

Question 15

The Standard option optimizes the _______ for use with online publishing and printing.

Accepted Answer

A) DOCX 
B) PDF 
C) XPS 
D) HTML 
A) DOCX 
B) PDF 
C) XPS 
D) HTML

Question 16

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

Accepted Answer

A) source 
B) object 
C) beginning 
D) completed 
A) source 
B) object 
C) beginning 
D) completed

Question 17

Chloe is building a kiosk-based Excel application. She wants to make some modifications to the screen elements in order to keep users from being distracted by parts of the application that are irrelevant to her application. She turns to Henry for guidance as she knows he built a similar solution earlier this year.
-Where in the Excel Options dialog box would Chloe find the setting to change the default location for Excel workbook files?

Accepted Answer

A) Advanced options, Display section 
B) Advanced options, Editing options section 
C) Save options 
D) Formulas options 
A) Advanced options, Display section 
B) Advanced options, Editing options section 
C) Save options 
D) Formulas options

Question 18

The encryption password is _______ the passwords that prevent users from editing a worksheet or the entire workbook.

Accepted Answer

A) similar to 
B) different from 
C) modified from 
D) copied from 
A) similar to 
B) different from 
C) modified from 
D) copied from

Question 19

The $\underline {\text { Standard }}$ option optimizes the PDF for use with online publishing and printing._________________________

Accepted Answer

A) True 
 B)False

Question 20

Digital signatures provide a way for the author to authenticate the document by "signing off" on it.

Accepted Answer

A) True 
 B)False

The following condition must be met to merge two or more workbooks:

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Contains data in an XML document

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. -Collection of data organized to be easily retrieved and used by the end user

The Document Inspector will remove comments,annotations,document properties,and personal information from a shared workbook.

-In the accompany figure,item _______ identifies the date and time of the edit.

A(n)____________________ is a data location that Excel will access without prompting you to confirm that the connection is secure.

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

Data ____________________ can be databases,text files,or other Excel workbooks.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Format that allows for text formatting styles including boldface,italic,and color

_______ displays and stores an object within the destination file.

What are the steps to filter data in a query?

-In the accompanying figure,item _______ displays the description of the edit.

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

The Standard option optimizes the _______ for use with online publishing and printing.

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

The encryption password is _______ the passwords that prevent users from editing a worksheet or the entire workbook.

The $\underline {\text { Standard }}$ option optimizes the PDF for use with online publishing and printing._________________________

Digital signatures provide a way for the author to authenticate the document by "signing off" on it.

Getting Started With Excel

Formatting Workbook Text and Data

Calculating Data With Formulas and Functions

Analyzing and Charting Financial Data

Working With Excel Tables, Pivot-tables, and Pivot-charts

Managing Multiple Worksheets and Workbooks

Developing an Excel Application

Working With Advanced Functions

Exploring Financial Tools and Functions

Performing What If Analyses

Connecting to External Data

Managing Your Files

Filters

Exam 12: Collaborating on a Shared Workbook

The following condition must be met to merge two or more workbooks:

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Contains data in an XML document

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. -Collection of data organized to be easily retrieved and used by the end user

The Document Inspector will remove comments,annotations,document properties,and personal information from a shared workbook.

-In the accompany figure,item _______ identifies the date and time of the edit.

A(n)____________________ is a data location that Excel will access without prompting you to confirm that the connection is secure.

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

Data ____________________ can be databases,text files,or other Excel workbooks.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Format that allows for text formatting styles including boldface,italic,and color

_______ displays and stores an object within the destination file.

What are the steps to filter data in a query?

-In the accompanying figure,item _______ displays the description of the edit.

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

The Standard option optimizes the _______ for use with online publishing and printing.

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

The encryption password is _______ the passwords that prevent users from editing a worksheet or the entire workbook.

The Standard ‾\underline {\text { Standard }} Standard ​ option optimizes the PDF for use with online publishing and printing._________________________

Digital signatures provide a way for the author to authenticate the document by "signing off" on it.

Getting Started With Excel

Formatting Workbook Text and Data

Calculating Data With Formulas and Functions

Analyzing and Charting Financial Data

Working With Excel Tables, Pivot-tables, and Pivot-charts

Managing Multiple Worksheets and Workbooks

Developing an Excel Application

Working With Advanced Functions

Exploring Financial Tools and Functions

Performing What If Analyses

Connecting to External Data

Managing Your Files

Filters

The $\underline {\text { Standard }}$ option optimizes the PDF for use with online publishing and printing._________________________