WGU C268 Spreadsheets Question and Answer [2026] | UPDATED ACTUAL Exam | A+ Verified

WGU C268 Spreadsheets Question and Answer
[2026] | UPDATED ACTUAL Exam | A+ Verified
• 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],...)