Matching
Match the following terms with the corresponding description:
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
Premises:
=IFERROR(D2/E2,"Error in data")
Precedent
[Indianapolis.xlsx]Qtr3!A1
=SUM(''Qtr1:Qtr4''!E3)
Watch Window
Responses:
Related Questions
Q11: Visited hyperlinks in Excel appear as:<br>A)blue text.<br>B)black
Q12: When is the input message displayed in
Q17: Match the following terms with the corresponding
Q19: What is the proper format of an
Q25: _ is/are not supported when worksheets are
Q32: To ungroup worksheets:<br>A)click a worksheet tab for
Q42: When a(n)_ style error alert is used,the
Q68: Which of the following is the proper
Q79: A _ is a file that that
Q92: When worksheets are grouped,which of the following