BUS 1350 – Final Exam, 2026 – Comprehensive review and practice material
3D reference - correct answer ✔✔ A reference to the same cell or range in multiple worksheets
in the same workbook
broken link - correct answer ✔✔ A reference to a file that has been moved since the link was
created
Custom template - correct answer ✔✔ 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 - correct answer ✔✔ The workbook that receives data from another workbook
when two workbooks are linked; sometimes referred to as the dependent file
external reference - correct answer ✔✔ A reference to cells or ranges in a worksheet from
another workbook
Hyperlink - correct answer ✔✔ A link in a file, such as a workbook, to information within that
file or another file.
link - correct answer ✔✔ A connection between files that allows data to be transferred from
one file to another.
source file - correct answer ✔✔ A workbook that contains data to be used in the destination file
when two or more workbooks are linked
2-D reference - correct answer ✔✔ Formulas with references to cells on the same sheet can be
thought of as 2-D (or 2-dimensional) references because they involve only the row address and
the column address.
3D reference - correct answer ✔✔ A reference to the same cell or range in multiple worksheets
in the same workbook
broken link - correct answer ✔✔ A reference to a file that has been moved since the link was
created
Custom template - correct answer ✔✔ 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 - correct answer ✔✔ The workbook that receives data from another workbook
when two workbooks are linked; sometimes referred to as the dependent file
external reference - correct answer ✔✔ A reference to cells or ranges in a worksheet from
another workbook
Hyperlink - correct answer ✔✔ A link in a file, such as a workbook, to information within that
file or another file.
link - correct answer ✔✔ A connection between files that allows data to be transferred from
one file to another.
source file - correct answer ✔✔ A workbook that contains data to be used in the destination file
when two or more workbooks are linked
2-D reference - correct answer ✔✔ Formulas with references to cells on the same sheet can be
thought of as 2-D (or 2-dimensional) references because they involve only the row address and
the column address.
