Matching
Match the following terms with the corresponding description:
Premises:
Watch Window
IFERROR
Formula auditing
Precedents
Dependents
Responses:
Cells that are referenced in a formula
Contain formulas that refer to other cells
A logical function that checks a cell to determine if that cell contains an error or if a formula will result in an error
A set of tools that enable you to display or trace relationships for formula cells, show formulas, check for errors, and evaluate formulas
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
Correct Answer:
Premises:
Responses:
Watch Window
IFERROR
Formula auditing
Precedents
Dependents
Premises:
Watch Window
IFERROR
Formula auditing
Precedents
Dependents
Responses:
Related Questions
Q9: Goal Seek is limited to manipulating only
Q10: Match the following terms with the
Q11: Match the following terms with the corresponding
Q12: Match the following terms with the corresponding
Q13: To compare monthly mortgage payments,total amounts to
Q15: Match the following terms with their meanings:
Q16: Data tables can be constructed using one,two,or
Q17: To optimize the monthly payments,you would designate
Q18: Match the following terms with the corresponding
Q19: The _ value replaces the original input