Excel Chapter 4

Ace your homework & exams now with Quizwiz!

In the Cell Styles gallery, the Currency [0] style and the Comma [0] style format the selected cell with how many decimal places

0

The process of examining a worksheet for errors in formulas.

Auditing

A range of cells that shows how changing certain values in your formulas affects the results of those formulas

Data table

A range of cells that shows how changing certain values in your formulas affects the results of those formulas, and that makes it easy to calculate multiple versions in one operation.

Data table

A technique to improve accuracy when completing a worksheet that controls the type of data or the values that are entered into a cell.

Data validation

Cells that contain formulas that refer to other cells are

Dependent cells

Predefined formulas that perform common business calculations, and that typically involve a period of time such as months or years.

Financial functions

The value at the end of the time periods in an Excel function; the cash balance you want to attain after the last payment is made—usually zero for loans.

Future value (Fv)

A method to find a specific value for a cell by adjusting the value of one other cell. With this, you can work backward from the desired outcome to find the number necessary to achieve your goal

Goal Seek

One of Excel's What-If Analysis tools that provides a method to find a specific value for a cell by adjusting the value of one other cell—you can find the right input when you know the result you want.

Goal Seek

The amount charged for the use of borrowed money.

Interest

The abbreviation for number of time periods in various Excel functions.

Nper

An Excel function that calculates the payment for a loan based on constant payments and at a constant interest rate.

PMT function

Cells that are referred to by a formula in another cell are

Precedent cells

The total amount that a series of future payments is worth now.

Present value (Pv)

Another term for present value.

Principal

In the Excel PMT function, the term used to indicate the interest rate for a loan.

Rate

The location within which a name is recognized without qualification

Scope

The command that displays arrows to indicate what cells affect the value of the cell that is selected is

Trace Precedents

An indicator that shows the relationship between the active cell and its related cell.

Tracer arrow

An Excel function that looks up values that are displayed vertically in a column is the

VLOOKUP

A window that displays the results of specified cells.

Watch Window

The process of changing the values in cells to see how those changes affect the outcome of formulas in the worksheet.

What-if analysis

Tracer arrows are red if a cell contains

an Error Value

When you use a defined name in a formula, the result is the same as if you typed a

cell reference

A word or string of characters that represents a cell, a range of cells, a formula, or a constant value is a

defined name

A group of Excel functions that look up a value in a defined range of cells located in another part of the workbook to find a corresponding value is referred to as

lookup functions

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

validation list

Loans are typically made for a period of

years

The future value at the end of a loan is typically

zero


Related study sets

Maternal Exam 4 example Questions

View Set

consumer, producer, Carnivore, Herbivore, Omnivore, Decomposer, Producer, Sun, Predator, prey, photosynthesis

View Set

Earth Science - Oceans & Coast - quizzes 21 & 22

View Set

Unit 2: Reasoning and Proof Test Review

View Set