ITE 140 Chapter 7 T/F

Ace your homework & exams now with Quizwiz!

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


Related study sets

Weeks 2-6 Concepts: Poli Sci 1155 - class notes

View Set

Ch. 11 Decision Making and Relevant Information

View Set

MAR3023 Practice Exams Midterm 2

View Set

Ch. 15 Critical Thinking in Nursing Practice

View Set

Microbiology - Ch 14: An Introduction to Host Defenses and Innate Immunities

View Set

Anatomy Lecture 5 - Cartilage and Bone

View Set

SYSTEMIC ONSET JUVENILE IDIOPATHIC ARTHRITIS

View Set

Chapter 18 Classification (Sections 1 & 3)

View Set