1|Page
WGU D100 OBJECTIVE ASSESSMENT NEWEST 2026 TEST BANK |
D100 INTRODUCTION TO SPREADSHEETS OA EXAM WITH
COMPLETE REAL EXAM QUESTIONS AND CORRECT VERIFIED
ANSWERS / ALREADY GRADED A+ (MOST RECENT!!)
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
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
,2|Page
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
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. Can be used repeatedly with changing inputs
D. Must be rebuilt every time a person uses it ......ANSWER......C. Can be
used repeatedly with changing inputs
Compare and contrast the COUNT and COUNTA formulas
......ANSWER......COUNT counts the number of cells in a range that
contain numbers
COUNTA counts the number of cells in a range of cells that are not blank
Describe the order of operations in Excel ......ANSWER......1.
Parentheses
,3|Page
2. Exponents
3. Multiplication and Division
4. Addition and Subtraction
Excel would evaluate the expression =25-15/5*2+7 to the value of?
A. 11
B. 26
C. 18
D. 8 ......ANSWER......B. 26
Excel would evaluate the expression =(18+15)/4*2+3 to the value of?
A. 19.5
B. 28.5
C. 7.1
D. 22.8 ......ANSWER......A. 19.5
What is the process of analyzing a calculation in a spreadsheet to
ensure it is correct?
A. Cell referencing
, 4|Page
B. Freezing panes
C. Filtering data
D. Formula auditing ......ANSWER......D. Formula auditing
What kind of calculation contains an error caused by poor input?
A. A calculation that does not respond to changes in the cells
referenced in the calculation
B. A calculation that responds to changes in the cells referenced in the
calculation
C. A calculation that includes inaccurate or incomplete data
D. A calculation that includes an inaccurate or incomplete algorithm
......ANSWER......C. A calculation that includes inaccurate or incomplete
dat
What kind of calculation contains an error caused by poor logic?
A. A calculation that does not respond to changes in the cells
referenced in the calculation
B. A calculation that responds to changes in the cells referenced in the
calculation
C. A calculation that includes an inaccurate or incomplete algorithm
WGU D100 OBJECTIVE ASSESSMENT NEWEST 2026 TEST BANK |
D100 INTRODUCTION TO SPREADSHEETS OA EXAM WITH
COMPLETE REAL EXAM QUESTIONS AND CORRECT VERIFIED
ANSWERS / ALREADY GRADED A+ (MOST RECENT!!)
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
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
,2|Page
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
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. Can be used repeatedly with changing inputs
D. Must be rebuilt every time a person uses it ......ANSWER......C. Can be
used repeatedly with changing inputs
Compare and contrast the COUNT and COUNTA formulas
......ANSWER......COUNT counts the number of cells in a range that
contain numbers
COUNTA counts the number of cells in a range of cells that are not blank
Describe the order of operations in Excel ......ANSWER......1.
Parentheses
,3|Page
2. Exponents
3. Multiplication and Division
4. Addition and Subtraction
Excel would evaluate the expression =25-15/5*2+7 to the value of?
A. 11
B. 26
C. 18
D. 8 ......ANSWER......B. 26
Excel would evaluate the expression =(18+15)/4*2+3 to the value of?
A. 19.5
B. 28.5
C. 7.1
D. 22.8 ......ANSWER......A. 19.5
What is the process of analyzing a calculation in a spreadsheet to
ensure it is correct?
A. Cell referencing
, 4|Page
B. Freezing panes
C. Filtering data
D. Formula auditing ......ANSWER......D. Formula auditing
What kind of calculation contains an error caused by poor input?
A. A calculation that does not respond to changes in the cells
referenced in the calculation
B. A calculation that responds to changes in the cells referenced in the
calculation
C. A calculation that includes inaccurate or incomplete data
D. A calculation that includes an inaccurate or incomplete algorithm
......ANSWER......C. A calculation that includes inaccurate or incomplete
dat
What kind of calculation contains an error caused by poor logic?
A. A calculation that does not respond to changes in the cells
referenced in the calculation
B. A calculation that responds to changes in the cells referenced in the
calculation
C. A calculation that includes an inaccurate or incomplete algorithm
