WGU C268 Spreadsheets New Update With 100%
Verified Solutions!!
Relative Cell Reference - cell reference that automatically changes when a formula is
copied into a new cell
Absolute Cell Refernce - cell reference that does not change when a formula is copied
into a new cell
$ - Used to make a cell absolute. Goes in front of the part you want to remain constant.
SUM function - Answer =SUM() when you want to add a group of numbers together
COUNT function - Answer =COUNT() Counts the number of cells in a range of cells that
contain numbers
COUNTA function - Answer =COUNTA() Counts the number of cells in a range that are
not blank
AVERAGE function - Answer =AVERAGE() Calculates the simple average of a set of
numbers
MAX function - Answer =MAX() Returns the largest number in a number set
MIN function - Answer =MIN() Returns the smallest number in a number set
Circular Reference - Answer when one cell either directly or indirectly references itself
in completing a calculation
Verified Solutions!!
Relative Cell Reference - cell reference that automatically changes when a formula is
copied into a new cell
Absolute Cell Refernce - cell reference that does not change when a formula is copied
into a new cell
$ - Used to make a cell absolute. Goes in front of the part you want to remain constant.
SUM function - Answer =SUM() when you want to add a group of numbers together
COUNT function - Answer =COUNT() Counts the number of cells in a range of cells that
contain numbers
COUNTA function - Answer =COUNTA() Counts the number of cells in a range that are
not blank
AVERAGE function - Answer =AVERAGE() Calculates the simple average of a set of
numbers
MAX function - Answer =MAX() Returns the largest number in a number set
MIN function - Answer =MIN() Returns the smallest number in a number set
Circular Reference - Answer when one cell either directly or indirectly references itself
in completing a calculation
