Question 1

Which of the following is not an Excel Options category?

Accepted Answer

A) General 
B) Formulas 
C) Proofing 
D) Format 
A) General 
B) Formulas 
C) Proofing 
D) Format

Question 2

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 3

Match between columns
                        Premises: Trust-Cente
Advanced
Quick Access Toolbar
Save
Formulas

Accepted Answer

The Answer of Commands and Workbook calculation and AutoRecover rules is...

Question 4

The Accessibility Checker, Compatibility Checker and the Document Inspector are available in the ________

Accepted Answer

Backstage view, back

Question 5

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 6

Where in the Excel Options dialog box would you manage AutoRecover in Excel?

Accepted Answer

A) General 
B) Formulas 
C) Save 
D) Advanced 
A) General 
B) Formulas 
C) Save 
D) Advanced

Question 7

What would happen if two users made changes at the same time in a shared workbook?

Accepted Answer

A) The Resolve Conflicts dialog box would launch. 
B) It would take the first person who opened the file's version. 
C) It would take the last person who opened the file's version. 
D) An error would appear asking all users to close and re-enter data. 
A) The Resolve Conflicts dialog box would launch. 
B) It would take the first person who opened the file's version. 
C) It would take the last person who opened the file's version. 
D) An error would appear asking all users to close and re-enter data.

Question 8

How would you create a new group on a Ribbon tab?

Accepted Answer

A) Right click on the Ribbon and select new group. 
B) You cannot make new groups. 
C) Click New Group in the Customize Ribbon section in the Excel Options dialog box. 
D) Click on Commands and Groups button in the Customize Ribbon tab in the Excel Options dialog box. 
A) Right click on the Ribbon and select new group. 
B) You cannot make new groups. 
C) Click New Group in the Customize Ribbon section in the Excel Options dialog box. 
D) Click on Commands and Groups button in the Customize Ribbon tab in the Excel Options dialog box.

Question 9

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 10

Some of the properties you set in the Properties dialog box will make it easier to organize and find files in ________.

Accepted Answer

The answer of Some of the properties you set in...

Question 11

Which tool evaluates the workbook's contents to identify features would be lost if opened in an older version of Excel?

Accepted Answer

A) Compatibility Checker 
B) Accessibility Checker 
C) Backwards Compatibility Checker 
D) Document Inspector 
A) Compatibility Checker 
B) Accessibility Checker 
C) Backwards Compatibility Checker 
D) Document Inspector

Question 12

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 13

Use the ________ command to combine multiple versions of shared workbooks into one workbook so that you can compare the changes to decide which ones to keep.

Accepted Answer

Compare an

Question 14

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 15

Documents can have only one author defined in the document properties.

Accepted Answer

A) True 
 B)False

Question 16

Which of the following is not a Property in Excel?

Accepted Answer

A) Author: 
B) Last Modified By: 
C) Tags: 
D) Contents of cells 
A) Author: 
B) Last Modified By: 
C) Tags: 
D) Contents of cells

Question 17

The default email client associated with Excel is ________.

Accepted Answer

The answer of The default email client associated with Excel...

Question 18

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 19

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

Accepted Answer

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

Question 20

Advanced Properties display above the current workbook.

Accepted Answer

A) True 
 B)False

Which of the following is not an Excel Options category?

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

The Accessibility Checker, Compatibility Checker and the Document Inspector are available in the ________

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

Where in the Excel Options dialog box would you manage AutoRecover in Excel?

What would happen if two users made changes at the same time in a shared workbook?

How would you create a new group on a Ribbon tab?

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

Some of the properties you set in the Properties dialog box will make it easier to organize and find files in ________.

Which tool evaluates the workbook's contents to identify features would be lost if opened in an older version of Excel?

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

Use the ________ command to combine multiple versions of shared workbooks into one workbook so that you can compare the changes to decide which ones to keep.

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

Documents can have only one author defined in the document properties.

Which of the following is not a Property in Excel?

The default email client associated with Excel is ________.

The default setting for printing comments is ________.

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

Advanced Properties display above the current workbook.

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 an Excel Options category?

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

The Accessibility Checker, Compatibility Checker and the Document Inspector are available in the ________

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

Where in the Excel Options dialog box would you manage AutoRecover in Excel?

What would happen if two users made changes at the same time in a shared workbook?

How would you create a new group on a Ribbon tab?

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

Some of the properties you set in the Properties dialog box will make it easier to organize and find files in ________.

Which tool evaluates the workbook's contents to identify features would be lost if opened in an older version of Excel?

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

Use the ________ command to combine multiple versions of shared workbooks into one workbook so that you can compare the changes to decide which ones to keep.

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

Documents can have only one author defined in the document properties.

Which of the following is not a Property in Excel?

The default email client associated with Excel is ________.

The default setting for printing comments is ________.

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

Advanced Properties display above the current workbook.

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