ITE 140 Chapter 7 T/F

If you move cells that have a defined name, the defined name does not go with them to the new location.

False

The HLOOKUP function looks up values in a table array arranged in vertical columns.

False

The VLOOKUP function looks up values in a range of cells arranged as horizontal rows.

False

The VLOOKUP function looks up values in a table array arranged in horizontal rows.

False

The data in a table array, which can be numbers or text, must be sorted in descending order.

False

An advantage to naming a range of cells is that you can use the name in a formula in other parts of your workbook.

True

Auditing is the process of examining a worksheet for errors in formulas.

True

Data validation improves the accuracy of the person entering data into a worksheet.

True

Excel includes a group of Formula Auditing features, which consists of tools and commands that help you to check a worksheet for errors.

True

If you create a defined name and then decide that you no longer need it, you can delete the name and its associated range reference.

True

In a lookup formula, the defined range is referred to as the table array.

True

The Error Checking command checks for common errors that occur in formulas.

True