WGU C268 SPREADSHEETS FINAL OA
CERTIFICATION REVIEW SOLVED
QUESTIONS
◉ Absolute Cell Refernce
Answer: Cell reference that remains constant when a formula is
pasted into a new cell
◉$
Answer: 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 value in a set of numbers
◉ MIN function
Answer: =MIN() Returns the smallest value in a set of numbers
◉ Circular Reference
Answer: when one cell either directly or indirectly references
itself in completing a calculation
◉ Direct Circular Reference
Answer: When a cell contains a reference to itself
◉ Indirect Circular Reference
Answer: When multiple cells reference others cells but will
eventually lead back to a main cell
◉ Population
Answer: The complete set of entities for an item of interest
CERTIFICATION REVIEW SOLVED
QUESTIONS
◉ Absolute Cell Refernce
Answer: Cell reference that remains constant when a formula is
pasted into a new cell
◉$
Answer: 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 value in a set of numbers
◉ MIN function
Answer: =MIN() Returns the smallest value in a set of numbers
◉ Circular Reference
Answer: when one cell either directly or indirectly references
itself in completing a calculation
◉ Direct Circular Reference
Answer: When a cell contains a reference to itself
◉ Indirect Circular Reference
Answer: When multiple cells reference others cells but will
eventually lead back to a main cell
◉ Population
Answer: The complete set of entities for an item of interest
