Question 1

Which is not an option for arranging windows with the Arrange All command?

Accepted Answer

A) Tiled 
B) Horizontal 
C) Side by Side 
D) Cascade 
A) Tiled 
B) Horizontal 
C) Side by Side 
D) Cascade

Question 2

A Warning error style prevents the user from entering invalid data.

Accepted Answer

A) True 
 B)False

Question 3

By default, ________ text appears underlined in blue in an Excel Worksheet

Accepted Answer

The answer of By default, ________ text appears underlined in...

Question 4

The ________ function checks a cell to determine if the cell contains an error.

Accepted Answer

The answer of The ________ function checks a cell to...

Question 5

An icon of stacked sheets displays on the tabs of grouped worksheets

Accepted Answer

A) True 
 B)False

Question 6

Match between columns
                        Premises: Formula auditing
Logic error
Circular reference
Syntax error
Run-time error

Accepted Answer

The Answer of Occurs when a formula or function violates is...

Question 7

If you cannot immediately see the source of an error in a nested formula, this tool will walk you through the intermediary calculations.

Accepted Answer

A) Evaluate Formula 
B) Trace Dependents 
C) Trace Precedents 
D) IFERROR 
A) Evaluate Formula 
B) Trace Dependents 
C) Trace Precedents 
D) IFERROR

Question 8

Match between columns
                        Premises: Objects
Underlined blue text
Hyperlink
ScreenTip
Underlined purple text

Accepted Answer

The Answer of Text balloon which displays when you hover is...

Question 9

All of the following could produce a #NAME? error except ________.

Accepted Answer

A) Misspelled word 
B) Invalid Range Name 
C) Invalid arguments in a function 
D) Invalid Function Name 
A) Misspelled word 
B) Invalid Range Name 
C) Invalid arguments in a function 
D) Invalid Function Name

Question 10

What do blue arrows mean when tracing precedents?

Accepted Answer

A) Cells with errors 
B) Cells with validation rules 
C) Cells with no errors 
D) Cells with Watch Windows 
A) Cells with errors 
B) Cells with validation rules 
C) Cells with no errors 
D) Cells with Watch Windows

Question 11

Which error message would be the result if you accidentally type =VLOKUP instead of =VLOOKUP to build a lookup function?

Accepted Answer

A) #NAME? 
B) #NULL! 
C) #NUM 
D) #REF 
A) #NAME? 
B) #NULL! 
C) #NUM 
D) #REF

Question 12

Which is true about the following external cell reference? 'G:\Branches[Minneapolis.xlsx]Qtr 1'!A1

Accepted Answer

A) It is in the same folder as the destination file. 
B) It is in the same workbook as the destination file 
C) It is in a different folder than the destination file. 
D) It will not work because of the spaces in the worksheet name. 
A) It is in the same folder as the destination file. 
B) It is in the same workbook as the destination file 
C) It is in a different folder than the destination file. 
D) It will not work because of the spaces in the worksheet name.

Question 13

Hyperlinks must link to websites.

Accepted Answer

A) True 
 B)False

Question 14

________ cells are referenced by a formula in another cell.

Accepted Answer

The answer of ________ cells are referenced by a formula...

Question 15

A(n)________ is best suited to monitor the changes in a cell as input values change.

Accepted Answer

The answer of A(n)________ is best suited to monitor the...

Question 16

A(n)________ error alert accepts invalid data but provides information to the user.

Accepted Answer

The answer of A(n)________ error alert accepts invalid data but...

Question 17

Which of the following is not an Error Style for data validation?

Accepted Answer

A) Stop 
B) Critical 
C) Warning 
D) Information 
A) Stop 
B) Critical 
C) Warning 
D) Information

Question 18

Match between columns
                        Premises: #NUM
#VALUE
#NAME?
#REF
#DIV/0

Accepted Answer

The Answer of Invalid numerical value in a function or is...

Question 19

Match between columns
                        Premises: '
Camel Case Notation
Pascal Case Notation
3-D reference
!

Accepted Answer

The Answer of Referencing worksheet names As part of a is...

Question 20

In a 3-D Reference, the ________ name is enclosed in single quotes and followed by an exclamation point.

Accepted Answer

The answer of In a 3-D Reference, the ________ name...

Which is not an option for arranging windows with the Arrange All command?

A Warning error style prevents the user from entering invalid data.

By default, ________ text appears underlined in blue in an Excel Worksheet

The ________ function checks a cell to determine if the cell contains an error.

An icon of stacked sheets displays on the tabs of grouped worksheets

If you cannot immediately see the source of an error in a nested formula, this tool will walk you through the intermediary calculations.

All of the following could produce a #NAME? error except ________.

What do blue arrows mean when tracing precedents?

Which error message would be the result if you accidentally type =VLOKUP instead of =VLOOKUP to build a lookup function?

Which is true about the following external cell reference? 'G:\Branches[Minneapolis.xlsx]Qtr 1'!A1

Hyperlinks must link to websites.

________ cells are referenced by a formula in another cell.

A(n)________ is best suited to monitor the changes in a cell as input values change.

A(n)________ error alert accepts invalid data but provides information to the user.

Which of the following is not an Error Style for data validation?

In a 3-D Reference, the ________ name is enclosed in single quotes and followed by an exclamation point.

Introduction to Excel

Formulas and Functions

Charts

Datasets and Tables

Subtotals, Pivottables, and Pivotcharts

What-If Analysis

Specialized Functions

Statistical Functions

Imports, Xml, and Power Add-Ins

Collaboration and Workbook Distribution

Templates, Styles, and Macros

Appendix: Exploring Microsoft Office Excel 2016 Comprehensive Poatsygrauer

Filters

Exam 9: Multiple-Sheet Workbook Management

Which is not an option for arranging windows with the Arrange All command?

A Warning error style prevents the user from entering invalid data.

By default, ________ text appears underlined in blue in an Excel Worksheet

The ________ function checks a cell to determine if the cell contains an error.

An icon of stacked sheets displays on the tabs of grouped worksheets

If you cannot immediately see the source of an error in a nested formula, this tool will walk you through the intermediary calculations.

All of the following could produce a #NAME? error except ________.

What do blue arrows mean when tracing precedents?

Which error message would be the result if you accidentally type =VLOKUP instead of =VLOOKUP to build a lookup function?

Which is true about the following external cell reference? 'G:\Branches[Minneapolis.xlsx]Qtr 1'!A1

Hyperlinks must link to websites.

________ cells are referenced by a formula in another cell.

A(n)________ is best suited to monitor the changes in a cell as input values change.

A(n)________ error alert accepts invalid data but provides information to the user.

Which of the following is not an Error Style for data validation?

In a 3-D Reference, the ________ name is enclosed in single quotes and followed by an exclamation point.

Introduction to Excel

Formulas and Functions

Charts

Datasets and Tables

Subtotals, Pivottables, and Pivotcharts

What-If Analysis

Specialized Functions

Statistical Functions

Imports, Xml, and Power Add-Ins

Collaboration and Workbook Distribution

Templates, Styles, and Macros

Appendix: Exploring Microsoft Office Excel 2016 Comprehensive Poatsygrauer

Filters