Term
A file which contians one or more spreadsheets. 

Definition


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

Definition


Term
Individual locations on a spreadsheet. 

Definition


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

Definition


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

Definition


Term
Instructs the software to perform a calculation. 

Definition


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

Definition


Term
A cell Value that changes as the formula is copied. 

Definition


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

Definition


Term
A combination of an absolute and relative cell. 

Definition


Term
The function that adds the range of cells. 

Definition


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

Definition


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

Definition


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

Definition


Term
Used to arrange data in alphabetical or chronological order. 

Definition


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

Definition


Term
Used to fill a row or column with consecutive data. 

Definition


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

Definition


Term
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. 

Definition


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

Definition


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

Definition


Term
The Date Function that returns the current date. 

Definition


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

Definition


Term
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. 

Definition


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

Definition


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

Definition


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

Definition


Term
An advanced function that is used to return the number of cells that meet a condition set forth in the formula. 

Definition


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

Definition


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

Definition


Term
Used in graphs to indicate data values. 

Definition


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

Definition


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

Definition


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

Definition


Term
Used in a graph to clarify data categories or values. 

Definition


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

Definition


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

Definition


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

Definition


Term
Describes the horizontal data. 

Definition


Term
Describes the vertical data. 

Definition


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

Definition


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

Definition


Term
Used to make comparisons or generalizations about groups of data. 

Definition


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

Definition


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

Definition


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

Definition


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

Definition


Term
A pie chart in which the individual components are enhanced. 

Definition

