Question 1

After a(n) shared workbook is protected, no one can unprotect or change it except the owner.

Accepted Answer

A) True 
 B)False

Question 2

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Electronic version of sticky notes or annotations in the margin.

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 3

You can use a background image, or watermark, as a worksheet's background.

Accepted Answer

A) True 
 B)False

Question 4

Briefly explain the two ways to print comments.

Accepted Answer

You can print comments where they appear

Question 5

You can tell that a workbook can be opened only by a single user when the text ____________________ no longer is displayed on the title bar.

Accepted Answer

The answer of You can tell that a workbook can...

Question 6

The best way to note suggestions and changes to a worksheet is to write the suggestions on a printed draft copy of the worksheet and send it to the person in charge of the workbook.

Accepted Answer

A) True 
 B)False

Question 7

-____ means working together in cooperation on a document with other Excel users.

Accepted Answer

A)  Collaboration 
B)  Tracking changes 
C)  Adding comments 
D)  Distribution 
A)  Collaboration 
B)  Tracking changes 
C)  Adding comments 
D)  Distribution

Question 8

Which of the following is the path to the Background button?

Accepted Answer

Question 9

You can click the ____ command on the shortcut menu to remove a comment from a worksheet.

Accepted Answer

A)  Remove Comment 
B)  Expunge Comment 
C)  Delete Comment 
D)  Hide Comment 
A)  Remove Comment 
B)  Expunge Comment 
C)  Delete Comment 
D)  Hide Comment

Question 10

____________________ allow certain layout and printing characteristics of a workbook to be saved and then used later.

Accepted Answer

The answer of ____________________ allow certain layout and printing characteristics...

Question 11

You can click the ScreenTip button in the ____ dialog box to add ScreenTip text to a hyperlink.

Accepted Answer

A)  Modify Hyperlink 
B)  Format Hyperlink 
C)  Insert Hyperlink 
D)  Prepare Hyperlink 
A)  Modify Hyperlink 
B)  Format Hyperlink 
C)  Insert Hyperlink 
D)  Prepare Hyperlink

Question 12

Which of the following are disabled when workbook sharing is enabled?

Accepted Answer

A)  Deleting worksheets 
B)  Changing passwords 
C)  Using scenarios 
D)  Using data validation 
E)  None of the above 
A)  Deleting worksheets 
B)  Changing passwords 
C)  Using scenarios 
D)  Using data validation 
E)  None of the above

Question 13

If there is any question about how long it will take to get all copies of a workbook back, you should set a high number of days for recording the ____________________.

Accepted Answer

The answer of If there is any question about how...

Question 14

After testing a hyperlink, the link's formatting is changed to the ____ style.

Accepted Answer

A)  Followed Hyperlink 
B)  Clicked Link 
C)  Used Hyperlink 
D)  Closed Link 
A)  Followed Hyperlink 
B)  Clicked Link 
C)  Used Hyperlink 
D)  Closed Link

Question 15

Briefly discuss how to collaborate on a workbook by sharing it.

Accepted Answer

Sharing involves more than simply giving

Question 16

____________________ provide charts immediately beside the data that creates them, allowing for easy comparison of numerical and graphical data.

Accepted Answer

The answer of ____________________ provide charts immediately beside the data...

Question 17

____ work well when multiple people are collaborating and commenting on a worksheet.

Accepted Answer

A)  Calibrated changes 
B)  Custom views 
C)  Comments 
D)  Themes 
A)  Calibrated changes 
B)  Custom views 
C)  Comments 
D)  Themes

Question 18

Clearing the check mark from the ____________________ check box in the Select Changes to Accept or Reject dialog box indicates that all changes in the change history should be available for review.

Accepted Answer

The answer of Clearing the check mark from the ____________________...

Question 19

XML data always is imported as a(n) ____.

Accepted Answer

A)  key set 
B)  index 
C)  roster 
D)  table 
A)  key set 
B)  index 
C)  roster 
D)  table

Question 20

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-A workbook that is not shared and can be opened only by a single user.

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

After a(n) shared workbook is protected, no one can unprotect or change it except the owner.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Electronic version of sticky notes or annotations in the margin.

You can use a background image, or watermark, as a worksheet's background.

Briefly explain the two ways to print comments.

You can tell that a workbook can be opened only by a single user when the text ____________________ no longer is displayed on the title bar.

The best way to note suggestions and changes to a worksheet is to write the suggestions on a printed draft copy of the worksheet and send it to the person in charge of the workbook.

-____ means working together in cooperation on a document with other Excel users.

Which of the following is the path to the Background button?

You can click the ____ command on the shortcut menu to remove a comment from a worksheet.

____________________ allow certain layout and printing characteristics of a workbook to be saved and then used later.

You can click the ScreenTip button in the ____ dialog box to add ScreenTip text to a hyperlink.

Which of the following are disabled when workbook sharing is enabled?

If there is any question about how long it will take to get all copies of a workbook back, you should set a high number of days for recording the ____________________.

After testing a hyperlink, the link's formatting is changed to the ____ style.

Briefly discuss how to collaborate on a workbook by sharing it.

____________________ provide charts immediately beside the data that creates them, allowing for easy comparison of numerical and graphical data.

____ work well when multiple people are collaborating and commenting on a worksheet.

Clearing the check mark from the ____________________ check box in the Select Changes to Accept or Reject dialog box indicates that all changes in the change history should be available for review.

XML data always is imported as a(n) ____.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A workbook that is not shared and can be opened only by a single user.

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

After a(n) shared workbook is protected, no one can unprotect or change it except the owner.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Electronic version of sticky notes or annotations in the margin.

You can use a background image, or watermark, as a worksheet's background.

Briefly explain the two ways to print comments.

You can tell that a workbook can be opened only by a single user when the text ____________________ no longer is displayed on the title bar.

The best way to note suggestions and changes to a worksheet is to write the suggestions on a printed draft copy of the worksheet and send it to the person in charge of the workbook.

-____ means working together in cooperation on a document with other Excel users.

Which of the following is the path to the Background button?

You can click the ____ command on the shortcut menu to remove a comment from a worksheet.

____________________ allow certain layout and printing characteristics of a workbook to be saved and then used later.

You can click the ScreenTip button in the ____ dialog box to add ScreenTip text to a hyperlink.

Which of the following are disabled when workbook sharing is enabled?

If there is any question about how long it will take to get all copies of a workbook back, you should set a high number of days for recording the ____________________.

After testing a hyperlink, the link's formatting is changed to the ____ style.

Briefly discuss how to collaborate on a workbook by sharing it.

____________________ provide charts immediately beside the data that creates them, allowing for easy comparison of numerical and graphical data.

____ work well when multiple people are collaborating and commenting on a worksheet.

Clearing the check mark from the ____________________ check box in the Select Changes to Accept or Reject dialog box indicates that all changes in the change history should be available for review.

XML data always is imported as a(n) ____.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A workbook that is not shared and can be opened only by a single user.

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