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

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

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

________ are equations that perform calculations on values in your worksheet.

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

To see how different interest rates affect a monthly payment,use a ________.

With Goal Seek,you can work backward from the desired outcome to find the number necessary to achieve your goal.

Match the following five terms to their meanings: i.Lookup function II.table array III.VLOOKUP function IV.HLOOKUP function v.name

A defined name provides a logical reference to ________.

A command that displays arrows to indicate what cells affect the value of the cell that is selected is the ________.

Goal Seek is useful to determine how much you can borrow to stay within a budget.

When you borrow money,the amount charged to you for your use of the borrowed money is called ________.

You can monitor the values of cells in one part of a workbook while working on another part of the workbook by using the ________,a window that displays the results of specified cells.

A(n)________ data table changes the values in two cells.

Goal Seek is a method to find a specific value for a cell by adjusting the value of another cell.

In the Data Validation dialog box,you can create a ________ that will display when the cell is selected and that provides instructions to the person entering data.

Equations that perform calculations on values in a worksheet are referred to as ________.

A ________ triangle in the upper left corner of a cell indicates that the formula in the cell is suspect for some reason and could be a potential error.

________ arrows show the relationship between the active cell and its related cells.

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

Goal Seek is part of a suite of data tools used for ________.