Question 1

Which of the following is not customizable in Excel?

Accepted Answer

A) User name 
B) Backstage view 
C) Quick Access Toolbar 
D) Default font properties 
A) User name 
B) Backstage view 
C) Quick Access Toolbar 
D) Default font properties

Question 2

A(n)________ is a note to a collaborator containing questions or suggestions about the workbook.

Accepted Answer

The answer of A(n)________ is a note to a collaborator...

Question 3

Which of the following is not a method to protect a workbook against changes?

Accepted Answer

A) Enable Sharing 
B) Add a Signature Line 
C) Mark as Final 
D) Export as PDF 
A) Enable Sharing 
B) Add a Signature Line 
C) Mark as Final 
D) Export as PDF

Question 4

A(n)________ colored triangle appears in a cell to indicate a comment.

Accepted Answer

The answer of A(n)________ colored triangle appears in a cell...

Question 5

Hidden comments do not print.

Accepted Answer

A) True 
 B)False

Question 6

A workbook stored in a network location which displays the File in Use dialog box when accessed by more than one user.

Accepted Answer

A) Shared 
B) Nonsharable 
C) Tracked Changes 
D) Private View 
A) Shared 
B) Nonsharable 
C) Tracked Changes 
D) Private View

Question 7

If you didn't use the New Comment command on the Review tab,how would you insert a comment?

Accepted Answer

A) Use the New Comment command on the Home tab. 
B) Right-click and select commenting options. 
C) Right-click on the cell and then select Insert Comment. 
D) Click comment in the status bar. 
A) Use the New Comment command on the Home tab. 
B) Right-click and select commenting options. 
C) Right-click on the cell and then select Insert Comment. 
D) Click comment in the status bar.

Question 8

Compatibility Checker checks workbook content tor incompatibility with previous versions of Excel.

Accepted Answer

A) True 
 B)False

Question 9

Which option is a good option to send a separate,unshared copy of a workbook?

Accepted Answer

A) Google Drive 
B) email 
C) OneDrive 
D) Dropbox 
A) Google Drive 
B) email 
C) OneDrive 
D) Dropbox

Question 10

How would you return to the default installation settings of the Ribbon?

Accepted Answer

A) Click Reset in the Customize Ribbon tab of the ExcelOptions dialog box,and then select Reset all customizations,and then click Yes. 
B) Click Reset in the customize Ribbon tab of the Excel Options dialog box,and then select Reset Group customizations,and then click Yes. 
C) Reinstall Excel. 
D) Right Click on the Ribbon and select return to default. 
A) Click Reset in the Customize Ribbon tab of the ExcelOptions dialog box,and then select Reset all customizations,and then click Yes. 
B) Click Reset in the customize Ribbon tab of the Excel Options dialog box,and then select Reset Group customizations,and then click Yes. 
C) Reinstall Excel. 
D) Right Click on the Ribbon and select return to default.

Question 11

Match between columns
                        Premises: Shared workbook
Compare and Merge Workbooks Workbooks
Collaboration
Resolve Conflicts dialog box
Nonsharable workbook

Accepted Answer

The Answer of Appears when two users make changes to is...

Question 12

Shared workbooks must be in read-only network drives.

Accepted Answer

A) True 
 B)False

Question 13

Match between columns
                        Premises: Mark As Final
Signature Line
Encrypted
Read-only
Digital Signature

Accepted Answer

The Answer of Marks the file as final and makes is...

Question 14

What cloud based storage service is integrated in Excel 2016?

Accepted Answer

A) iCloud 
B) OneDrive 
C) Dropbox 
D) SyncUp 
A) iCloud 
B) OneDrive 
C) Dropbox 
D) SyncUp

Question 15

The ________ checks a workbook for personal data.

Accepted Answer

The answer of The ________ checks a workbook for personal...

Question 16

________ is the process of more than one person working together.

Accepted Answer

The answer of ________ is the process of more than...

Which of the following is not customizable in Excel?

A(n)________ is a note to a collaborator containing questions or suggestions about the workbook.

Which of the following is not a method to protect a workbook against changes?

A(n)________ colored triangle appears in a cell to indicate a comment.

Hidden comments do not print.

A workbook stored in a network location which displays the File in Use dialog box when accessed by more than one user.

If you didn't use the New Comment command on the Review tab,how would you insert a comment?

Compatibility Checker checks workbook content tor incompatibility with previous versions of Excel.

Which option is a good option to send a separate,unshared copy of a workbook?

How would you return to the default installation settings of the Ribbon?

Shared workbooks must be in read-only network drives.

What cloud based storage service is integrated in Excel 2016?

The ________ checks a workbook for personal data.

________ is the process of more than one person working together.

Introduction to Excel

Formulas and Functions

Charts

Datasets and Tables

Subtotals, Pivot-tables, and Pivot-charts

What-If Analysis

Specialized Functions

Statistical Functions

Multiple-Sheet Workbook Management

Imports, xml, and Power Add-Ins

Templates, styles, and Macros

Office 2016 Common Features

Filters

Exam 11: Collaboration and Workbook Distribution

Which of the following is not customizable in Excel?

A(n)________ is a note to a collaborator containing questions or suggestions about the workbook.

Which of the following is not a method to protect a workbook against changes?

A(n)________ colored triangle appears in a cell to indicate a comment.

Hidden comments do not print.

A workbook stored in a network location which displays the File in Use dialog box when accessed by more than one user.

If you didn't use the New Comment command on the Review tab,how would you insert a comment?

Compatibility Checker checks workbook content tor incompatibility with previous versions of Excel.

Which option is a good option to send a separate,unshared copy of a workbook?

How would you return to the default installation settings of the Ribbon?

Shared workbooks must be in read-only network drives.

What cloud based storage service is integrated in Excel 2016?

The ________ checks a workbook for personal data.

________ is the process of more than one person working together.

Introduction to Excel

Formulas and Functions

Charts

Datasets and Tables

Subtotals, Pivot-tables, and Pivot-charts

What-If Analysis

Specialized Functions

Statistical Functions

Multiple-Sheet Workbook Management

Imports, xml, and Power Add-Ins

Templates, styles, and Macros

Office 2016 Common Features

Filters