Advertisement

15 terms

Flash cards from the Matching Section of Chapter 11.

Function

A predefined formula---a formula that Excel has already built for you---that performs calculations by using specific values in a particular order.

Arguments

The values that an Excel function uses to perform calculations or operations.

AVERAGE

A statistical function that adds a group of values, and then divides the result by the number of values in the group.

MIN

A statistical function that determines the smallest value in a group of values.

Formula AutoComplete

An Excel feature which, after typing an = (equal sign) and the beginning letter or letters of a function name, displays a list of function names that match the typed letter(s), and from which you can insert the function by pointing to its name, and then pressing the Tab key or double-clicking.

Criteria

Conditions that you specify in a logical function.

Logical Test

Any value or expression that can be evaluated as being true or false.

Comparison Operators

The symbols < (less than), > (greater than), and = (equal) that evaluate each field value to determine if it is the same, greater than, less than, or in between a range of values as specified by the criteria.

Data Bar

A cell format consisting of a shaded bar that provides a visual cue to the reader about the value of a cell relative to other cells the length of the bar represents the value in the cell---longer bar represents a higher value and a shorter bar represents a lower value.

NOW

A function within the Date & Time category that retrieves the date and time from your computer's calendar and clock and inserts the information into the selected cell.

Excel Table

A series of rows and columns in a worksheet that contains related data, and that is managed independently from the data in other rows and columns in the worksheet.

Pane

A portion of a worksheet window bounded by and separated from other portions by vertical and horizontal bars.

Interest

The amount charged for the use of borrowed money.

Present Value

The total amount that a series of future payments is worth now also knowu as the principal.

PMT

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