Intro to Spreadsheets D100 Questions and
Correct Answers with Complete Solutions | New
Update 2025
What advances in technology have become increasingly important for managers
in their decision-making?
A. Battery technology
B. Mobile computing technology
C. Technology management
D. Technology readiness - ANSWER B. Mobile computing technology
Absolute cell reference - ANSWER A cell reference that remains constant when
a formula is pasted into a new cell. To make a cell reference absolute, put a "$"
character in front of the part of the reference that you wish to remain constant
when a formula is pasted into a new cell.
Relative, mixed, and absolute cell references - ANSWER A1 - Both the column
and row references are relative and will change when the reference is copied and
pasted to other cells.
$A1 - The column reference is absolute and will remain constant when copied and
pasted to other cells. The row reference is relative and will change when copied
and pasted to cells in other rows of the worksheet.
A$1 - The column reference is relative and will change when copied and pasted to
cells in other columns in the worksheet. The row reference is absolute and will
remain constant when copied and pasted to other cells.
, $A$1 - Both the column and row references are absolute and will remain constant
when the reference is copied and pasted to other cells.
When it appears as the first character in a cell, which character signals to Excel
that the contents of the cell should be treated as a calculation?
A. The exponent character ^
B. The division character /
C. The equals character =
D. The multiplication character * - ANSWER
The result of a function changes as the values in the other cells referenced by that
function change in what kind of function?
A. Static
B. Complex
C. Simple
D. Dynamic - ANSWER D. Dynamic
Which Excel feature(s) are used to reuse a formula from one cell to another?
A. Copy and Paste
B. Freeze Panes
C. Repeat Headers
D. Sort and Filter - ANSWER A. Copy and Paste
Correct Answers with Complete Solutions | New
Update 2025
What advances in technology have become increasingly important for managers
in their decision-making?
A. Battery technology
B. Mobile computing technology
C. Technology management
D. Technology readiness - ANSWER B. Mobile computing technology
Absolute cell reference - ANSWER A cell reference that remains constant when
a formula is pasted into a new cell. To make a cell reference absolute, put a "$"
character in front of the part of the reference that you wish to remain constant
when a formula is pasted into a new cell.
Relative, mixed, and absolute cell references - ANSWER A1 - Both the column
and row references are relative and will change when the reference is copied and
pasted to other cells.
$A1 - The column reference is absolute and will remain constant when copied and
pasted to other cells. The row reference is relative and will change when copied
and pasted to cells in other rows of the worksheet.
A$1 - The column reference is relative and will change when copied and pasted to
cells in other columns in the worksheet. The row reference is absolute and will
remain constant when copied and pasted to other cells.
, $A$1 - Both the column and row references are absolute and will remain constant
when the reference is copied and pasted to other cells.
When it appears as the first character in a cell, which character signals to Excel
that the contents of the cell should be treated as a calculation?
A. The exponent character ^
B. The division character /
C. The equals character =
D. The multiplication character * - ANSWER
The result of a function changes as the values in the other cells referenced by that
function change in what kind of function?
A. Static
B. Complex
C. Simple
D. Dynamic - ANSWER D. Dynamic
Which Excel feature(s) are used to reuse a formula from one cell to another?
A. Copy and Paste
B. Freeze Panes
C. Repeat Headers
D. Sort and Filter - ANSWER A. Copy and Paste
