Intro To Spreadsheets - D100 WGU QUESTIONS AND
ANSWERS 2026
Absolute Cell Reference - Correct Answer A cell reference that remains constant when a
formula is pasted into a new cell; contains two "$".
Algorithm - Correct Answer The part of a calculation that is applied to the measure. Example:
average gas price.
Arguments - Correct Answer The information inputted to create a function
Bar Charts - Correct 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 - Correct Answer Small boxes that store individual pieces of data or calculations
Charts - Correct 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 - Correct 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.
, Column and Row Labels - Correct Answer Used to define how the data will be summarized and
arranged on the PivotTable, defines how source data will be categorized
Data - Correct Answer A class of menu items used to aid in importing and working with large
amounts of data.
Dynamic - Correct Answer A formula that references and responds to changes in values in other
cells
Expression - Correct Answer The calculation prescribed by the a formula in a spreadsheet
File - Correct Answer A class of menu items used to manipulate workbooks.
Formula Auditing - Correct Answer Analyzing a calculation in a spreadsheet to ensure that it is
correct
Formulas - Correct Answer The calculations performed in a spreadsheet.
Function Wizard - Correct Answer A window that allows you to select inputs for a function. Also
provides a description of the function and lists the function result based on the inputs you enter
Graphs - Correct Answer - A two-dimensional representation of numerical data using a line or a
curve
- Used to display a numerical representation of data
Home - Correct Answer A class of menu items used to format the appearance of data in cells.
ANSWERS 2026
Absolute Cell Reference - Correct Answer A cell reference that remains constant when a
formula is pasted into a new cell; contains two "$".
Algorithm - Correct Answer The part of a calculation that is applied to the measure. Example:
average gas price.
Arguments - Correct Answer The information inputted to create a function
Bar Charts - Correct 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 - Correct Answer Small boxes that store individual pieces of data or calculations
Charts - Correct 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 - Correct 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.
, Column and Row Labels - Correct Answer Used to define how the data will be summarized and
arranged on the PivotTable, defines how source data will be categorized
Data - Correct Answer A class of menu items used to aid in importing and working with large
amounts of data.
Dynamic - Correct Answer A formula that references and responds to changes in values in other
cells
Expression - Correct Answer The calculation prescribed by the a formula in a spreadsheet
File - Correct Answer A class of menu items used to manipulate workbooks.
Formula Auditing - Correct Answer Analyzing a calculation in a spreadsheet to ensure that it is
correct
Formulas - Correct Answer The calculations performed in a spreadsheet.
Function Wizard - Correct Answer A window that allows you to select inputs for a function. Also
provides a description of the function and lists the function result based on the inputs you enter
Graphs - Correct Answer - A two-dimensional representation of numerical data using a line or a
curve
- Used to display a numerical representation of data
Home - Correct Answer A class of menu items used to format the appearance of data in cells.
