Question 1

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 2

Which of the following is not an option for changes to review in the Select Changes to Accept or Reject dialog box?

Accepted Answer

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

Question 3

When a file is created, customizations such as the author's name are saved as ________.

Accepted Answer

The answer of When a file is created, customizations such...

Question 4

An Excel template has an .xlxb extension.

Accepted Answer

A) True 
 B)False

Question 5

________ is the cloud service integrated with Excel 2016.

Accepted Answer

The answer of ________ is the cloud service integrated with...

Question 6

The ________ checks a workbook for personal data.

Accepted Answer

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

Question 7

Which file type preserves data and formatting as it was originally intended and makes it uneditable?

Accepted Answer

A) .pdf 
B) .xml 
C) .xlsx 
D) .docx 
A) .pdf 
B) .xml 
C) .xlsx 
D) .docx

Question 8

Workbooks marked as final ALL have passwords.

Accepted Answer

A) True 
 B)False

Question 9

Current Excel files are based on XML.

Accepted Answer

A) True 
 B)False

Question 10

Shared workbooks must be in read-only network drives.

Accepted Answer

A) True 
 B)False

Question 11

Users can see the changes made by other users in a shared workbook.

Accepted Answer

A) True 
 B)False

Question 12

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 13

Match between columns
                        Premises: xlsx
xltx
pdf
xlsm
xls

Accepted Answer

The Answer of Macro enabled Excel workbook and Portable Document is...

Question 14

Match between columns
                        Premises: Contents
Summary
.General
Statistics
Custom

Accepted Answer

The Answer of Displays the worksheet names contained in the is...

Question 15

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 16

Excel uses no metadata in its files.

Accepted Answer

A) True 
 B)False

Question 17

Match between columns
                        Premises: Proofing
Language
Add-ins
Customize Ribbon
General

Accepted Answer

The Answer of ScreenTip language and Personalization: user name, background is...

Question 18

The Quick Access Toolbar cannot be modified.

Accepted Answer

A) True 
 B)False

Question 19

The .xltx extension is the default format for an Excel ________.

Accepted Answer

The answer of The .xltx extension is the default format...

Question 20

Track changes ________.

Accepted Answer

A) records changes to existing cells, but not inserted cells 
B) can record changes by eight people 
C) exports all changes to a Word document log file 
D) records changes to a workbook 
A) records changes to existing cells, but not inserted cells 
B) can record changes by eight people 
C) exports all changes to a Word document log file 
D) records changes to a workbook

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

Which of the following is not an option for changes to review in the Select Changes to Accept or Reject dialog box?

When a file is created, customizations such as the author's name are saved as ________.

An Excel template has an .xlxb extension.

________ is the cloud service integrated with Excel 2016.

The ________ checks a workbook for personal data.

Which file type preserves data and formatting as it was originally intended and makes it uneditable?

Workbooks marked as final ALL have passwords.

Current Excel files are based on XML.

Shared workbooks must be in read-only network drives.

Users can see the changes made by other users in a shared workbook.

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

What cloud based storage service is integrated in Excel 2016?

Excel uses no metadata in its files.

The Quick Access Toolbar cannot be modified.

The .xltx extension is the default format for an Excel ________.

Track changes ________.

Introduction to Excel

Formulas and Functions

Charts

Datasets and Tables

Subtotals, Pivottables, and Pivotcharts

What-If Analysis

Specialized Functions

Statistical Functions

Multiple-Sheet Workbook Management

Imports, Xml, and Power Add-Ins

Templates, Styles, and Macros

Appendix: Exploring Microsoft Office Excel 2016 Comprehensive Poatsygrauer

Filters

Exam 11: Collaboration and Workbook Distribution

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

Which of the following is not an option for changes to review in the Select Changes to Accept or Reject dialog box?

When a file is created, customizations such as the author's name are saved as ________.

An Excel template has an .xlxb extension.

________ is the cloud service integrated with Excel 2016.

The ________ checks a workbook for personal data.

Which file type preserves data and formatting as it was originally intended and makes it uneditable?

Workbooks marked as final ALL have passwords.

Current Excel files are based on XML.

Shared workbooks must be in read-only network drives.

Users can see the changes made by other users in a shared workbook.

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

What cloud based storage service is integrated in Excel 2016?

Excel uses no metadata in its files.

The Quick Access Toolbar cannot be modified.

The .xltx extension is the default format for an Excel ________.

Track changes ________.

Introduction to Excel

Formulas and Functions

Charts

Datasets and Tables

Subtotals, Pivottables, and Pivotcharts

What-If Analysis

Specialized Functions

Statistical Functions

Multiple-Sheet Workbook Management

Imports, Xml, and Power Add-Ins

Templates, Styles, and Macros

Appendix: Exploring Microsoft Office Excel 2016 Comprehensive Poatsygrauer

Filters