Question 1

Creating a list of changes in a ________ may be a good idea before accepting or rejecting changes.

Accepted Answer

A) change log 
B) history worksheet 
C) history log 
D) metadata log 
A) change log 
B) history worksheet 
C) history log 
D) metadata log

Question 2

Use the ________ to make sure your files are backwardly compatible.

Accepted Answer

Compatibil

Question 3

Match between columns
                        Premises: Statistics
Contents
General
Summary
Custom

Accepted Answer

The Answer of Enables the user to create and maintain is...

Question 4

Excel uses no metadata in its files.

Accepted Answer

A) True 
 B)False

Question 5

If you send an email link to a workbook,the recipients of the file have access to change the original file on your computer.

Accepted Answer

A) True 
 B)False

Question 6

The Office ________ controls the faint image in the top right corner of the title bar.

Accepted Answer

The answer of The Office ________ controls the faint image...

Question 7

A signature line in a workbook makes it read-only.

Accepted Answer

A) True 
 B)False

Question 8

Match between columns
                        Premises: xls
.xltx
xlsm
.xlsx
.pdf

Accepted Answer

The Answer of Excel Template and Legacy Excel format and is...

Question 9

Google docs and OpenOffice use ________ file extensions for spreadsheets.

Accepted Answer

The answer of Google docs and OpenOffice use ________ file...

Question 10

The Share Workbook command is on the ________ tab.

Accepted Answer

The answer of The Share Workbook command is on the...

Question 11

You can export Quick Access Toolbar settings to other users.

Accepted Answer

A) True 
 B)False

Question 12

The default setting for printing comments is ________.

Accepted Answer

A) Print in place 
B) Print at end 
C) not to print 
D) only displayed comments 
A) Print in place 
B) Print at end 
C) not to print 
D) only displayed comments

Question 13

Which of the following is not a tool to check a workbook for issues?

Accepted Answer

A) File Inspector 
B) Compatibility Inspector 
C) Document Inspector 
D) Accessibility Inspector 
A) File Inspector 
B) Compatibility Inspector 
C) Document Inspector 
D) Accessibility Inspector

Question 14

A shared workbook cannot be merged using the Compare and Merge Workbooks tool.

Accepted Answer

A) True 
 B)False

Question 15

The user cannot change automatically updated properties.

Accepted Answer

A) True 
 B)False

Question 16

________ is the cloud service integrated with Excel 2016.

Accepted Answer

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

Question 17

What is the first step for each user when running the Compare and Merge Workbooks tool?

Accepted Answer

A) Removing all tables 
B) Making all files read only 
C) Saving their file with a unique file name 
D) Moving all files to a different folder 
A) Removing all tables 
B) Making all files read only 
C) Saving their file with a unique file name 
D) Moving all files to a different folder

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

To Mark Workbook as Final,click ________ in the Backstage view.

Accepted Answer

The answer of To Mark Workbook as Final,click ________ in...

Question 20

The default setting is all comments in a worksheet are ________ when printing.

Accepted Answer

The answer of The default setting is all comments in...

Creating a list of changes in a ________ may be a good idea before accepting or rejecting changes.

Use the ________ to make sure your files are backwardly compatible.

Excel uses no metadata in its files.

If you send an email link to a workbook,the recipients of the file have access to change the original file on your computer.

The Office ________ controls the faint image in the top right corner of the title bar.

A signature line in a workbook makes it read-only.

Google docs and OpenOffice use ________ file extensions for spreadsheets.

The Share Workbook command is on the ________ tab.

You can export Quick Access Toolbar settings to other users.

The default setting for printing comments is ________.

Which of the following is not a tool to check a workbook for issues?

A shared workbook cannot be merged using the Compare and Merge Workbooks tool.

The user cannot change automatically updated properties.

________ is the cloud service integrated with Excel 2016.

What is the first step for each user when running the Compare and Merge Workbooks tool?

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

To Mark Workbook as Final,click ________ in the Backstage view.

The default setting is all comments in a worksheet are ________ when printing.

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

Creating a list of changes in a ________ may be a good idea before accepting or rejecting changes.

Use the ________ to make sure your files are backwardly compatible.

Excel uses no metadata in its files.

If you send an email link to a workbook,the recipients of the file have access to change the original file on your computer.

The Office ________ controls the faint image in the top right corner of the title bar.

A signature line in a workbook makes it read-only.

Google docs and OpenOffice use ________ file extensions for spreadsheets.

The Share Workbook command is on the ________ tab.

You can export Quick Access Toolbar settings to other users.

The default setting for printing comments is ________.

Which of the following is not a tool to check a workbook for issues?

A shared workbook cannot be merged using the Compare and Merge Workbooks tool.

The user cannot change automatically updated properties.

________ is the cloud service integrated with Excel 2016.

What is the first step for each user when running the Compare and Merge Workbooks tool?

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

To Mark Workbook as Final,click ________ in the Backstage view.

The default setting is all comments in a worksheet are ________ when printing.

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