D100 Questions
What advances in technology have become increasingly important for managers in their
decision-making?
a. Technology readiness
b. Battery technology
c. Mobile computing technology
d. Technology Management - ANS-c. Mobile computing technology
Mobile computing technology is an important technological advancement related to
Excel's increasing importance to managers' decision-making.
Which Excel features can be found in the File menu tab?
a. Options for formatting print settings
b. Options for working with Excel windows
c. Options for opening and saving workbook files
d. Options for formatting cells - ANS-c. Options for opening and saving workbook files
The File menu tab opens settings for opening, sharing, and saving a workbook file.
What is a collection of cells arranged in columns and rows?
a. A worksheet
b. A spreadsheet file
c. A workbook
d. A menu tab - ANS-a. A worksheet
A worksheet is a collection of cells arranged in columns and rows. Many worksheets
come together to form a workbook.
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 equals character (=)
b. The multiplication character (*)
c. The division character (/)
d. The exponent character (^) - ANS-a. The equals character (=)
The equals sign is the first character in a cell. Without the equals sign, Excel would not
recognize the cell's contents as a calculation.
, The result of a function changes as the values in the other cells referenced by that
function change in what kind of function?
a. Dynamic
b. Simple
c. Static
d. Complex - ANS-a. Dynamic
A dynamic function changes when the values in the cells it references change.
Which Excel feature(s) are used to reuse a formula from one cell to another?
a. Freeze Panes
b. Copy and Paste
c. Repeat Headers
d. Sort and Filter - ANS-b. Copy and Paste
Copy and Paste allow you to transfer a formula into another cell.
A spreadsheet template __________.
a. is static and resistant to changes in the worksheet
b. may only be used by the person who created it
c. must be rebuilt every time a person uses it
d. can be used repeatedly with changing inputs - ANS-d. can be used repeatedly with
changing inputs
A spreadsheet template is very versatile.
Which arithmetic operator is evaluated first in an Excel arithmetic expression?
a. Parentheses
b. Exponents
c. Addition and Subtraction
d. Multiplication and Division - ANS-a. Parentheses
Parentheses are the first part of an arithmetic expression that must be evaluated.
Excel would evaluate the expression =25-15/5*2+7 to the value of?
a. 26
b. 11
c. 8
d. 18 - ANS-a. 26
What advances in technology have become increasingly important for managers in their
decision-making?
a. Technology readiness
b. Battery technology
c. Mobile computing technology
d. Technology Management - ANS-c. Mobile computing technology
Mobile computing technology is an important technological advancement related to
Excel's increasing importance to managers' decision-making.
Which Excel features can be found in the File menu tab?
a. Options for formatting print settings
b. Options for working with Excel windows
c. Options for opening and saving workbook files
d. Options for formatting cells - ANS-c. Options for opening and saving workbook files
The File menu tab opens settings for opening, sharing, and saving a workbook file.
What is a collection of cells arranged in columns and rows?
a. A worksheet
b. A spreadsheet file
c. A workbook
d. A menu tab - ANS-a. A worksheet
A worksheet is a collection of cells arranged in columns and rows. Many worksheets
come together to form a workbook.
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 equals character (=)
b. The multiplication character (*)
c. The division character (/)
d. The exponent character (^) - ANS-a. The equals character (=)
The equals sign is the first character in a cell. Without the equals sign, Excel would not
recognize the cell's contents as a calculation.
, The result of a function changes as the values in the other cells referenced by that
function change in what kind of function?
a. Dynamic
b. Simple
c. Static
d. Complex - ANS-a. Dynamic
A dynamic function changes when the values in the cells it references change.
Which Excel feature(s) are used to reuse a formula from one cell to another?
a. Freeze Panes
b. Copy and Paste
c. Repeat Headers
d. Sort and Filter - ANS-b. Copy and Paste
Copy and Paste allow you to transfer a formula into another cell.
A spreadsheet template __________.
a. is static and resistant to changes in the worksheet
b. may only be used by the person who created it
c. must be rebuilt every time a person uses it
d. can be used repeatedly with changing inputs - ANS-d. can be used repeatedly with
changing inputs
A spreadsheet template is very versatile.
Which arithmetic operator is evaluated first in an Excel arithmetic expression?
a. Parentheses
b. Exponents
c. Addition and Subtraction
d. Multiplication and Division - ANS-a. Parentheses
Parentheses are the first part of an arithmetic expression that must be evaluated.
Excel would evaluate the expression =25-15/5*2+7 to the value of?
a. 26
b. 11
c. 8
d. 18 - ANS-a. 26
