Question 1

When the copies of a workbook to be merged into a single workbook are made, ____ must be enabled.

Accepted Answer

A)  track changes 
B)  sharing 
C)  exclusivity 
D)  either a or b 
A)  track changes 
B)  sharing 
C)  exclusivity 
D)  either a or b

Question 2

You can use ____________________ capabilities in Excel, such as inserting shapes, to create your own logos and other images.

Accepted Answer

The answer of You can use ____________________ capabilities in Excel,...

Question 3

A ____ is a special type of XML file used to describe the layout of data in other XML files.

Accepted Answer

A)  note 
B)  schema 
C)  tag 
D)  table 
A)  note 
B)  schema 
C)  tag 
D)  table

Question 4

The needs of the people with whom you will be collaborating are determined by the resources they have.

Accepted Answer

A) True 
 B)False

Question 5

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Working together in cooperation on a document with other Excel users.

Accepted Answer

A) track changes 
B) merging 
C) custom view 
D) comments 
E) sharing a workbook
F)collaborating
G)exclusive workbook
H)tags
I)schema
J)XML map 
A) track changes 
B) merging 
C) custom view 
D) comments 
E) sharing a workbook
F)collaborating
G)exclusive workbook
H)tags
I)schema
J)XML map

Question 6

Which of the following is the path to the 'Add a Hyperlink' button?

Accepted Answer

Question 7

Which of the following is the path to the Share Workbook button?

Accepted Answer

Question 8

The XML group is displayed on the ____________________ tab.

Accepted Answer

The answer of The XML group is displayed on the...

Question 9

Which of the following is the path to the Cell Styles button?

Accepted Answer

Question 10

You can show or hide comments on the worksheet, but you cannot print them.

Accepted Answer

A) True 
 B)False

Question 11

You can open the ____ view and then click the Share tab to view options for distributing a workbook.

Accepted Answer

A)  Backstage 
B)  Full Screen 
C)  Normal 
D)  Page Layout 
A)  Backstage 
B)  Full Screen 
C)  Normal 
D)  Page Layout

Question 12

The Highlight Changes command is located on the ____ menu.

Accepted Answer

A)  Protect Changes 
B)  Show/Hide Changes 
C)  Make Changes 
D)  Track Changes 
A)  Protect Changes 
B)  Show/Hide Changes 
C)  Make Changes 
D)  Track Changes

Question 13

List five requirements that all workbooks must meet before being merged.

Accepted Answer

The five requirements that all workbooks

Question 14

The text ____________________, appearing on the title bar next to the file name, indicates that a workbook is being shared.

Accepted Answer

The answer of The text ____________________, appearing on the title...

Question 15

You must save a shared workbook before you are notified of another user's changes.

Accepted Answer

A) True 
 B)False

Question 16

You can display the Format Comment dialog box by ____________________ selected comment text and then clicking the Format Comment command.

Accepted Answer

pressing a

Question 17

Excel allows you to share and collaborate with others through a variety of features, depending on ____.

Accepted Answer

A)  your resources 
B)  collaborators' resources 
C)  your preferences 
D)  collaborators' preferences 
E)  None of the above 
A)  your resources 
B)  collaborators' resources 
C)  your preferences 
D)  collaborators' preferences 
E)  None of the above

Question 18

You can tap or click the 'Insert a Comment' button ____ to add a new comment to a worksheet.

Accepted Answer

Question 19

A(n) ____ is a schema added to an Excel workbook.

Accepted Answer

A)  XML map 
B)  digital certificate 
C)  tag 
D)  element 
A)  XML map 
B)  digital certificate 
C)  tag 
D)  element

Question 20

To password-protect a shared workbook, tap or click the ____ button (REVIEW tab | Changes group).

Accepted Answer

A)  Workbook Password Assignment 
B)  Protect Shared Workbook 
C)  Share Protected Workbook 
D)  none of the above 
A)  Workbook Password Assignment 
B)  Protect Shared Workbook 
C)  Share Protected Workbook 
D)  none of the above

When the copies of a workbook to be merged into a single workbook are made, ____ must be enabled.

You can use ____________________ capabilities in Excel, such as inserting shapes, to create your own logos and other images.

A ____ is a special type of XML file used to describe the layout of data in other XML files.

The needs of the people with whom you will be collaborating are determined by the resources they have.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Working together in cooperation on a document with other Excel users.

Which of the following is the path to the 'Add a Hyperlink' button?

Which of the following is the path to the Share Workbook button?

The XML group is displayed on the ____________________ tab.

Which of the following is the path to the Cell Styles button?

You can show or hide comments on the worksheet, but you cannot print them.

You can open the ____ view and then click the Share tab to view options for distributing a workbook.

The Highlight Changes command is located on the ____ menu.

List five requirements that all workbooks must meet before being merged.

The text ____________________, appearing on the title bar next to the file name, indicates that a workbook is being shared.

You must save a shared workbook before you are notified of another user's changes.

You can display the Format Comment dialog box by ____________________ selected comment text and then clicking the Format Comment command.

Excel allows you to share and collaborate with others through a variety of features, depending on ____.

You can tap or click the 'Insert a Comment' button ____ to add a new comment to a worksheet.

A(n) ____ is a schema added to an Excel workbook.

To password-protect a shared workbook, tap or click the ____ button (REVIEW tab | Changes group).

Essential Concepts and Skills

Creating a Worksheet and a Chart

Formulas, Functions, and Formatting

Working With Large Worksheets, Charting, and What-If Analysis

Working With Multiple Worksheets and Workbooks

Financial Functions, Data Tables, and Amortization Schedules

Creating, Sorting, and Querying a Table

Creating Templates, Manipulating Data, and Adding Additional Enhancements to a Worksheet

Working With Trendlines, Pivot Table Reports, Pivotchart Reports, and Slicers

Formula Auditing, Data Validation, and Complex Problem Solving

Using Macros and Visual Basic for Applications Vba With Excel

Filters

Exam 12: Collaboration Features for Workbooks

When the copies of a workbook to be merged into a single workbook are made, ____ must be enabled.

You can use ____________________ capabilities in Excel, such as inserting shapes, to create your own logos and other images.

A ____ is a special type of XML file used to describe the layout of data in other XML files.

The needs of the people with whom you will be collaborating are determined by the resources they have.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Working together in cooperation on a document with other Excel users.

Which of the following is the path to the 'Add a Hyperlink' button?

Which of the following is the path to the Share Workbook button?

The XML group is displayed on the ____________________ tab.

Which of the following is the path to the Cell Styles button?

You can show or hide comments on the worksheet, but you cannot print them.

You can open the ____ view and then click the Share tab to view options for distributing a workbook.

The Highlight Changes command is located on the ____ menu.

List five requirements that all workbooks must meet before being merged.

The text ____________________, appearing on the title bar next to the file name, indicates that a workbook is being shared.

You must save a shared workbook before you are notified of another user's changes.

You can display the Format Comment dialog box by ____________________ selected comment text and then clicking the Format Comment command.

Excel allows you to share and collaborate with others through a variety of features, depending on ____.

You can tap or click the 'Insert a Comment' button ____ to add a new comment to a worksheet.

A(n) ____ is a schema added to an Excel workbook.

To password-protect a shared workbook, tap or click the ____ button (REVIEW tab | Changes group).

Essential Concepts and Skills

Creating a Worksheet and a Chart

Formulas, Functions, and Formatting

Working With Large Worksheets, Charting, and What-If Analysis

Working With Multiple Worksheets and Workbooks

Financial Functions, Data Tables, and Amortization Schedules

Creating, Sorting, and Querying a Table

Creating Templates, Manipulating Data, and Adding Additional Enhancements to a Worksheet

Working With Trendlines, Pivot Table Reports, Pivotchart Reports, and Slicers

Formula Auditing, Data Validation, and Complex Problem Solving

Using Macros and Visual Basic for Applications Vba With Excel

Filters