Question 1

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 D

Question 2

To share a workbook you must post it to a network server.

Accepted Answer

A) True 
 B)False  False

Question 3

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  False

Question 4

You can use the _____ form control to position a set of option buttons together.​

Accepted Answer

A)  ​Group Box 
B)  ​Spin Button 
C)  ​Label 
D)  ​Scroll Bar 
A)  ​Group Box 
B)  ​Spin Button 
C)  ​Label 
D)  ​Scroll Bar

Question 5

It is highly unusual to find different versions of software being used within the same company.

Accepted Answer

A) True 
 B)False

Question 6

The Protect Sheet button is located on the _____ tab.​

Accepted Answer

A)  ​CODE 
B)  ​PROTECT 
C)  ​DEVELOPER 
D)  ​REVIEW 
A)  ​CODE 
B)  ​PROTECT 
C)  ​DEVELOPER 
D)  ​REVIEW

Question 7

Which of the following is the path to the Unprotect Sheet button?

Accepted Answer

Question 8

You can click the ____ button to turn on / off the view of all comments.

Accepted Answer

A)  View All Comments 
B)  Display All Comments 
C)  Comments On / Off 
D)  Show All Comments 
A)  View All Comments 
B)  Display All Comments 
C)  Comments On / Off 
D)  Show All Comments

Question 9

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

Accepted Answer

Question 10

You must first unhide comments before you can edit them.

Accepted Answer

A) True 
 B)False

Question 11

Excel keeps a change history with each shared workbook.

Accepted Answer

A) True 
 B)False

Question 12

Turning off track changes also turns off sharing and saves the workbook.

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

A(n)____ can be used to provide a reminder to the user.

Accepted Answer

A)  clone 
B)  watermark 
C)  formatted shape 
D)  indexed transparency 
A)  clone 
B)  watermark 
C)  formatted shape 
D)  indexed transparency

Question 15

Which of the following is the path to the Delete Comment button?

Accepted Answer

Question 16

Each copy of a workbook to be merged must have a different ____.

Accepted Answer

A)  password 
B)  path 
C)  file name 
D)  number of worksheets 
A)  password 
B)  path 
C)  file name 
D)  number of worksheets

Question 17

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

Accepted Answer

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

Sharing workbooks allows users to view and scroll worksheets side by side._________________________

Accepted Answer

A) True 
 B)False

Question 20

Which of the following are options you can click in the Select Changes to Accept or Reject dialog box?

Accepted Answer

A)  When 
B)  How 
C)  Who 
D)  Where 
A)  When 
B)  How 
C)  Who 
D)  Where

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

To share a workbook you must post it to a network server.

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.

You can use the _____ form control to position a set of option buttons together.

It is highly unusual to find different versions of software being used within the same company.

The Protect Sheet button is located on the _____ tab.

Which of the following is the path to the Unprotect Sheet button?

You can click the ____ button to turn on / off the view of all comments.

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

You must first unhide comments before you can edit them.

Excel keeps a change history with each shared workbook.

Turning off track changes also turns off sharing and saves the workbook.

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

A(n)____ can be used to provide a reminder to the user.

Which of the following is the path to the Delete Comment button?

Each copy of a workbook to be merged must have a different ____.

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

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

Sharing workbooks allows users to view and scroll worksheets side by side._________________________

Which of the following are options you can click in the Select Changes to Accept or Reject dialog box?

Creating a Worksheet and a Chart

Formulas, Functions, and Formatting

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

Financial Functions, Data Tables, and Amortization Schedules

Working With Multiple Worksheets and Workbooks

Creating, Sorting, and Querying a Table

Creating Templates, Importing Data, and Working With Smartart, Images, and Screenshots

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

Essential Concepts and Skills

Productivity App: Productivity Apps for School and Work

Filters

Exam 11: Collaboration Features for Workbooks

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

To share a workbook you must post it to a network server.

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.

You can use the _____ form control to position a set of option buttons together.​

It is highly unusual to find different versions of software being used within the same company.

The Protect Sheet button is located on the _____ tab.​

Which of the following is the path to the Unprotect Sheet button?

You can click the ____ button to turn on / off the view of all comments.

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

You must first unhide comments before you can edit them.

Excel keeps a change history with each shared workbook.

Turning off track changes also turns off sharing and saves the workbook.

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

A(n)____ can be used to provide a reminder to the user.

Which of the following is the path to the Delete Comment button?

Each copy of a workbook to be merged must have a different ____.

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

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

Sharing workbooks allows users to view and scroll worksheets side by side._________________________

Which of the following are options you can click in the Select Changes to Accept or Reject dialog box?

Creating a Worksheet and a Chart

Formulas, Functions, and Formatting

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

Financial Functions, Data Tables, and Amortization Schedules

Working With Multiple Worksheets and Workbooks

Creating, Sorting, and Querying a Table

Creating Templates, Importing Data, and Working With Smartart, Images, and Screenshots

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

Essential Concepts and Skills

Productivity App: Productivity Apps for School and Work

Filters

You can use the _____ form control to position a set of option buttons together.

The Protect Sheet button is located on the _____ tab.