| A | B |
|---|
| Functions | predefined formulas which perform a specific calculation based on the data specified |
| PivotTable | table which can be rearranged to analyze data in a variety of ways |
| PivotChart | chart created based on a PivotTable or data which can be rearranged to illustrate data |
| Excel Tables (Tables) | data arranged in columns and formatted with column headers containing commands to sort, filter and perform other functions on the contents |
| Charts | graphic representations used to compare and contrast worksheet data |
| Filters | tool which can be used to display only data which meets certain criteria |
| Sort | tool which can be used to organize or group data |
| Conditional Formatting | tool which applies formatting to cells based upon their content and specified rules |
| Macro | series of commands and instructions grouped together to accomplish a task automatically |
| #NAME? | error which occurs when a misspelling has occurred in a function name |
| #REF! | error which occurs when the cell reference is not valid |
| ##### (Railroad Tracks Error) | error which occurs when the column is not wide enough to display the contents of a cell |
| Formulas | are expressions which return values |
| Footer | text or graphics printed at the bottom of each printed page |
| Header | text or graphics printed at the top of each printed page |
| Named Ranges | range of cells or a single cell which have been given a descriptive range name to reference it by rather than the cell addresses |
| Non-Contiguous Selection | selection of cells which are not next to each other |
| Contiguous Selection | selection of multiple cells which are next to each other |
| AutoComplete | feature which finishes an entry based on previous entries made in the column containing the active cell |
| Flash Fill | feature which can be used to recognize a pattern in text and change the format of the text for the series |
| Auto Fill | feature which fills cells with data which follows a pattern or is based on data in other cells |
| Mixed Cell References | contain both relative and absolute cell references such as $A1 or B$2 |
| Absolute Cell References | point to a specific cell in the worksheet and utilizes dollar signs in the reference name such as $A$1 or $B$2 |
| Relative Cell References | provide the address of a cell based on its relative location in a workbook such as A1 or B2 |
| Cell References | specify the location of a cell in a worksheet by identifying its column letter and row number |
| Cells | intersection of a column and a row on a worksheet |
| File Extension | a dot followed by three or four characters at the end of the file name used to show the file type |
| File Type | format in which a file is stored; typically corresponds to the program used to create the file |
| Keyboard Shortcuts | key combinations which perform certain commands when pressed |
| Synchronous Scrolling | ability to scroll through multiple spreadsheets at the same time |
| Templates | sample files which contain some formatting and can be customized to serve as starting point for a new workbook |
| Workbooks | files used to store worksheets |
| Worksheets | computerized spreadsheets found in Microsoft® Excel |
| Spreadsheets | grids of rows and columns in which text, numbers and the results of calculations can be entered |
