Advertisement Upgrade to remove ads


used to arrange data in alphabetical or chronological order.

primary sort

indicates the first sort range of data.

secondary sort

indicates the additional range of a sort.

Freeze panes

allows the user to work in multiple areas of a large spreadsheet and focus the view on specific cell ranges

Fill Series

is used to fill a column or row with consecutive data


used to provide a hard copy

Print preview

used to view how data is represented on paper

Print a selection

used to print a portion of a spreadsheet

Linking and embedding

is used to integrate spreadsheet data with other software applications


the program in which the object is stored.


the program in which the object is created.


when an object maintains its connection to the source and updates when changes are made.


a spreadsheet is converted into a graphic image when placed in a target document and does not change to reflect edits made at the source

Advanced Functions

used in higher-level operations, such as in conditional and comparison equations to compute interest rates, due dates and payment terms, and financial projections.

IF statements

conditional operators

Date functions

used to calculate a period of time


returns the current date


calculates difference in days between two dates

LookUp function

used to compare a cell value to an array of cells and return a value that matches the location of the value in the array.


used for two column vectors


used when there are more than two columns in the array (lookup table).


used to assist in organizing spreadsheet information


limits data entry to specific choices programmed into the function


allows additional entries other than those provided in the drop-down menu


used to return the number of cells in a range


number of cells in a range that contain numbers


number cells in a range that contain value or letter


cells that meet a condition set forth in the formula

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


Reload the page to try again!


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