BUS 1350 – Exam 2 Key Terms, Risinger, 2026 – Study guide and reference
material
MODULE 5 - correct answer ✔✔ MODULE 5
3-D range - correct answer ✔✔ a range that spans two or more worksheets in a workbook
broken link - correct answer ✔✔ a hyperlink that no longer works because the file it refers to
has been moved
defined name - correct answer ✔✔ a user-defined name that replaces a cell reference. Also
called a name range
Destination workbook - correct answer ✔✔ the workbook that receives data from another
workbook when two workbooks are linked;sometimes referred to as the dependent file
edit mode - correct answer ✔✔ The mode in which you can make changes to a cell's content
directly in the cell
external reference - correct answer ✔✔ a reference to a cell or range in a worksheet in a
different workbook
external reference indicator - correct answer ✔✔ In excel, an exclamation point(!) used in a
formula to indicate that a referenced cell is outside the active sheet
link - correct answer ✔✔ In excel, to consolidate data from seperate workbooks
linked data types - correct answer ✔✔ data types linked to resources on the Internet
,linked object - correct answer ✔✔ an object, such as text selection, value, or picture that is
contained in a destination file and linked to a source file; when a change is made to the linked
object in the source file, the change also occurs in the linked object in the destination file
name box - correct answer ✔✔ a box to the left of the formula bar that shows the cell reference
or name of the active cell
named range - correct answer ✔✔ a user-defined name that replaces a cell reference. Also
called a defined name
range - correct answer ✔✔ a group of cells in a rectangular block in a worksheet. Also called a
cell range.
source range - correct answer ✔✔ when a range is used as a source
source workbooks - correct answer ✔✔ workbook from which you copy or link data
Worksheet group - correct answer ✔✔ A collection of two or more selected worksheets
Worksheet Reference - correct answer ✔✔ a data type that refers to a rectangular block of
cells(which can be just one cell), or in some cases, a number of non contiguous blocks of cells
2-D reference - correct answer ✔✔ formulas with references to cells on the same sheet can be
thought of as 2-D references because they involve only the row addresses and column
addresses
3-D reference - correct answer ✔✔ A 3-D reference includes the row address, the column
address, and the worksheet address, expressed within a single reference
, external reference - correct answer ✔✔ References to cells in other workbooks that establish a
link, or a connection, between a source workbook containing the data and the destination
workbook receiving the data
hyperlink - correct answer ✔✔ a text string or graphic image connected to a wide variety of
resources
screentip - correct answer ✔✔ A label that appears when you point to some buttons and icons
and that identifies the name of the button or feature, briefly describes its function, conveys any
keyboard shortcut for the command, and includes a link to associated help topics, if any.
vertical workbook window - correct answer ✔✔ expands the height of the windows to fill the
screen and places them in a single row
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 ✔✔ a file that contains an object created in a source file
destination program - correct answer ✔✔ in a data exchange, the program used to create the
file into which you want to paste, embed, or link an object from a source file
destination range - correct answer ✔✔ the range being used as a destination in a data exchange
profit and loss statement - correct answer ✔✔ a financial statement that summarizes the
income and expenses incurred during a specific interval. Also called an income statement
source file - correct answer ✔✔ a file in which you create an object
material
MODULE 5 - correct answer ✔✔ MODULE 5
3-D range - correct answer ✔✔ a range that spans two or more worksheets in a workbook
broken link - correct answer ✔✔ a hyperlink that no longer works because the file it refers to
has been moved
defined name - correct answer ✔✔ a user-defined name that replaces a cell reference. Also
called a name range
Destination workbook - correct answer ✔✔ the workbook that receives data from another
workbook when two workbooks are linked;sometimes referred to as the dependent file
edit mode - correct answer ✔✔ The mode in which you can make changes to a cell's content
directly in the cell
external reference - correct answer ✔✔ a reference to a cell or range in a worksheet in a
different workbook
external reference indicator - correct answer ✔✔ In excel, an exclamation point(!) used in a
formula to indicate that a referenced cell is outside the active sheet
link - correct answer ✔✔ In excel, to consolidate data from seperate workbooks
linked data types - correct answer ✔✔ data types linked to resources on the Internet
,linked object - correct answer ✔✔ an object, such as text selection, value, or picture that is
contained in a destination file and linked to a source file; when a change is made to the linked
object in the source file, the change also occurs in the linked object in the destination file
name box - correct answer ✔✔ a box to the left of the formula bar that shows the cell reference
or name of the active cell
named range - correct answer ✔✔ a user-defined name that replaces a cell reference. Also
called a defined name
range - correct answer ✔✔ a group of cells in a rectangular block in a worksheet. Also called a
cell range.
source range - correct answer ✔✔ when a range is used as a source
source workbooks - correct answer ✔✔ workbook from which you copy or link data
Worksheet group - correct answer ✔✔ A collection of two or more selected worksheets
Worksheet Reference - correct answer ✔✔ a data type that refers to a rectangular block of
cells(which can be just one cell), or in some cases, a number of non contiguous blocks of cells
2-D reference - correct answer ✔✔ formulas with references to cells on the same sheet can be
thought of as 2-D references because they involve only the row addresses and column
addresses
3-D reference - correct answer ✔✔ A 3-D reference includes the row address, the column
address, and the worksheet address, expressed within a single reference
, external reference - correct answer ✔✔ References to cells in other workbooks that establish a
link, or a connection, between a source workbook containing the data and the destination
workbook receiving the data
hyperlink - correct answer ✔✔ a text string or graphic image connected to a wide variety of
resources
screentip - correct answer ✔✔ A label that appears when you point to some buttons and icons
and that identifies the name of the button or feature, briefly describes its function, conveys any
keyboard shortcut for the command, and includes a link to associated help topics, if any.
vertical workbook window - correct answer ✔✔ expands the height of the windows to fill the
screen and places them in a single row
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 ✔✔ a file that contains an object created in a source file
destination program - correct answer ✔✔ in a data exchange, the program used to create the
file into which you want to paste, embed, or link an object from a source file
destination range - correct answer ✔✔ the range being used as a destination in a data exchange
profit and loss statement - correct answer ✔✔ a financial statement that summarizes the
income and expenses incurred during a specific interval. Also called an income statement
source file - correct answer ✔✔ a file in which you create an object
