Solved

Match the Following Terms with the Corresponding Description

Question 98

Matching

Match the following terms with the corresponding description:

Premises:

Responses:

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

3-D Formula

Precedent

Cells that are referenced in a formula

[Indianapolis.xlsx]Qtr3!A1

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

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

External reference

Watch Window

IFERROR function

Premises:

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

Precedent

[Indianapolis.xlsx]Qtr3!A1

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

Watch Window

Responses:

3-D Formula

Cells that are referenced in a formula

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

External reference

IFERROR function

Correct Answer:

Premises:

Responses:

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

Precedent

[Indianapolis.xlsx]Qtr3!A1

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

Watch Window

Related Questions

Q94: Match the following terms with the corresponding