Solved

Match the Following Terms with the Corresponding Description

Question 25

Matching

Match the following terms with the corresponding description:

Premises:

Responses:

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

IFERROR function

[Indianapolis.xlsx]Qtr3!A1

Cells that are referenced in a formula

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

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

External reference

Precedent

3-D Formula

Premises:

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

[Indianapolis.xlsx]Qtr3!A1

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

Watch Window

Precedent

Responses:

IFERROR function

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

3-D Formula

Correct Answer:

Premises:

Responses:

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

[Indianapolis.xlsx]Qtr3!A1

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

Watch Window

Precedent

Related Questions

Q20: Match the following terms with the