age 1 of 17
WGU D100 Introduction to Spreadsheets OBJECTIVE
ASSESSMENT ACTUAL EXAM STUDY GUIDE 2025/2026
ACCURATE QUESTIONS AND CORRECT DETAILED
ANSWERS WITH RATIONALES || 100% GUARANTEED
PASS <LATEST VERSION>
Absolute Cell Reference ......ANSWER........A cell reference that
remains constant when a formula is pasted into a new cell;
contains two "$".
Algorithm ......ANSWER........The part of a calculation that is
applied to the measure. Example: average gas price.
Arguments ......ANSWER........The information inputted to create a
function
,age 2 of 17
Bar Charts ......ANSWER........Charts that depict values with boxes
that span the horizontal axis of the chart. The length of the
boxes represents the individual values. Larger values are
depicted using longer boxes.
Cells ......ANSWER........Small boxes that store individual pieces of
data or calculations
Charts ......ANSWER........- Depictions of larger data sets which
less-related categories
- A visual representation of usually larger sets of data where
categories may or may not be related to each other
Column Charts ......ANSWER........Charts that depict values with
boxes that span the vertical axis of the chart. The length of the
boxes represents the individual values. Larger values are
depicted using longer boxes.
, age 3 of 17
Column and Row Labels ......ANSWER........Used to define how the
data will be summarized and arranged on the PivotTable,
defines how source data will be categorized
Data ......ANSWER........A class of menu items used to aid in
importing and working with large amounts of data.
Dynamic ......ANSWER........A formula that references and
responds to changes in values in other cells
Expression ......ANSWER........The calculation prescribed by the a
formula in a spreadsheet
File ......ANSWER........A class of menu items used to manipulate
workbooks.
Formula Auditing ......ANSWER........Analyzing a calculation in a
spreadsheet to ensure that it is correct
WGU D100 Introduction to Spreadsheets OBJECTIVE
ASSESSMENT ACTUAL EXAM STUDY GUIDE 2025/2026
ACCURATE QUESTIONS AND CORRECT DETAILED
ANSWERS WITH RATIONALES || 100% GUARANTEED
PASS <LATEST VERSION>
Absolute Cell Reference ......ANSWER........A cell reference that
remains constant when a formula is pasted into a new cell;
contains two "$".
Algorithm ......ANSWER........The part of a calculation that is
applied to the measure. Example: average gas price.
Arguments ......ANSWER........The information inputted to create a
function
,age 2 of 17
Bar Charts ......ANSWER........Charts that depict values with boxes
that span the horizontal axis of the chart. The length of the
boxes represents the individual values. Larger values are
depicted using longer boxes.
Cells ......ANSWER........Small boxes that store individual pieces of
data or calculations
Charts ......ANSWER........- Depictions of larger data sets which
less-related categories
- A visual representation of usually larger sets of data where
categories may or may not be related to each other
Column Charts ......ANSWER........Charts that depict values with
boxes that span the vertical axis of the chart. The length of the
boxes represents the individual values. Larger values are
depicted using longer boxes.
, age 3 of 17
Column and Row Labels ......ANSWER........Used to define how the
data will be summarized and arranged on the PivotTable,
defines how source data will be categorized
Data ......ANSWER........A class of menu items used to aid in
importing and working with large amounts of data.
Dynamic ......ANSWER........A formula that references and
responds to changes in values in other cells
Expression ......ANSWER........The calculation prescribed by the a
formula in a spreadsheet
File ......ANSWER........A class of menu items used to manipulate
workbooks.
Formula Auditing ......ANSWER........Analyzing a calculation in a
spreadsheet to ensure that it is correct
