Matching
Match the following terms with the corresponding description:
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
Premises:
=IFERROR(D2/E2,"Error in data")
=SUM(''Qtr1:Qtr4''!E3)
Watch Window
[Indianapolis.xlsx]Qtr3!A1
Precedent
Responses:
Related Questions
Q93: _ is the process of selecting two
Q94: Which of the following functions cannot be
Q95: _ errors occur because a formula or
Q96: Which of the following actions will open
Q97: What happens if a user violates a
Q99: The error _ will display when an
Q100: NovemberFile.xlsx is an example of _.
Q101: _ is the process of dividing a
Q102: Which of the following cannot be accessed
Q103: What is the difference between a precedent