BUS 1350 EXAM 1 RISINGER
QUESTIONS & PASSED CORRECT
ANSWERS
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 name range
Destination workbook - Correct Answer ✔✔ the workbook that receives data from
another workbook when 2 workbooks are linked; Also called dependent file
edit mode - Correct Answer ✔✔ The mode in which you can edit cell contents directly in
cell
external reference - Correct Answer ✔✔ a reference to a cell or range on a sheet in
another Excel workbook, or a reference to a defined name in another workbook.
external reference indicator - Correct Answer ✔✔ the 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 separate workbooks
linked data types - Correct Answer ✔✔ Data types linked to resources on internet
linked object - Correct Answer ✔✔ A picture or other object inserted into a document by
creating a connection between the document and picture file but not combining them in
the same file. Compare to embedded object.
Name Box - Correct Answer ✔✔ The cell reference area located below the Ribbon,
which displays the cell reference of the active cell.
range - Correct Answer ✔✔ A group of selected cells in a rectangular block
source range - Correct Answer ✔✔ when a range is used as a source
Source workbook - 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 disjoint blocks
of cells.
2-D reference - Correct Answer ✔✔ formulas with references to cells on same sheet
can be thought of as 2-D because they only involve row and column
3-D reference - Correct Answer ✔✔ a 3-D reference includes row, column, and
worksheet addresses in single reference
Hyperlink - Correct Answer ✔✔ a text string or graphic image connected to wide variety
of sources
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 height of windows to fill
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 ✔✔ The program used to create the file in which
you want to insert an object that was created using another program.
destination range - Correct Answer ✔✔ Term used to refer to a range being used as a
destination.
profit and loss statement - Correct Answer ✔✔ a financial statement that summarizes
the revenues, costs and expenses incurred during a specific period of time, usually a
fiscal quarter or year.
source file - Correct Answer ✔✔ a file in which you create an object
Synchronized scrolling - Correct Answer ✔✔ Allows you to scroll in one pane while the
other pane(s) move similarly
Template - Correct Answer ✔✔ predesigned workbook that contains all built-in formulas
QUESTIONS & PASSED CORRECT
ANSWERS
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 name range
Destination workbook - Correct Answer ✔✔ the workbook that receives data from
another workbook when 2 workbooks are linked; Also called dependent file
edit mode - Correct Answer ✔✔ The mode in which you can edit cell contents directly in
cell
external reference - Correct Answer ✔✔ a reference to a cell or range on a sheet in
another Excel workbook, or a reference to a defined name in another workbook.
external reference indicator - Correct Answer ✔✔ the 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 separate workbooks
linked data types - Correct Answer ✔✔ Data types linked to resources on internet
linked object - Correct Answer ✔✔ A picture or other object inserted into a document by
creating a connection between the document and picture file but not combining them in
the same file. Compare to embedded object.
Name Box - Correct Answer ✔✔ The cell reference area located below the Ribbon,
which displays the cell reference of the active cell.
range - Correct Answer ✔✔ A group of selected cells in a rectangular block
source range - Correct Answer ✔✔ when a range is used as a source
Source workbook - 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 disjoint blocks
of cells.
2-D reference - Correct Answer ✔✔ formulas with references to cells on same sheet
can be thought of as 2-D because they only involve row and column
3-D reference - Correct Answer ✔✔ a 3-D reference includes row, column, and
worksheet addresses in single reference
Hyperlink - Correct Answer ✔✔ a text string or graphic image connected to wide variety
of sources
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 height of windows to fill
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 ✔✔ The program used to create the file in which
you want to insert an object that was created using another program.
destination range - Correct Answer ✔✔ Term used to refer to a range being used as a
destination.
profit and loss statement - Correct Answer ✔✔ a financial statement that summarizes
the revenues, costs and expenses incurred during a specific period of time, usually a
fiscal quarter or year.
source file - Correct Answer ✔✔ a file in which you create an object
Synchronized scrolling - Correct Answer ✔✔ Allows you to scroll in one pane while the
other pane(s) move similarly
Template - Correct Answer ✔✔ predesigned workbook that contains all built-in formulas
