| Consolidate | Summarizing data from multiple worksheets.
|
 |
|
|
| Consolidation worksheet | See summary worksheet.
|
|
|
|
| Dependent workbook | A workbook containing a link to a supporting worksheet.
|
|
|
|
| Drilling down | Entering data in the same cell of several workbooks simultaneously.
|
|
|
|
| Dynamic link | See link.
|
|
|
|
| External reference | See link.
|
|
|
|
| Link | Formulas that reference cells in other worksheets.
|
|
|
|
| Path | The disk drive and folders that lead to a referenced workbook.
|
|
|
|
| Summary worksheet | Contains a digest or synopsis of the information contained in the individual worksheets.
|
|
|
|
| Supporting workbook | A workbook containing a worksheet to which a link formula refers.
|
|
|
|
| Supporting worksheets | Worksheets that are referenced by other worksheets.
|
|
|
|
| Three-dimensional formulas | Formulas that reference other worksheets in the current workbook.
|
|
|
|
| Two-dimensional formulas | Formulas that reference cells on a single worksheet.
|