| A | B |
| Input Mask | A template-like field property that regulates how data is entered in a cell. |
| Join line | A graphical representation of the link between two or more tables |
| Junction table | A table used to join primary key fields from multiple tables. |
| Label | Cell data classification used for cells that contain text or for numbers that will not be used in calculations. |
| Layout | The arrangement of text and graphics on a slide. |
| Legend | The object that explains the symbols, colors, or patterns used to differentiate data. |
| Line Chart | A chart used to show trends or changes in data over time. |
| Linked Chart | A chart that will change to reflect changes made to the spreadsheet it represents. |
| Linked Object | Type of object in which the container merely saves the actual file name, as opposed to the whole file. |
| Linking | Used to integrate spreadsheet data with other software applications when you want the target data to update anytime the spreadsheet data is edited. |
| List | A feature used to create a more user-friendly spreadsheet atmosphere. |
| LookUp Function | A 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. |
| Look-up Wizard | A data type that allows you to create a finite set of choices for that field's entry values. |
| Many-to-many | Relationship where multiple records from both (or more) tables are linked. |
| Master | A special type of slide that serves as a model. |
| Min | A function that displays the smallest value in a range of cells. |
| Memo | A field type used for lengthy entries that allows combinations of text and numbers. |
| Merge and Center | Used to combine adjacent cell ranges or cells. |
| Max | A function that displays the maximum value in a range of cells. |
| Multimedia | Presenting data in more than one medium, such as combining text, graphics, animation, video and sound. |
| Non-Validated List | Allows additional entries other than those provided in the drop-down menu. |
| Number | A field type that may not include anything but numbers. |
| One-to-many | Relationship where a record in one table is linked to more than one record in another table. |