Microsoft Suite Final Review: Vocab

Front

A cell reference that reflects the row or column it has been copied to.

Back

reflective cell reference

Front

A lookup function that returns a value from a list of many values.

Back

Choose

Front

A method for computing equal periodic payments for an installment loan.

Back

amortization

Front

A shared computer drive used by many schools and organizations.

Back

network drive

Front

A worksheet containing data relating to a particular situation.

Back

spreadsheet model

Front

Adds interest when moving from one slide to the next during an on-screen presentation.

Back

slide transition

Front

Allows you to change the properties of a transition or animation.

Back

effect options

Front

Allows you to keep a portion of the worksheet visible while you scroll through a sheet.

Back

freeze panes

Front

Animation that will move an object on a predetermined line, or a custom line that you draw yourself.

Back

motion path

Front

Automatically fills in values as you enter a few examples of how you want the output to be entered.

Back

flash fill