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