Question 1

A cell that contains a comment is marked with a green triangle.

Accepted Answer

A) True 
 B)False

Question 2

A workbook marked as final is shared.

Accepted Answer

A) True 
 B)False

Question 3

Click the ________ command on the Review Tab to begin tracking changes.

Accepted Answer

A) Change Log 
B) Track Changes 
C) Logging 
D) Highlight Changes 
A) Change Log 
B) Track Changes 
C) Logging 
D) Highlight Changes

Question 4

Which of the following is not an option in the Properties dialog box?

Accepted Answer

A) General 
B) Data 
C) Summary 
D) Statistics 
A) General 
B) Data 
C) Summary 
D) Statistics

Question 5

The ________ dialog box appears if more than one person makes changes in a cell at the same time

Accepted Answer

The answer of The ________ dialog box appears if more...

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

A comment can be inserted to provide notes or feedback to other users of a workbook.

Accepted Answer

A) True 
 B)False

Question 8

Track Changes works only on ________ workbooks.

Accepted Answer

A) non-shareable 
B) shared 
C) read only 
D) enabled 
A) non-shareable 
B) shared 
C) read only 
D) enabled

Question 9

Change tracking is available only in shared workbooks.

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

Which of the following is not checked by the Accessibility Checker?

Accepted Answer

A) Alt Text 
B) Merged Cells 
C) Print Area 
D) Table Headers 
A) Alt Text 
B) Merged Cells 
C) Print Area 
D) Table Headers

Question 12

What is metadata?

Accepted Answer

A) The data schema 
B) The file path of a file. 
C) A tool to measure data quality 
D) Data that describes other data 
A) The data schema 
B) The file path of a file. 
C) A tool to measure data quality 
D) Data that describes other data

Question 13

Merge Cells is available while change tracking is turned on.

Accepted Answer

A) True 
 B)False

Question 14

Match between columns
                        Premises: Unsupported Features
Compatibility Checker
Accessibility Checker
Document Inspector
Change Tracking

Accepted Answer

The Answer of Logs all changes in a workbook and is...

Question 15

If another user has a ________ workbook open and you try to open it, the File in Use dialog box will display.

Accepted Answer

The answer of If another user has a ________ workbook...

Question 16

A(n)________ is a workbook that can be viewed and edited simultaneously by multiple users.

Accepted Answer

The answer of A(n)________ is a workbook that can be...

A cell that contains a comment is marked with a green triangle.

A workbook marked as final is shared.

Click the ________ command on the Review Tab to begin tracking changes.

Which of the following is not an option in the Properties dialog box?

The ________ dialog box appears if more than one person makes changes in a cell at the same time

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

A comment can be inserted to provide notes or feedback to other users of a workbook.

Track Changes works only on ________ workbooks.

Change tracking is available only in shared workbooks.

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

Which of the following is not checked by the Accessibility Checker?

What is metadata?

Merge Cells is available while change tracking is turned on.

If another user has a ________ workbook open and you try to open it, the File in Use dialog box will display.

A(n)________ is a workbook that can be viewed and edited simultaneously by multiple users.

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

A cell that contains a comment is marked with a green triangle.

A workbook marked as final is shared.

Click the ________ command on the Review Tab to begin tracking changes.

Which of the following is not an option in the Properties dialog box?

The ________ dialog box appears if more than one person makes changes in a cell at the same time

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

A comment can be inserted to provide notes or feedback to other users of a workbook.

Track Changes works only on ________ workbooks.

Change tracking is available only in shared workbooks.

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

Which of the following is not checked by the Accessibility Checker?

What is metadata?

Merge Cells is available while change tracking is turned on.

If another user has a ________ workbook open and you try to open it, the File in Use dialog box will display.

A(n)________ is a workbook that can be viewed and edited simultaneously by multiple users.

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