WGU D388 FUNDAMENTALS OF SPREAD SHEET EXAM
QUESTIONS AND CORRECT ANSWERS WITH
RATIONALE ALREADY GRADED A
GUARANTEED FOR PASS LATEST UPDATE 2025.
Number - CORRECT ANSWER An option in the number format, drop-down menu that defines
any type of number and can be configured to display the number in standardized ways.
Currency - CORRECT ANSWER Used to define a number as money; currency values will be
displayed with the monetary symbol appropriate for the currency described in two decimal
places
Accounting - CORRECT ANSWER Used to define a number as money; the accounting data
type has fewer options in the currency type
Insert function icon - CORRECT ANSWER The "fx" symbol located to the left of the formula
bar. Users can click on the symbol and select built-in calculations that can be applied to data.
Formatting - CORRECT ANSWER Changing the appearance of the data and cells in a
worksheet
Range - CORRECT ANSWER A consecutive block of cells, arranged in a row, a column, or a
combination of both. For example, A1:B3 is the range of cells that includes A1, A2, A3, B1, B2,
and B3.
Font face - CORRECT ANSWER The style or design of letters, numbers, or other symbols
Font size - CORRECT ANSWER The size of letters, numbers, or other symbols
Header - CORRECT ANSWER A label, generally, at the top of a column of data, used to
describe the rest of the data
,WGU D388 FUNDAMENTALS OF SPREAD SHEET EXAM
QUESTIONS AND CORRECT ANSWERS WITH
RATIONALE ALREADY GRADED A
GUARANTEED FOR PASS LATEST UPDATE 2025.
Date - CORRECT ANSWER Used to display the number in a cell as a date
Time - CORRECT ANSWER Used to display the contents of a cell as a specific time of day
Percentage - CORRECT ANSWER Used to display the contents of a cell as a percent
Wrap text - CORRECT ANSWER An icon in the alignment group of the home menu that, when
selected, spans, or wraps the content of a cell across multiple lines within the same cell, so that
all the content is showing
Border - CORRECT ANSWER An icon in the font group of the home menu that, when selected,
gives multiple options to add lines, or borders, to one or more sides of a cell
Sorting - CORRECT ANSWER A feature that allows you users to re-organize data based on the
values in one or more columns.
Filtering - CORRECT ANSWER A feature that allows users to limit the number of visible rows
in a worksheet
Formulas - CORRECT ANSWER The calculations performed in a spreadsheet.
Expression - CORRECT ANSWER The calculation prescribed by a formula in a spreadsheet.
Static - CORRECT ANSWER A formula that produces a consistent value
Dynamic - CORRECT ANSWER A formula that references and responds to changes and values
in other cells
order of operations - CORRECT ANSWER Sequential rules to follow in order to solve an
expression with multiple operations
, WGU D388 FUNDAMENTALS OF SPREAD SHEET EXAM
QUESTIONS AND CORRECT ANSWERS WITH
RATIONALE ALREADY GRADED A
GUARANTEED FOR PASS LATEST UPDATE 2025.
Argument - CORRECT ANSWER The information that a function requires to perform the
intended calculation
Count - CORRECT ANSWER A function that counts the number of numbers in a data set
COUNTA - CORRECT ANSWER A function that counts the number of cells that have values,
example, non-blank cells
Average - CORRECT ANSWER A function that calculates the simple average of a data set
Max - CORRECT ANSWER The function that displays the largest cell value in a data set
Min - CORRECT ANSWER A function that displays the smallest cell value in a data set
Relative reference - CORRECT ANSWER A cell reference that automatically updates when it is
copied from one cell to another
Absolute reference - CORRECT ANSWER A cell reference that stays fixed when a formula is
copied from one cell to another
Mixed reference - CORRECT 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 - CORRECT ANSWER Both the column and row references are relative and will change
when the references copied and pasted to other cells
$A1 - CORRECT 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.
QUESTIONS AND CORRECT ANSWERS WITH
RATIONALE ALREADY GRADED A
GUARANTEED FOR PASS LATEST UPDATE 2025.
Number - CORRECT ANSWER An option in the number format, drop-down menu that defines
any type of number and can be configured to display the number in standardized ways.
Currency - CORRECT ANSWER Used to define a number as money; currency values will be
displayed with the monetary symbol appropriate for the currency described in two decimal
places
Accounting - CORRECT ANSWER Used to define a number as money; the accounting data
type has fewer options in the currency type
Insert function icon - CORRECT ANSWER The "fx" symbol located to the left of the formula
bar. Users can click on the symbol and select built-in calculations that can be applied to data.
Formatting - CORRECT ANSWER Changing the appearance of the data and cells in a
worksheet
Range - CORRECT ANSWER A consecutive block of cells, arranged in a row, a column, or a
combination of both. For example, A1:B3 is the range of cells that includes A1, A2, A3, B1, B2,
and B3.
Font face - CORRECT ANSWER The style or design of letters, numbers, or other symbols
Font size - CORRECT ANSWER The size of letters, numbers, or other symbols
Header - CORRECT ANSWER A label, generally, at the top of a column of data, used to
describe the rest of the data
,WGU D388 FUNDAMENTALS OF SPREAD SHEET EXAM
QUESTIONS AND CORRECT ANSWERS WITH
RATIONALE ALREADY GRADED A
GUARANTEED FOR PASS LATEST UPDATE 2025.
Date - CORRECT ANSWER Used to display the number in a cell as a date
Time - CORRECT ANSWER Used to display the contents of a cell as a specific time of day
Percentage - CORRECT ANSWER Used to display the contents of a cell as a percent
Wrap text - CORRECT ANSWER An icon in the alignment group of the home menu that, when
selected, spans, or wraps the content of a cell across multiple lines within the same cell, so that
all the content is showing
Border - CORRECT ANSWER An icon in the font group of the home menu that, when selected,
gives multiple options to add lines, or borders, to one or more sides of a cell
Sorting - CORRECT ANSWER A feature that allows you users to re-organize data based on the
values in one or more columns.
Filtering - CORRECT ANSWER A feature that allows users to limit the number of visible rows
in a worksheet
Formulas - CORRECT ANSWER The calculations performed in a spreadsheet.
Expression - CORRECT ANSWER The calculation prescribed by a formula in a spreadsheet.
Static - CORRECT ANSWER A formula that produces a consistent value
Dynamic - CORRECT ANSWER A formula that references and responds to changes and values
in other cells
order of operations - CORRECT ANSWER Sequential rules to follow in order to solve an
expression with multiple operations
, WGU D388 FUNDAMENTALS OF SPREAD SHEET EXAM
QUESTIONS AND CORRECT ANSWERS WITH
RATIONALE ALREADY GRADED A
GUARANTEED FOR PASS LATEST UPDATE 2025.
Argument - CORRECT ANSWER The information that a function requires to perform the
intended calculation
Count - CORRECT ANSWER A function that counts the number of numbers in a data set
COUNTA - CORRECT ANSWER A function that counts the number of cells that have values,
example, non-blank cells
Average - CORRECT ANSWER A function that calculates the simple average of a data set
Max - CORRECT ANSWER The function that displays the largest cell value in a data set
Min - CORRECT ANSWER A function that displays the smallest cell value in a data set
Relative reference - CORRECT ANSWER A cell reference that automatically updates when it is
copied from one cell to another
Absolute reference - CORRECT ANSWER A cell reference that stays fixed when a formula is
copied from one cell to another
Mixed reference - CORRECT 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 - CORRECT ANSWER Both the column and row references are relative and will change
when the references copied and pasted to other cells
$A1 - CORRECT 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.
