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