| A | B |
|---|
| Workbook | a file which contains one or more spreadsheets |
| Spreadsheet | (also known as worksheet) is an arrangement of cells in columns and rows used to organize, analyze, calculate, and report information, usually in numerical form |
| Cells | individual locations on a spreadsheet |
| Cell Address | Refers to one specific cell location |
| Cell Range | Refers to a group of adjacent cells |
| Column | Refers to all the contents in a vertical range of cells in a spreadsheet |
| Rows | Refers to all of the contents in a horizontal range of a cells |
| Label | classified used for cells that contain text or for numbers that will not be used in calculations |
| Value | classification indicates that the potential to be used in calculations |
| Formula | instructs the software to perform a calculation |
| Basic Function | a short cut for a formula |
| Cell Reference | indicates a cell's location and provides instructions for how cell data is copied or used in calculations |
| Relative | cell value changes the formula is copied |
| Absolute | cell value remains static when copied to other locations |
| Mixed | combination of an absolute and a relative cell |
| Sum | adds the range of cells |
| Average | determines the average of a range of cells |
| Maximum | finds the highest number in the range of cells |
| Minimum | finds the lowest number in the range of cells |
| Sort | is used to arrange data in alphabetical or chronological order |
| Primary Sort | indicates the primary sort range of data |
| Secondary Sort | indicates the next range |
| Freeze Panes | allows the user to work in multiple areas of a large spreadsheet and focus the view on specific cell ranges |
| Print Preview | used to view how data is represented on paper |
| 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. |
| Y-Axis | the left vertical side of the graph |
| X-Axis | is the bottom horizontal side of the graph |
| Legend | an object that explains the symbols, colors, or patterns used to differentiate the data |
| Chart Title | the main heading, which describes the purpose and content |
| Embedded Chart | a chart that appears on the same sheet as the spreadsheet it represents |
| Linked Chart | a chart that will reflect changes made to the spreadsheet it represents |
| Column Chart | used to make comparisons and generalizations about groups of data, such as to compare the number of students from each class (sophomores, juniors, and seniors) to their attendance at assemblies |
| Stacked Bar Chart | used to represent the sum of more than one value and compare the contribution of individuals to the whole, such as the total sales for three components to the whole sales for a store |
| Line Chart | used to show trends or changes in data over time, such as growth in sales over several quarters |
| XY Scatter Chart | used to show the correlation of two or more data sets, such as correlation between stress rates and wait time in a doctor's office |
| Pie Chart | used to represent the contribution of each component of one series of data to the whole, such as the percentage of expenditures to the total budget |
| Exploded Pie Chart | a pie chart in which the individual components are enhanced |
