# Go! With Microsoft. Office 2007: Chapter 11

### 15 terms by Epydemic Teacher

#### Study  only

Flashcards Flashcards

Scatter Scatter

Scatter Scatter

## Create a new folder

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.

Example: