WGU C268 Spreadsheets (2026/2027) |
Updated Question Bank | 100% Verified
Answers | High-Yield Study Pack | A+
• Relative Cell Reference. CORRECT ANSWER: Cell reference that
automatically updates when a formula is pasted into a new cell
• Absolute Cell Refernce. CORRECT ANSWER: Cell reference that
remains constant when a formula is pasted into a new cell
• $. CORRECT ANSWER: Used to make a cell absolute. Goes in front of
the part you want to remain constant.
• SUM function. CORRECT ANSWER: =SUM() when you want to add a
group of numbers together
• COUNT function. CORRECT ANSWER: =COUNT() Counts the number of
cells in a range of cells that contain numbers
• COUNTA function. CORRECT ANSWER: =COUNTA() Counts the number
of cells in a range that are not blank
• AVERAGE function. CORRECT ANSWER: =AVERAGE() Calculates the
simple average of a set of numbers
, • MAX function. CORRECT ANSWER: =MAX() Returns the largest value
in a set of numbers
• MIN function. CORRECT ANSWER: =MIN() Returns the smallest value
in a set of numbers
• Circular Reference. CORRECT ANSWER: when one cell either directly
or indirectly references itself in completing a calculation
• Direct Circular Reference. CORRECT ANSWER: When a cell contains a
reference to itself
• Indirect Circular Reference. CORRECT ANSWER: When multiple cells
reference others cells but will eventually lead back to a main cell
• Population. CORRECT ANSWER: The complete set of entities for an
item of interest
• Sample. CORRECT ANSWER: Part of a population
• Standard deviation. CORRECT ANSWER: A measure of how diverse the
elements in our data sets are.
Updated Question Bank | 100% Verified
Answers | High-Yield Study Pack | A+
• Relative Cell Reference. CORRECT ANSWER: Cell reference that
automatically updates when a formula is pasted into a new cell
• Absolute Cell Refernce. CORRECT ANSWER: Cell reference that
remains constant when a formula is pasted into a new cell
• $. CORRECT ANSWER: Used to make a cell absolute. Goes in front of
the part you want to remain constant.
• SUM function. CORRECT ANSWER: =SUM() when you want to add a
group of numbers together
• COUNT function. CORRECT ANSWER: =COUNT() Counts the number of
cells in a range of cells that contain numbers
• COUNTA function. CORRECT ANSWER: =COUNTA() Counts the number
of cells in a range that are not blank
• AVERAGE function. CORRECT ANSWER: =AVERAGE() Calculates the
simple average of a set of numbers
, • MAX function. CORRECT ANSWER: =MAX() Returns the largest value
in a set of numbers
• MIN function. CORRECT ANSWER: =MIN() Returns the smallest value
in a set of numbers
• Circular Reference. CORRECT ANSWER: when one cell either directly
or indirectly references itself in completing a calculation
• Direct Circular Reference. CORRECT ANSWER: When a cell contains a
reference to itself
• Indirect Circular Reference. CORRECT ANSWER: When multiple cells
reference others cells but will eventually lead back to a main cell
• Population. CORRECT ANSWER: The complete set of entities for an
item of interest
• Sample. CORRECT ANSWER: Part of a population
• Standard deviation. CORRECT ANSWER: A measure of how diverse the
elements in our data sets are.
