15 terms

# Go! With Microsoft. Office 2007: Chapter 11

Flash cards from the Matching Section of Chapter 11.
###### PLAY
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.