Question 1

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 2

E:
\Regions[Duluth.xlsx]1stQTR'!A1 is a reference link to a source file in different directory than the destination file.

Accepted Answer

A) True 
 B)False

Question 3

To set up a Watch Window,Click Watch Window on the Data tab.

Accepted Answer

A) True 
 B)False

Question 4

A run-time error occurs because a formula or function does not follow the rules of construction.

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

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

Question 6

You can drag a split bar off the window to remove it.

Accepted Answer

A) True 
 B)False

Question 7

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 8

A(n)________ window has two or four panes displaying the same worksheet.

Accepted Answer

The answer of A(n)________ window has two or four panes...

Question 9

________ cells are referenced by a formula in another cell.

Accepted Answer

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

Question 10

A Split Window has three panes by default

Accepted Answer

A) True 
 B)False

Question 11

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

Accepted Answer

The Answer of Occurs when you use the wrong cell is...

Question 12

Validation ________ are the rules that dictate the type of data that can be entered.

Accepted Answer

The answer of Validation ________ are the rules that dictate...

Question 13

Excel determines the messages returned when a data validation error occurs.

Accepted Answer

A) True 
 B)False

Question 14

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 15

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 16

=SUM('1st Quarter:
4th Quarter'!B4:
B12)is a function using a 3-D reference.

Accepted Answer

A) True 
 B)False

Question 17

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 18

In the Edit Links dialog box,If a workbook referenced by a hyperlink is lost or moved,________ will display.

Accepted Answer

A) Error: Link Broken 
B) #ERROR 
C) Error: Manually find link? 
D) Error: Source not found 
A) Error: Link Broken 
B) #ERROR 
C) Error: Manually find link? 
D) Error: Source not found

Question 19

Sheet 1 and Sheet 2 are grouped.If you enter a formula in B3 of Sheet 1,what happens in Sheet 2?

Accepted Answer

A) No change happens. 
B) Sheet 2 B3 has the same formula. 
C) A warning appears,warning you not to make changes in grouped sheets. 
D) Formatting will change on Sheet 2,but not formulas. 
A) No change happens. 
B) Sheet 2 B3 has the same formula. 
C) A warning appears,warning you not to make changes in grouped sheets. 
D) Formatting will change on Sheet 2,but not formulas.

Question 20

A Watch Window displays the value,formula,and location of cells in a separate window.

Accepted Answer

A) True 
 B)False

Which is true about hiding a worksheet?

E: \Regions[Duluth.xlsx]1stQTR'!A1 is a reference link to a source file in different directory than the destination file.

To set up a Watch Window,Click Watch Window on the Data tab.

A run-time error occurs because a formula or function does not follow the rules of construction.

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

You can drag a split bar off the window to remove it.

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

A(n)________ window has two or four panes displaying the same worksheet.

________ cells are referenced by a formula in another cell.

A Split Window has three panes by default

Validation ________ are the rules that dictate the type of data that can be entered.

Excel determines the messages returned when a data validation error occurs.

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

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

=SUM('1st Quarter: 4th Quarter'!B4: B12)is a function using a 3-D reference.

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

In the Edit Links dialog box,If a workbook referenced by a hyperlink is lost or moved,________ will display.

Sheet 1 and Sheet 2 are grouped.If you enter a formula in B3 of Sheet 1,what happens in Sheet 2?

A Watch Window displays the value,formula,and location of cells in a separate window.

Introduction to Excel

Formulas and Functions

Charts

Datasets and Tables

Subtotals, Pivot-tables, and Pivot-charts

What-If Analysis

Specialized Functions

Statistical Functions

Imports, xml, and Power Add-Ins

Collaboration and Workbook Distribution

Templates, styles, and Macros

Office 2016 Common Features

Filters

Exam 9: Multiple-Sheet Workbook Management

Which is true about hiding a worksheet?

E: \Regions[Duluth.xlsx]1stQTR'!A1 is a reference link to a source file in different directory than the destination file.

To set up a Watch Window,Click Watch Window on the Data tab.

A run-time error occurs because a formula or function does not follow the rules of construction.

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

You can drag a split bar off the window to remove it.

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

A(n)________ window has two or four panes displaying the same worksheet.

________ cells are referenced by a formula in another cell.

A Split Window has three panes by default

Validation ________ are the rules that dictate the type of data that can be entered.

Excel determines the messages returned when a data validation error occurs.

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

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

=SUM('1st Quarter: 4th Quarter'!B4: B12)is a function using a 3-D reference.

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

In the Edit Links dialog box,If a workbook referenced by a hyperlink is lost or moved,________ will display.

Sheet 1 and Sheet 2 are grouped.If you enter a formula in B3 of Sheet 1,what happens in Sheet 2?

A Watch Window displays the value,formula,and location of cells in a separate window.

Introduction to Excel

Formulas and Functions

Charts

Datasets and Tables

Subtotals, Pivot-tables, and Pivot-charts

What-If Analysis

Specialized Functions

Statistical Functions

Imports, xml, and Power Add-Ins

Collaboration and Workbook Distribution

Templates, styles, and Macros

Office 2016 Common Features

Filters