An arrangement of cells in columns and rows ued to organize, analyze, calculate, and report information, usually in numerical form.

Classification used for cells that contain text or numbers that will not be used in calculations.

A classification that indicates the data has the potential to be used in calculations.

Indicates a cell's location and provides instruction for how cell data is copied or used in calculations.

A cell value that remains static when copied to other locations.

The function that determines the average of the range of cells.

The function that finds the highest number in the range of cells.

The function that finds the lowest number in the range of cells.

Used to arrange data in alphabetical or chronological order.

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

A word processing document may contain a link to a spreadsheet that will update anytime the spreadsheet data is edited.

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.

An advanced function in which results are returned IF the data specified in an equation meets conditions set by the formula.

An advanced funtion that is used to calculate a period of time.

The Date Function that calculates the difference in days between two dates.

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.

A function in which their is more than two columns in a array (lookup table).

An advanced function that is used to return the number of cells in a range that contain numbers.

An advanced function that is used to return the number of cells in a range that contain a value or letter.

The left vertical side of the graph.  It contains the numerical data.

The bottom horizontal side of the graph.  Contains the category information.

Used in graphs to indicate data values.

A collection of related values, such as one row or column from a spreadsheet.

A horizontal or vertical line that extends across the plot area of the graph for the purpose of adding clarification of the graph.

The background portion of a graph bound by the y and x axis.

An object that explains the symbols, colors, or patterns, used to differentiate the data.

A single value or text explanation used to explain the data in a series.

In a chart, the main heading, which describes the purpose and the content.

Describes the horizontal data.

Describes the vertical data.

A chart that appears on the same sheet as the spreadsheet it represents.

A chart that will reflect changes made to the spreadsheet it represents.

Used to make comparisons or generalizations about groups of data.

The chart used to represent the sum of more than one value and compare the contribution of individuals to the whole.

A chart that is used to show trends or changes in data, over time.

The type of chart that is used to show the correlation of two or more data sets.

The type of chart used to represent the contribution of each component of one series of data to the whole.

A pie chart in which the individual components are enhanced.