Matching
Match the following terms with the corresponding description:
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
Premises:
=SUM(''Qtr1:Qtr4''!E3)
[Indianapolis.xlsx]Qtr3!A1
=IFERROR(D2/E2, "Error in data")
Watch Window
Precedent
Responses:
Related Questions
Q17: To optimize the monthly payments,you would designate
Q18: Match the following terms with the corresponding
Q19: The _ value replaces the original input
Q20: Best-Case,Worst-Case,and Mostly Likely are descriptive names used
Q21: When entering text to be displayed in
Q23: To compare monthly mortgage payments based on
Q24: You can have multiple scenarios in a
Q25: Match the following terms with their meanings:
Q26: Match the following terms with the corresponding
Q27: In the Goal Seek dialog box,the cell