Solved

Match the Following Terms with the Corresponding Description

Question 24

Matching

Match the following terms with the corresponding description:

Premises:

Responses:

Precedents

Cells that are referenced in a formula

Formula auditing

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

A logical function that checks a cell to determine if that cell contains an error or if a formula will result in an error

Dependents

Contain formulas that refer to other cells

IFERROR

A set of tools that enable you to display or trace relationships for formula cells,show formulas,check for errors,and evaluate formulas

Premises:

Precedents

Formula auditing

Watch Window

Dependents

IFERROR

Responses:

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

A logical function that checks a cell to determine if that cell contains an error or if a formula will result in an error

Contain formulas that refer to other cells

A set of tools that enable you to display or trace relationships for formula cells,show formulas,check for errors,and evaluate formulas

Correct Answer:

Premises:

Responses:

Precedents

Formula auditing

Watch Window

Dependents

IFERROR