Question 1

You can edit a comment using a shortcut menu.

Accepted Answer

A) True 
 B)False

Question 2

Calibrated changes are the electronic version of sticky notes.

Accepted Answer

A) True 
 B)False

Question 3

Comments added by each user are identified by a name in the comment,set by the user.

Accepted Answer

A) True 
 B)False

Question 4

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 5

In which of the following modes can you set the properties that determine a control's appearance and behavior?​

Accepted Answer

A)  ​Run 
B)  ​Design 
C)  ​Execute 
D)  ​Modify 
A)  ​Run 
B)  ​Design 
C)  ​Execute 
D)  ​Modify

Question 6

When a workbook is shared with other users,changes made and saved by the other users are visible only when you attempt to save changes.

Accepted Answer

A) True 
 B)False

Question 7

Merging multiple copies of a workbook requires no special setup.

Accepted Answer

A) True 
 B)False

Question 8

Excel has the capability to mark who changed what data,in which cell,and when.

Accepted Answer

A) True 
 B)False

Question 9

Which of the following is the path to the Track Changes button?

Accepted Answer

Question 10

____ 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 11

Which of the following are effective workbook collaboration options?

Accepted Answer

A)  Sharing a workbook 
B)  Participating in discussion threads or online meetings using a service,such as SharePoint Services with Microsoft Office 2016 
A)  Sharing a workbook 
B)  Participating in discussion threads or online meetings using a service,such as SharePoint Services with Microsoft Office 2016

Question 12

Excel erases the change history when track changes is enabled.

Accepted Answer

A) True 
 B)False

Question 13

Saving on OneDrive to distribute workbooks by necessity differs from saving on OneDrive when saving your own files.

Accepted Answer

A) True 
 B)False

Question 14

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 15

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

Accepted Answer

A) True 
 B)False

Question 16

You can add a new comment by clicking the Insert Comment command on a shortcut menu.

Accepted Answer

A) True 
 B)False

Question 17

Which of the following is the path to the 'View Side by Side' button?

Accepted Answer

Question 18

_____ controls require no knowledge of VBA to be used.​

Accepted Answer

A)  ​Dynamic object 
B)  ​Form 
C)  ​ActiveX 
D)  ​Worksheet management 
A)  ​Dynamic object 
B)  ​Form 
C)  ​ActiveX 
D)  ​Worksheet management

Question 19

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

Accepted Answer

Question 20

Workbooks to be merged can have different passwords.

Accepted Answer

A) True 
 B)False

You can edit a comment using a shortcut menu.

Calibrated changes are the electronic version of sticky notes.

Comments added by each user are identified by a name in the comment,set by the user.

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

In which of the following modes can you set the properties that determine a control's appearance and behavior?

When a workbook is shared with other users,changes made and saved by the other users are visible only when you attempt to save changes.

Merging multiple copies of a workbook requires no special setup.

Excel has the capability to mark who changed what data,in which cell,and when.

Which of the following is the path to the Track Changes button?

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

Which of the following are effective workbook collaboration options?

Excel erases the change history when track changes is enabled.

Saving on OneDrive to distribute workbooks by necessity differs from saving on OneDrive when saving your own files.

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

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

You can add a new comment by clicking the Insert Comment command on a shortcut menu.

Which of the following is the path to the 'View Side by Side' button?

_____ controls require no knowledge of VBA to be used.

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

Workbooks to be merged can have different passwords.

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

You can edit a comment using a shortcut menu.

Calibrated changes are the electronic version of sticky notes.

Comments added by each user are identified by a name in the comment,set by the user.

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

In which of the following modes can you set the properties that determine a control's appearance and behavior?​

When a workbook is shared with other users,changes made and saved by the other users are visible only when you attempt to save changes.

Merging multiple copies of a workbook requires no special setup.

Excel has the capability to mark who changed what data,in which cell,and when.

Which of the following is the path to the Track Changes button?

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

Which of the following are effective workbook collaboration options?

Excel erases the change history when track changes is enabled.

Saving on OneDrive to distribute workbooks by necessity differs from saving on OneDrive when saving your own files.

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

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

You can add a new comment by clicking the Insert Comment command on a shortcut menu.

Which of the following is the path to the 'View Side by Side' button?

_____ controls require no knowledge of VBA to be used.​

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

Workbooks to be merged can have different passwords.

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

In which of the following modes can you set the properties that determine a control's appearance and behavior?

_____ controls require no knowledge of VBA to be used.