Go! With Microsoft. Office 2007: Chapter 11

Created by Epydemic 

Upgrade to
remove ads

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.

Please allow access to your computer’s microphone to use Voice Recording.

Having trouble? Click here for help.

We can’t access your microphone!

Click the icon above to update your browser permissions above and try again

Example:

Reload the page to try again!

Reload

Press Cmd-0 to reset your zoom

Press Ctrl-0 to reset your zoom

It looks like your browser might be zoomed in or out. Your browser needs to be zoomed to a normal size to record audio.

Please upgrade Flash or install Chrome
to use Voice Recording.

For more help, see our troubleshooting page.

Your microphone is muted

For help fixing this issue, see this FAQ.

Star this term

You can study starred terms together

NEW! Voice Recording

Create Set