Question 1

Match between columns
                        Premises: Validation criteria
Data validation
Input message
Error alert
Error style

Accepted Answer

The Answer of Descriptive text or instructions for data entry is...

Question 2

A ________ is a file that that contains original data that you need elsewhere.

Accepted Answer

The answer of A ________ is a file that that...

Question 3

Match between columns
                        Premises: Dependents
IFERROR
Precedents
Formula auditing
Watch Window

Accepted Answer

The Answer of Enables you to create a small window is...

Question 4

Match between columns
                        Premises: #NUM
#NAME?
#NULL!
#N/A
#DIV/0!

Accepted Answer

The Answer of Incorrect range separator Formula requires cell ranges is...

Question 5

Match between columns
                        Premises: B3
'[Bloomington.xlsx]Qtr 3 Sales'!A1
'c :\Data[Indianapolis.xlsx]Sheet1'!A1
[Indianapolis.xlsx]Qtr3!A1
'[South Bend.xlsx]Qtr3'!A1

Accepted Answer

The Answer of External reference in which Workbook and worksheet is...

Question 6

________ is/are a set of tools that enable you to display or trace relationships for formula cells,show formulas,check for errors,and evaluate formulas.

Accepted Answer

The answer of ________ is/are a set of tools that...

Question 7

Match between columns
                        Premises: =IFERROR(D2/E2,"Error in data")
=SUM(''Qtr1:Qtr4''!E3)
Watch Window
[Indianapolis.xlsx]Qtr3!A1
Precedent

Accepted Answer

The Answer of IFERROR function and Enables you to create is...

Question 8

Match between columns
                        Premises: Warning style
Stop style
Information style
Data Validation
Circle text

Accepted Answer

The Answer of Circles invalid text as defined by data is...

Question 9

Match between columns
                        Premises: IFERROR
#N/A
#VALUE!
#REF!
#NUM!

Accepted Answer

The Answer of A logical function that checks a cell is...

Question 10

________ is a file containing a pointer to receive data from the source files.

Accepted Answer

The answer of ________ is a file containing a pointer...

Question 11

In the formula =C3*C5 in which the results are displayed in cell C6,________ is the dependent cell.

Accepted Answer

The answer of In the formula =C3*C5 in which the...

Question 12

________ is a logical function that checks a cell to determine if that cell contains an error or if a
formula will result in an error.

Accepted Answer

The answer of ________ is a logical function that checks...

Question 13

Match between columns
                        Premises: External reference
3-d reference
Split bar
Ungrouping
Grouping

Accepted Answer

The Answer of A link between source and destination files is...

Question 14

Match between columns
                        Premises: Unhide
Grouping
Hide
Ungrouping
Fill across worksheet

Accepted Answer

The Answer of Copy new data or formatting across several is...

Question 15

________ enables you to control the data that can be entered into a cell.

Accepted Answer

The answer of ________ enables you to control the data...

Question 16

When a(n)________ style error alert is used,the user will be able to enter data even if it violates the data validation rule.

Accepted Answer

The answer of When a(n)________ style error alert is used,the...

Question 17

Using a(n)________ is best suited to monitor the changes in a cell as input value update.

Accepted Answer

The answer of Using a(n)________ is best suited to monitor...

Question 18

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

Accepted Answer

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

Question 19

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

Accepted Answer

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

Question 20

Match between columns
                        Premises: Destination file
Logic error
Syntax error
Source file
Hyperlink

Accepted Answer

The Answer of The result of a syntactically correct formula is...

Quiz 34: Multiple Sheet Workbook Management

Match the following terms with the corresponding description:

A ________ is a file that that contains original data that you need elsewhere.

Match the following terms with the corresponding description:

Match the following terms with the corresponding description:

Match the following terms with the corresponding description:

________ is/are a set of tools that enable you to display or trace relationships for formula cells,show formulas,check for errors,and evaluate formulas.

Match the following terms with the corresponding description:

Match the following terms with the corresponding description:

Match the following terms with the corresponding description:

________ is a file containing a pointer to receive data from the source files.

In the formula =C3*C5 in which the results are displayed in cell C6,________ is the dependent cell.

________ is a logical function that checks a cell to determine if that cell contains an error or if a formula will result in an error.

Match the following terms with the corresponding description:

Match the following terms with the corresponding description:

________ enables you to control the data that can be entered into a cell.

When a(n)________ style error alert is used,the user will be able to enter data even if it violates the data validation rule.

Using a(n)________ is best suited to monitor the changes in a cell as input value update.

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

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

Match the following terms with the corresponding description: