Question 1

By default, automatic updates are ________ to protect the destination file from virus infection

Accepted Answer

The answer of By default, automatic updates are ________ to...

Question 2

A(n)________ is where you go when you click a hyperlink.

Accepted Answer

The answer of A(n)________ is where you go when you...

Question 3

Which character or characters separate the cell reference from the sheet name in an external reference?

Accepted Answer

A) ! 
B) [] 
C) '' 
D) :/ 
A) ! 
B) [] 
C) '' 
D) :/

Question 4

Match between columns
                        Premises: Side by Side
Synchronous Scrolling
Tiled
Split Window
Hide

Accepted Answer

The Answer of Two worksheets beside each other and they is...

Question 5

What is the feature that warns users from entering invalid data?

Accepted Answer

A) Watch Window 
B) Formula Auditing 
C) Data Validation 
D) Tracing Precedents 
A) Watch Window 
B) Formula Auditing 
C) Data Validation 
D) Tracing Precedents

Question 6

Which character or characters notes the file path in an external reference?

Accepted Answer

A) [] 
B) '' 
C) ! 
D) :/ 
A) [] 
B) '' 
C) ! 
D) :/

Question 7

What happens to an open destination file if the source file is edited while both are open?

Accepted Answer

A) The source file receives an error. 
B) The destination asks if you would like to accept updates to the source file. 
C) The destination file updates 
D) Antivirus software blocks the changes. 
A) The source file receives an error. 
B) The destination asks if you would like to accept updates to the source file. 
C) The destination file updates 
D) Antivirus software blocks the changes.

Question 8

________ are the rules that dictate the type of data that can be entered in a cell.

Accepted Answer

A) Input message 
B) Validation criteria 
C) Error alert 
D) Defined item 
A) Input message 
B) Validation criteria 
C) Error alert 
D) Defined item

Question 9

What tool would you use to find out which cells use the value of the active cell by displaying tracer arrows?

Accepted Answer

A) Trace Precedents 
B) Trace Dependents 
C) Show Formulas 
D) Evaluate Formula 
A) Trace Precedents 
B) Trace Dependents 
C) Show Formulas 
D) Evaluate Formula

Question 10

Objects such as charts cannot contain hyperlinks.

Accepted Answer

A) True 
 B)False

Question 11

A Watch Window is a dialog box which displays all of the intermediary steps of a function.

Accepted Answer

A) True 
 B)False

Question 12

If you move or delete an endpoint worksheet in a 3-D reference ________.

Accepted Answer

A) you must update the reference 
B) Excel opens a dialog box to correct the changed reference 
C) nothing changes 
D) Excel adjusts the 3-D references to reflect the change 
A) you must update the reference 
B) Excel opens a dialog box to correct the changed reference 
C) nothing changes 
D) Excel adjusts the 3-D references to reflect the change

Question 13

Which is true about hiding a worksheet?

Accepted Answer

A) It is unrecoverable. 
B) It removes it from view, making the visible number of tabs more manageable. 
C) It disables formulas referencing that worksheet. 
D) Hide worksheets in Options on the Home Tab. 
A) It is unrecoverable. 
B) It removes it from view, making the visible number of tabs more manageable. 
C) It disables formulas referencing that worksheet. 
D) Hide worksheets in Options on the Home Tab.

Question 14

Which of the following actions will open another window of the current workbook?

Accepted Answer

A) Click the Formulas tab, and then click New Window in the Manage group. 
B) Click the View tab, and then click New Window in the Manage group. 
C) Click the View tab, and then click New Window in the Window group. 
D) Click the Data tab, and then click New Window in the Manage group. 
A) Click the Formulas tab, and then click New Window in the Manage group. 
B) Click the View tab, and then click New Window in the Manage group. 
C) Click the View tab, and then click New Window in the Window group. 
D) Click the Data tab, and then click New Window in the Manage group.

Question 15

A hyperlink in an Excel worksheet can do all of the following, except ________.

Accepted Answer

A) open a different workbook. 
B) switch to another worksheet. 
C) open a webpage. 
D) launch Word. 
A) open a different workbook. 
B) switch to another worksheet. 
C) open a webpage. 
D) launch Word.

Question 16

When using the tracer arrows, cell with errors have ________ arrows.

Accepted Answer

The answer of When using the tracer arrows, cell with...

Question 17

View Side by Side locks two worksheets to scroll together.

Accepted Answer

A) True 
 B)False

Question 18

A(n)________ is a reference within a formula or function to a different worksheet.

Accepted Answer

The answer of A(n)________ is a reference within a formula...

Question 19

Which is not a method of removing a split?

Accepted Answer

A) Click Remove Split on the View tab. 
B) Double click on a split bar. 
C) Click and drag the horizontal split bar off the top of the window. 
D) Click and drag the vertical split bar off the left of the window. 
A) Click Remove Split on the View tab. 
B) Double click on a split bar. 
C) Click and drag the horizontal split bar off the top of the window. 
D) Click and drag the vertical split bar off the left of the window.

Question 20

Formula auditing replaces known errors with alternate values.

Accepted Answer

A) True 
 B)False

By default, automatic updates are ________ to protect the destination file from virus infection

A(n)________ is where you go when you click a hyperlink.

Which character or characters separate the cell reference from the sheet name in an external reference?

What is the feature that warns users from entering invalid data?

Which character or characters notes the file path in an external reference?

What happens to an open destination file if the source file is edited while both are open?

________ are the rules that dictate the type of data that can be entered in a cell.

What tool would you use to find out which cells use the value of the active cell by displaying tracer arrows?

Objects such as charts cannot contain hyperlinks.

A Watch Window is a dialog box which displays all of the intermediary steps of a function.

If you move or delete an endpoint worksheet in a 3-D reference ________.

Which is true about hiding a worksheet?

Which of the following actions will open another window of the current workbook?

A hyperlink in an Excel worksheet can do all of the following, except ________.

When using the tracer arrows, cell with errors have ________ arrows.

View Side by Side locks two worksheets to scroll together.

A(n)________ is a reference within a formula or function to a different worksheet.

Which is not a method of removing a split?

Formula auditing replaces known errors with alternate values.

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

By default, automatic updates are ________ to protect the destination file from virus infection

A(n)________ is where you go when you click a hyperlink.

Which character or characters separate the cell reference from the sheet name in an external reference?

What is the feature that warns users from entering invalid data?

Which character or characters notes the file path in an external reference?

What happens to an open destination file if the source file is edited while both are open?

________ are the rules that dictate the type of data that can be entered in a cell.

What tool would you use to find out which cells use the value of the active cell by displaying tracer arrows?

Objects such as charts cannot contain hyperlinks.

A Watch Window is a dialog box which displays all of the intermediary steps of a function.

If you move or delete an endpoint worksheet in a 3-D reference ________.

Which is true about hiding a worksheet?

Which of the following actions will open another window of the current workbook?

A hyperlink in an Excel worksheet can do all of the following, except ________.

When using the tracer arrows, cell with errors have ________ arrows.

View Side by Side locks two worksheets to scroll together.

A(n)________ is a reference within a formula or function to a different worksheet.

Which is not a method of removing a split?

Formula auditing replaces known errors with alternate values.

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