Question 1

Hidden comments do not print.

Accepted Answer

A) True 
 B)False  True

Question 2

Where in the Excel Options dialog box would you add a word or phrase to AutoCorrect in Excel?

Accepted Answer

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

Question 3

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

Accepted Answer

A) True 
 B)False  True

Question 4

The Excel Options dialog box primarily ________.

Accepted Answer

A) manages workbook iterations 
B) manages online connections. 
C) manages what functions are available 
D) manages how Excel behaves and operates 
A) manages workbook iterations 
B) manages online connections. 
C) manages what functions are available 
D) manages how Excel behaves and operates

Question 5

Excel Workbooks with an X at the end of their extension use what base for building their files?

Accepted Answer

A) Binary 
B) ASCII 
C) XML 
D) Unicode 
A) Binary 
B) ASCII 
C) XML 
D) Unicode

Question 6

An internet connection is not necessary to email attachments.

Accepted Answer

A) True 
 B)False

Question 7

If a workbook ________ is lost, it cannot be recovered.

Accepted Answer

The answer of If a workbook ________ is lost, it...

Question 8

A shared workbook is ________.

Accepted Answer

A) passed from person to person via email 
B) limited to four users 
C) designed to be stored on a network and be used by multiple people 
D) available through any shared link 
A) passed from person to person via email 
B) limited to four users 
C) designed to be stored on a network and be used by multiple people 
D) available through any shared link

Question 9

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

Accepted Answer

The Answer of File stored in a network location with is...

Question 10

The Document Inspector can remove personal data from a workbook.

Accepted Answer

A) True 
 B)False

Question 11

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 12

The Excel Options dialog box is on the Developer tab.

Accepted Answer

A) True 
 B)False

Question 13

The Office ________ controls the overall appearance and color of the interface of Office.

Accepted Answer

The answer of The Office ________ controls the overall appearance...

Question 14

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 15

What is the default file format for Excel 2016?

Accepted Answer

A) .xlsm 
B) .xltx 
C) .xls 
D) .xlsx 
A) .xlsm 
B) .xltx 
C) .xls 
D) .xlsx

Question 16

The menu which displays when you click the File tab is the ________.

Accepted Answer

The answer of The menu which displays when you click...

Question 17

Google docs and OpenOffice use ________ file extensions for spreadsheets.

Accepted Answer

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

Question 18

What happens if you forget your password to a password protected workbook?

Accepted Answer

A) Send it to your network administrator. 
B) It's not restorable. 
C) Microsoft can restore it for a fee. 
D) Open the Excel Options dialog box and go to Advanced and then click Password Restore. 
A) Send it to your network administrator. 
B) It's not restorable. 
C) Microsoft can restore it for a fee. 
D) Open the Excel Options dialog box and go to Advanced and then click Password Restore.

Question 19

Match between columns
                        Premises: Properties dialog box
Office Theme
Excel Options
Automatic property
Document properties

Accepted Answer

The Answer of Provides additional document details not provided in is...

Question 20

PDF file format is in XML Paper Specifications.

Accepted Answer

A) True 
 B)False

Hidden comments do not print.

Where in the Excel Options dialog box would you add a word or phrase to AutoCorrect in Excel?

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

The Excel Options dialog box primarily ________.

Excel Workbooks with an X at the end of their extension use what base for building their files?

An internet connection is not necessary to email attachments.

If a workbook ________ is lost, it cannot be recovered.

A shared workbook is ________.

The Document Inspector can remove personal data from a workbook.

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 Excel Options dialog box is on the Developer tab.

The Office ________ controls the overall appearance and color of the interface of Office.

Which of the following is not customizable in Excel?

What is the default file format for Excel 2016?

The menu which displays when you click the File tab is the ________.

Google docs and OpenOffice use ________ file extensions for spreadsheets.

What happens if you forget your password to a password protected workbook?

PDF file format is in XML Paper Specifications.

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

Hidden comments do not print.

Where in the Excel Options dialog box would you add a word or phrase to AutoCorrect in Excel?

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

The Excel Options dialog box primarily ________.

Excel Workbooks with an X at the end of their extension use what base for building their files?

An internet connection is not necessary to email attachments.

If a workbook ________ is lost, it cannot be recovered.

A shared workbook is ________.

The Document Inspector can remove personal data from a workbook.

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 Excel Options dialog box is on the Developer tab.

The Office ________ controls the overall appearance and color of the interface of Office.

Which of the following is not customizable in Excel?

What is the default file format for Excel 2016?

The menu which displays when you click the File tab is the ________.

Google docs and OpenOffice use ________ file extensions for spreadsheets.

What happens if you forget your password to a password protected workbook?

PDF file format is in XML Paper Specifications.

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