Module 5 Excel Flashcards
3-D reference
a reference to the same cell or range in multiple worksheets in the same workbook
broken link
a reference to a file that has been moved since the link was created
custom template
a workbook template you create that is ready to run with the formulas for all calculations included as well as all formatting and labels
destination file
the workbook that receives data form another workbook when two workbooks are linked; sometimes referred to as the dependent file
external reference
a reference to cells or ranges in a worksheet from another workbook
hyperlink
a link in a file, such as a workbook, to information within that file or another file
link
a connection between files that allows data to be used in the destination file when two or more workbooks are linked
source file
a workbook that contains data to be used in the destination file when two or more workbooks are linked
worksheet group
a collection of two or more selected worksheets
range name (defined named)
a word or string of characters assigned to a cell or range