C268 Spreadsheets Test 1 Questions with
Correct Answers
Relative Cell Reference
Cell reference that automatically updates when a formula is pasted into a new cell
Absolute Cell Refernce
Cell reference that remains constant when a formula is pasted into a new cell
$
Used to make a cell absolute. Goes in front of the part you want to remain constant.
SUM function
=SUM() when you want to add a group of numbers together
COUNT function
=COUNT() Counts the number of cells in a range of cells that contain numbers
COUNTA function
=COUNTA() Counts the number of cells in a range that are not blank
AVERAGE function
=AVERAGE() Calculates the simple average of a set of numbers
MAX function
=MAX() Returns the largest value in a set of numbers
MIN function
=MIN() Returns the smallest value in a set of numbers
, Circular Reference
when one cell either directly or indirectly references itself in completing a calculation
Direct Circular Reference
When a cell contains a reference to itself
Indirect Circular Reference
When multiple cells reference others cells but will eventually lead back to a main cell
Population
The complete set of entities for an item of interest
Sample
Part of a population
Standard deviation
A measure of how diverse the elements in our data sets are.
Standard deviation of a sample
=STDEV.S(number 1,[number 2],...)
Standard deviation of a population
==STDEV.P(number 1,[number 2],...)
Confidence Intervals
The range of values that we believe that the "true" value for the population falls within
CONFIDENECE.NORM Function
=CONFIDENCE.NORM(alpha,standard_dev,size)
Correct Answers
Relative Cell Reference
Cell reference that automatically updates when a formula is pasted into a new cell
Absolute Cell Refernce
Cell reference that remains constant when a formula is pasted into a new cell
$
Used to make a cell absolute. Goes in front of the part you want to remain constant.
SUM function
=SUM() when you want to add a group of numbers together
COUNT function
=COUNT() Counts the number of cells in a range of cells that contain numbers
COUNTA function
=COUNTA() Counts the number of cells in a range that are not blank
AVERAGE function
=AVERAGE() Calculates the simple average of a set of numbers
MAX function
=MAX() Returns the largest value in a set of numbers
MIN function
=MIN() Returns the smallest value in a set of numbers
, Circular Reference
when one cell either directly or indirectly references itself in completing a calculation
Direct Circular Reference
When a cell contains a reference to itself
Indirect Circular Reference
When multiple cells reference others cells but will eventually lead back to a main cell
Population
The complete set of entities for an item of interest
Sample
Part of a population
Standard deviation
A measure of how diverse the elements in our data sets are.
Standard deviation of a sample
=STDEV.S(number 1,[number 2],...)
Standard deviation of a population
==STDEV.P(number 1,[number 2],...)
Confidence Intervals
The range of values that we believe that the "true" value for the population falls within
CONFIDENECE.NORM Function
=CONFIDENCE.NORM(alpha,standard_dev,size)
