Question 1

When working with multiple copies of the same workbook, the same cell can contain different values in the various copies of the workbook.

Accepted Answer

A) True 
 B)False  True

Question 2

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Puts restrictions on the types of edits a user can make.

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 E

Question 3

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Marking who changed what data, in which cell, and when.

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 A

Question 4

You can click the ____________________ button to protect the change history associated with a shared workbook.

Accepted Answer

Protect Sh

Question 5

If both you and another user change the same cell in a shared workbook, Excel displays a(n) ____________________ dialog box when the workbook is saved.

Accepted Answer

The answer of If both you and another user change...

Question 6

A workbook which is not shared and can be opened only by a single user is called an ____ workbook.

Accepted Answer

A)  exclusive 
B)  embargoed 
C)  engaging 
D)  enabled 
A)  exclusive 
B)  embargoed 
C)  engaging 
D)  enabled

Question 7

Workbooks to be merged can have different passwords.

Accepted Answer

A) True 
 B)False

Question 8

Which of the following buttons will enable two worksheets to scroll at the same time so that you can make a visual comparison of the workbooks?

Accepted Answer

A)  Reset Window Position 
B)  Synchronous Scrolling 
C)  Dual Scroll 
D)  Active Scroll 
A)  Reset Window Position 
B)  Synchronous Scrolling 
C)  Dual Scroll 
D)  Active Scroll

Question 9

Shared workbooks must be ____ within the number of days specified to record the change history.

Accepted Answer

A)  tracked 
B)  merged 
C)  saved 
D)  circulated 
A)  tracked 
B)  merged 
C)  saved 
D)  circulated

Question 10

You must first unhide comments before you can edit them.

Accepted Answer

A) True 
 B)False

Question 11

Case 11-1
You have been invited to present a brief "Tips and Tricks" presentation at the next Excel Users Group meeting. You plan to focus on keyboard shortcuts; however, you realize that most members of the Excel Users Group are familiar with keyboard shortcuts for basic tasks. You decide to focus on keyboard shortcuts for popular advanced Excel features.
-Another popular topic with the group's members is the use of hyperlinks in workbooks. You know that a keyboard shortcut key combination is available for opening the Insert Hyperlink dialog box, but cannot remember it. When you search Excel Help, you find that the ____ keyboard shortcut key combination is used to create hyperlinks, so you add it to your "Tips and Tricks" presentation examples.

Accepted Answer

A)  F12 
B)  SHIFT+D 
C)  CTRL+K 
D)  ALT+CTRL+H 
A)  F12 
B)  SHIFT+D 
C)  CTRL+K 
D)  ALT+CTRL+H

Question 12

In order to merge multiple workbooks, each workbook must be a copy of the same workbook.

Accepted Answer

A) True 
 B)False

Question 13

Merging multiple copies of a workbook requires no special setup.

Accepted Answer

A) True 
 B)False

Question 14

Which of the following is the path to the Custom Views button?

Accepted Answer

Question 15

You can edit a comment using a shortcut menu.

Accepted Answer

A) True 
 B)False

Question 16

Which of the following are effective workbook collaboration options?

Accepted Answer

A)  Distributing a workbook to others physically or electronically 
B)  Sharing a workbook 
C)  Participating in discussion threads or online meetings using a service, such as SharePoint Services with Microsoft Office 2013 
D)  Pasting a workbook object on a PowerPoint slide 
A)  Distributing a workbook to others physically or electronically 
B)  Sharing a workbook 
C)  Participating in discussion threads or online meetings using a service, such as SharePoint Services with Microsoft Office 2013 
D)  Pasting a workbook object on a PowerPoint slide

Question 17

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-An XML schema in Excel.

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 18

Excel's ____________________ feature allows users to enter suggested changes directly in the workbook.

Accepted Answer

The answer of Excel's ____________________ feature allows users to enter...

Question 19

Excel erases the change history when track changes is enabled.

Accepted Answer

A) True 
 B)False

Question 20

If either ____ or sharing is enabled, Excel enables the other by default.

Accepted Answer

A)  distributing 
B)  formatting 
C)  collaborating 
D)  tracking 
A)  distributing 
B)  formatting 
C)  collaborating 
D)  tracking

When working with multiple copies of the same workbook, the same cell can contain different values in the various copies of the workbook.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Puts restrictions on the types of edits a user can make.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Marking who changed what data, in which cell, and when.

You can click the ____________________ button to protect the change history associated with a shared workbook.

If both you and another user change the same cell in a shared workbook, Excel displays a(n) ____________________ dialog box when the workbook is saved.

A workbook which is not shared and can be opened only by a single user is called an ____ workbook.

Workbooks to be merged can have different passwords.

Which of the following buttons will enable two worksheets to scroll at the same time so that you can make a visual comparison of the workbooks?

Shared workbooks must be ____ within the number of days specified to record the change history.

You must first unhide comments before you can edit them.

In order to merge multiple workbooks, each workbook must be a copy of the same workbook.

Merging multiple copies of a workbook requires no special setup.

Which of the following is the path to the Custom Views button?

You can edit a comment using a shortcut menu.

Which of the following are effective workbook collaboration options?

MATCHING Identify the letter of the choice that best matches the phrase or definition. -An XML schema in Excel.

Excel's ____________________ feature allows users to enter suggested changes directly in the workbook.

Excel erases the change history when track changes is enabled.

If either ____ or sharing is enabled, Excel enables the other by default.

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 working with multiple copies of the same workbook, the same cell can contain different values in the various copies of the workbook.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Puts restrictions on the types of edits a user can make.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Marking who changed what data, in which cell, and when.

You can click the ____________________ button to protect the change history associated with a shared workbook.

If both you and another user change the same cell in a shared workbook, Excel displays a(n) ____________________ dialog box when the workbook is saved.

A workbook which is not shared and can be opened only by a single user is called an ____ workbook.

Workbooks to be merged can have different passwords.

Which of the following buttons will enable two worksheets to scroll at the same time so that you can make a visual comparison of the workbooks?

Shared workbooks must be ____ within the number of days specified to record the change history.

You must first unhide comments before you can edit them.

In order to merge multiple workbooks, each workbook must be a copy of the same workbook.

Merging multiple copies of a workbook requires no special setup.

Which of the following is the path to the Custom Views button?

You can edit a comment using a shortcut menu.

Which of the following are effective workbook collaboration options?

MATCHING Identify the letter of the choice that best matches the phrase or definition. -An XML schema in Excel.

Excel's ____________________ feature allows users to enter suggested changes directly in the workbook.

Excel erases the change history when track changes is enabled.

If either ____ or sharing is enabled, Excel enables the other by default.

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