Intro To Spreadsheets - D100 WGU
Absolute Cell Reference A cell reference that remains constant when a formula is pasted
contains two "$".
Algorithm The part of a calculation that is applied to the measure. Examp
price.
Arguments The information inputted to create a function
Bar Charts Charts that depict values with boxes that span the horizontal a
The length of the boxes represents the individual values. Large
depicted using longer boxes.
Cells Small boxes that store individual pieces of data or calculations
Charts - Depictions of larger data sets which less-related categories
- A visual representation of usually larger sets of data where ca
may not be related to each other
, Intro To Spreadsheets - D100 WGU
Column and Row Labels Used to define how the data will be summarized and arranged
PivotTable, defines how source data will be categorized
Column Charts Charts that depict values with boxes that span the vertical axis
length of the boxes represents the individual values. Larger val
depicted using longer boxes.
Data A class of menu items used to aid in importing and working wit
of data.
Dynamic A formula that references and responds to changes in values in
Expression The calculation prescribed by the a formula in a spreadsheet
File A class of menu items used to manipulate workbooks.
Formula Auditing Analyzing a calculation in a spreadsheet to ensure that it is cor
Formulas The calculations performed in a spreadsheet.
Absolute Cell Reference A cell reference that remains constant when a formula is pasted
contains two "$".
Algorithm The part of a calculation that is applied to the measure. Examp
price.
Arguments The information inputted to create a function
Bar Charts Charts that depict values with boxes that span the horizontal a
The length of the boxes represents the individual values. Large
depicted using longer boxes.
Cells Small boxes that store individual pieces of data or calculations
Charts - Depictions of larger data sets which less-related categories
- A visual representation of usually larger sets of data where ca
may not be related to each other
, Intro To Spreadsheets - D100 WGU
Column and Row Labels Used to define how the data will be summarized and arranged
PivotTable, defines how source data will be categorized
Column Charts Charts that depict values with boxes that span the vertical axis
length of the boxes represents the individual values. Larger val
depicted using longer boxes.
Data A class of menu items used to aid in importing and working wit
of data.
Dynamic A formula that references and responds to changes in values in
Expression The calculation prescribed by the a formula in a spreadsheet
File A class of menu items used to manipulate workbooks.
Formula Auditing Analyzing a calculation in a spreadsheet to ensure that it is cor
Formulas The calculations performed in a spreadsheet.
