Solved

Match the Following Terms with the Corresponding Description

Question 87

Matching

Match the following terms with the corresponding description:

Premises:

Responses:

=IFERROR(D2/E2,"Error in data")

IFERROR function

=SUM(''Qtr1:Qtr4''!E3)

Enables you to create a small window so you can conveniently inspect,audit,or confirm formula calculations involving cells not immediately visible on the screen

Watch Window

Cells that are referenced in a formula

[Indianapolis.xlsx]Qtr3!A1

External reference

Precedent

3-D Formula

Premises:

=IFERROR(D2/E2,"Error in data")

=SUM(''Qtr1:Qtr4''!E3)

Watch Window

[Indianapolis.xlsx]Qtr3!A1

Precedent

Responses:

IFERROR function

Enables you to create a small window so you can conveniently inspect,audit,or confirm formula calculations involving cells not immediately visible on the screen

Cells that are referenced in a formula

External reference

3-D Formula

Correct Answer:

Premises:

Responses:

=IFERROR(D2/E2,"Error in data")

=SUM(''Qtr1:Qtr4''!E3)

Watch Window

[Indianapolis.xlsx]Qtr3!A1

Precedent

Related Questions