WGU D388 - Fundamentals of
Spreadsheets and Data
Presentations EXAM Review
QUESTIONS WITH CORRECT
SOLUTIONS||100% GUARANTEED
PASS|| A+ GRADED||UPDATED
2025/2026 SYLLABUS||<<NEWEST
VERSION>>
Filtering - ANSWER ✓ A feature that allows users to limit the number of visible
rows in a worksheet
Formulas - ANSWER ✓ The calculations performed in a spreadsheet.
Expression - ANSWER ✓ The calculation prescribed by a formula in a
spreadsheet.
Static - ANSWER ✓ A formula that produces a consistent value
Dynamic - ANSWER ✓ A formula that references and responds to changes and
values in other cells
order of operations - ANSWER ✓ Sequential rules to follow in order to solve an
expression with multiple operations
Argument - ANSWER ✓ The information that a function requires to perform the
intended calculation
Count - ANSWER ✓ A function that counts the number of numbers in a data set
, COUNTA - ANSWER ✓ A function that counts the number of cells that have
values, example, non-blank cells
Average - ANSWER ✓ A function that calculates the simple average of a data set
Max - ANSWER ✓ The function that displays the largest cell value in a data set
Min - ANSWER ✓ A function that displays the smallest cell value in a data set
Relative reference - ANSWER ✓ A cell reference that automatically updates when
it is copied from one cell to another
Absolute reference - ANSWER ✓ A cell reference that stays fixed when a formula
is copied from one cell to another
Mixed reference - ANSWER ✓ When one part of the cell reference, either the
column or the row, is fixed (Absolute) and the other part is relative (changes based
on proximity to other cells)
A1 - ANSWER ✓ Both the column and row references are relative and will
change when the references copied and pasted to other cells
$A1 - ANSWER ✓ The column reference is absolute and will remain constant
when copied and pasted to other cells. The row reference is relative, and will
change when copied and pasted to cells and other rows of the worksheet.
A$1 - ANSWER ✓ The row reference is absolute and will remain constant when
copied and pasted to other cells. The column reference is relative, and will change
when copied and pasted to cells and other columns of the worksheet.
Parsing Data - ANSWER ✓ Structuring and converting data from one form to
another
Text to Columns - ANSWER ✓ A tool in the data tools group that separates
groups of text into individual columns
Delimiter - ANSWER ✓ A character or symbol that demonstrates where data
should be split
Spreadsheets and Data
Presentations EXAM Review
QUESTIONS WITH CORRECT
SOLUTIONS||100% GUARANTEED
PASS|| A+ GRADED||UPDATED
2025/2026 SYLLABUS||<<NEWEST
VERSION>>
Filtering - ANSWER ✓ A feature that allows users to limit the number of visible
rows in a worksheet
Formulas - ANSWER ✓ The calculations performed in a spreadsheet.
Expression - ANSWER ✓ The calculation prescribed by a formula in a
spreadsheet.
Static - ANSWER ✓ A formula that produces a consistent value
Dynamic - ANSWER ✓ A formula that references and responds to changes and
values in other cells
order of operations - ANSWER ✓ Sequential rules to follow in order to solve an
expression with multiple operations
Argument - ANSWER ✓ The information that a function requires to perform the
intended calculation
Count - ANSWER ✓ A function that counts the number of numbers in a data set
, COUNTA - ANSWER ✓ A function that counts the number of cells that have
values, example, non-blank cells
Average - ANSWER ✓ A function that calculates the simple average of a data set
Max - ANSWER ✓ The function that displays the largest cell value in a data set
Min - ANSWER ✓ A function that displays the smallest cell value in a data set
Relative reference - ANSWER ✓ A cell reference that automatically updates when
it is copied from one cell to another
Absolute reference - ANSWER ✓ A cell reference that stays fixed when a formula
is copied from one cell to another
Mixed reference - ANSWER ✓ When one part of the cell reference, either the
column or the row, is fixed (Absolute) and the other part is relative (changes based
on proximity to other cells)
A1 - ANSWER ✓ Both the column and row references are relative and will
change when the references copied and pasted to other cells
$A1 - ANSWER ✓ The column reference is absolute and will remain constant
when copied and pasted to other cells. The row reference is relative, and will
change when copied and pasted to cells and other rows of the worksheet.
A$1 - ANSWER ✓ The row reference is absolute and will remain constant when
copied and pasted to other cells. The column reference is relative, and will change
when copied and pasted to cells and other columns of the worksheet.
Parsing Data - ANSWER ✓ Structuring and converting data from one form to
another
Text to Columns - ANSWER ✓ A tool in the data tools group that separates
groups of text into individual columns
Delimiter - ANSWER ✓ A character or symbol that demonstrates where data
should be split
