# Shared Flashcard Set

## Details

BCIS Chapter 6 Vocab
N/A
29
01/24/2012

Term
 Absolute Cell Reference-
Definition
 a cell reference that does not change when copied because a dollar sign has been placed in front of both of the column letter and row number such as \$a\$5
Term
 Alphabetical Order-
Definition
 See ascending order.
Term
 Amortization-
Definition
 A method for computing equal periodic payments for an installment loan
Term
 Amortization Table-
Definition
 Displays the interest and principle amounts for each payment of an installment loan.
Term
 Arguments-
Definition
 The data required by a function.
Term
 Ascending Order-
Definition
 In order from lowest to highest. Also called alphabetical order when data is text and chronological order when the data is times or dates.
Term
 AVERAGE-
Definition
 function that adds the values in a range of cells and then divides the result by the number of cells in the range.
Term
 Chronological-
Definition
 See ascending order.
Term
 Descending-
Definition
 In order from highest to lowest.
Term
 Destination-
Definition
 the upper-Left cell of the range where data is to be pasted when copying or moving data between sheets.
Term
 Function-
Definition
 Performs a calculation that results in a single value.
Term
 IF Function-
Definition
 function that is used to make a decision based on an comparison.
Term
 Installment Loan-
Definition
 Loan that is repaid in a series of periodic payments.
Term
 Key sort Column-
Definition
 the column that contains the values that sort is based on.
Term
Definition
 Data that is connected to the source cell and will automatically update if the source cell is changed.
Term
 MAX-
Definition
 Function that displays the largest value in a range of cells.
Term
 MIN-
Definition
 Function that displays the smallest value in a range or cells.
Term
 PMT-
Definition
 Function that calculates the periodic payment for installment loan.
Term
 Principal-
Definition
 the amount of money owed on a loan.
Term
 Relational operator-
Definition
 Used to compare two values
Term
 ROUND function-
Definition
 Changes a value by rounding it to a specific number of a decimal places.
Term
 Sorting-
Definition
 Arranging data in a specified order.
Term
 Source-
Definition
 The cell or range of data to be copied when copying or moving data between sheets.
Term
Definition
 A worksheet containing data relating to a particular situation.
Term
 SUM-
Definition
 Function that adds the values in a range of cells.
Term
 Static-
Definition
 Copied data that is not connected to the source data.
Term
 Syntax-
Definition
 the excepted form or structure of a function.
Term
 What if analysis-
Definition
 The process of making decisions using a spreadsheet model.
Term
 What if question-
Definition
 A question that is answered using a worksheet model
Supporting users have an ad free experience!