Intro To Spreadsheets - D100 WGU Already
Graded A+
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
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.
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
Formulas - Answer The calculations performed in a spreadsheet.
Function Wizard - 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 - Answer - A two-dimensional representation of numerical data using a line
or a curve
- Used to display a numerical representation of data
Graded A+
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
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.
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
Formulas - Answer The calculations performed in a spreadsheet.
Function Wizard - 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 - Answer - A two-dimensional representation of numerical data using a line
or a curve
- Used to display a numerical representation of data
