| A | B |
|---|
| Formulas | The equations used to calculate values in a cell |
| Operand | A number of cell reference used in formulas. |
| Operator | Tells Excel what to do with the operands. For example +, -, *, /, and ^. |
| Order of Evaluation | The sequence used to calculate the value of a formula. |
| Relative Cell Reference | Adjusts to its new location when copied or moved. |
| Absolute Cell References | DO NOT change when moved or copied to a new cell. |
| Mixed Cell References | Cell references containing both relative and absolute references. |
| Function Formulas | Special formulas that do not use operators to calculate a result. |
| Argument | A value, cell reference, range, or text that acts as an operand in a function formula. |
| Statistical Functions | Used to describe large quantities of data. |
| Financial Functions | Used to analyze loans and investments. |
| Cell comment | A message that explains or identifies information contained in the cell. |
| Conditional formatting | Applies a font, border, or pattern to a cell when certain conditions exist in that cell. |
| Format Painting | Allows you to copy the format of a worksheet cell without copying the contents of the cell. |
| Source file | The original file |
| Column Chart | Uses bars of varying heights to illustrate values in a worksheet and is useful for showing relationships among categories of data. |
| Line Chart | Similar to a column chart except columns are replaced by points connected by a line. |
| Pie Chart | Shows the relationship of a part to a whole. |
| Scatter Charts | Show the relationship between two categories of data. |
| Chart sheet | A seperate sheet in the workbook on which you can create and store a chart. |
| Embedded Chart | Created within a worksheet |
| Formulas | The equations used to calculate values in a cell |
| Operand | A number of cell reference used in formulas. |
| Operator | Tells Excel what to do with the operands. For example +, -, *, /, and ^. |
| Order of Evaluation | The sequence used to calculate the value of a formula. |
| Relative Cell Reference | Adjusts to its new location when copied or moved. |
| Absolute Cell References | DO NOT change when moved or copied to a new cell. |
| Mixed Cell References | Cell references containing both relative and absolute references. |
| Function Formulas | Special formulas that do not use operators to calculate a result. |
| Argument | A value, cell reference, range, or text that acts as an operand in a function formula. |
| Statistical Functions | Used to describe large quantities of data. |
| Financial Functions | Used to analyze loans and investments. |
| Titles | Headings that identify the contents of the chart or the axes in the chart |
| Axes | Lines that establish a relationship between data in a chart |
| Gridlines | Lines through a chart that relate the data in a chart to the axes |
| Legend | List that identifies patterns or symbols used in a chart |
| Data Labels | Text or numbers that identify the values depicted by the chart objects directly on the chart |
| Data Table | Data series values displayed in a grid below the chart |
| Chart Wizard | An on-screen guide that helps you prepare a chart |
| Data Series | A group of related information in a column or row of a worksheet that will be plotted on a chart |
| AVERAGE | Displays the average of the range |
| COUNT | Displays the number of cells with numerical values in the range |
| MAX | Displays the largest number contained in the range |
| MIN | Displays the smallest number contained in the range |
| STDEV | Displays the standard deviation of the numbers contained in the range |
| VAR | Displays the variance for the numbers contained in the range |
| NOW | Displays the current date |
| DATE | Displays the date in a variety of formats |
| Cell comment | A message that explains or identifies information contained in the cell. |
| Conditional formatting | Applies a font, border, or pattern to a cell when certain conditions exist in that cell. |
| Format Painting | Allows you to copy the format of a worksheet cell without copying the contents of the cell. |
| Source file | The original file |
| Column Chart | Uses bars of varying heights to illustrate values in a worksheet and is useful for showing relationships among categories of data. |
| Line Chart | Similar to a column chart except columns are replaced by points connected by a line. |
| Pie Chart | Shows the relationship of a part to a whole. |
| Scatter Charts | Show the relationship between two categories of data. |
| Chart sheet | A seperate sheet in the workbook on which you can create and store a chart. |
| Embedded Chart | Created within a worksheet |
