| A | B |
|---|
| pivot table | Interactive tool that lets you summarize or cross-tabulate a data list. |
| field | In a data list, a field is each category of information in a record. A column represents a field. |
| data form | Displays one record at a time. |
| record | In a data list, all the information about one person or thing. A row in a data list. |
| field label | Name assigned to each field in a data list that describes the field. |
| database | An organized collection of related information. |
| templates | Predesigned workbook files that you can use as a basis for building your own files. |
| validation checks | Lets you define what type of data can be entered in a worksheet. |
| macro | Recording a series of word commands that you can use to automatically carry out tasks. |
| legend | A written description for understanding the various data series that appears in the plotted area. |
| data series | A series of related values from the worksheet. The data series is compiled of related data markers. |
| Y-axis | The vertical axis that is used for plotting values. |
| data range | Tab that allows you to specify the cells that contain data you want charted. |
| X-axis | The horizontal axis that is used for showing categories. |
| Wizard | Word feature that takes you step-by-step through the creation of a certain type of document. You select from a series of options in a series of dialog boxes to prepare the final document. |
| consolidating data | Allows you to summarize large amounts of data on one worksheet. |
| 3-D reference | Formulas that include references to the source cells, by position and category. |
| workspace | Multiple workbooks saved as a single entity so that all you have to do is open one file and all the workbooks in the group open simultaneously. |
| destination area | A range that will hold consolidated information. |
| split box | A Word feature that allows you to divide the screen into two panes so that you can see two different parts of the document at the same time. |
| source area | Cell or a range of cells on a single worksheet, on various worksheets in the same workbook, or on various sheets in different workbooks, that contain values you want to combine or consolidate with other values. |
| functions | Built-in shortcut for entering a formula that lets you perform a predefined calculation on selected data. |
| absolute reference | Represents a permanent reference to a cell; that is, the cell reference does not change in relation to the location of the formula. |
| range finder | Color-codes each cell and/or range in the formula and its corresponding cell and/or range on the worksheet. |
| relative reference | Represents a reference to a cell that changes in relation to the location of the formula. |
| mixed reference | In formulas, it has either an absolute row or an absolute column reference. |
| syntax | Structure of elements in a formula, it determines how a calculation is performed. |
| decrease decimal button | Button that moves decimal point to the right. |
| style | Named combination of formats; a collection of formatting commands that define the appearance of various text elements of a document. |
| increase decimal button | Button that moves decimal point to the left. |
| point | The unit of measure for fonts (1/72 inch). |
| center across selection | Centers the contents of the leftmost cell in a selection across the selected range. |
| .font | The design of the characters (typeface) you enter. |
| scaling | Lets you enlarge or reduce the image that prints. |
| HTML | The system of coding text so that it can appear on the World Wide Web. |
| orientation | The direction that text is printed on a page. (landscape, length--portrait, width) |
| Web toolbar | A toolbar that contains a number of buttons to help you easily negotiate the Web. |
| template | Predesigned workbook files that you can use as a basis for building your own files. |
| fill handle | Copies contents of a cell into adjacent cells. |
| range | A group of cells. |
| mouse pointer | Cross-shaped pointer that appears when the mouse is over a cell. |
| cell | The rectangle where a column and row intersect. |
| worksheet | Each spreadsheet in a workbook. |
| workbook | An Excel file. |
