Exam 4: Excell: Use Financial and Lookup Functions, Define Names, Validate Data, and Audit Worksheets

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

________ cells are cells that are referred to by a formula in another cell.

A ________ list is a list of values that are acceptable for a group of cells.

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

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.

Defined names can contain ________.

A(n)________ is the result of a formula that Excel cannot evaluate correctly.

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

Cells containing formulas that refer to other cells are called ________ cells.

Match the following four terms to their meanings: i.Financial functions II.interest III.rate IV.Present value (Pv)

________ are tools and commands accessible from the Formulas tab that help you check your worksheet for errors.

Present value (Pv)represents the amount of the loan before any payments are made.

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

Match the following five terms with their meanings: i.Tracer arrow II.Auditing III.Precedent cells IV.formulas v.Error value

The first step in using a lookup function is to define the range of cells that will serve as the table array.

A word or string of characters in Excel that represents a cell,a range of cells,a formula,or a constant value is called a ________.

The total amount that a series of future payment is worth is called the ________.

Each of the following is a rule for defining names except: ________.

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

An Excel function that looks up values in a table array arranged as vertical columns is the ________ function.