WGU d366 study questions
section 1 with accurate
answers
$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.
A$1 correct 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.
A1 correct answer Both the column and row references are relative and
will change when the references copied and pasted to other cells
Absolute reference correct answer A cell reference that stays fixed
when a formula is copied from one cell to another
Accounting correct answer Used to define a number as money; the
accounting data type has fewer options in the currency type
Algorithm correct answer The part of a calculation that is applied to the
measure. Example average revenue.
, Alignment correct answer The way values in a cell are positioned
Area chart correct answer
Argument correct answer The information that a function requires to
perform the intended calculation
Average correct answer A function that calculates the simple average of
a data set
Bold correct answer A feature in the font group, that thickens and
darkens the font face, making it stand out
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
Calculated column correct answer A column in an excel table in which a
calculation is created in any of the cells and then automatically applied
to all the cells in that column
Cell correct answer Small box that stores an individual piece of data or
a calculation in a worksheet
section 1 with accurate
answers
$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.
A$1 correct 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.
A1 correct answer Both the column and row references are relative and
will change when the references copied and pasted to other cells
Absolute reference correct answer A cell reference that stays fixed
when a formula is copied from one cell to another
Accounting correct answer Used to define a number as money; the
accounting data type has fewer options in the currency type
Algorithm correct answer The part of a calculation that is applied to the
measure. Example average revenue.
, Alignment correct answer The way values in a cell are positioned
Area chart correct answer
Argument correct answer The information that a function requires to
perform the intended calculation
Average correct answer A function that calculates the simple average of
a data set
Bold correct answer A feature in the font group, that thickens and
darkens the font face, making it stand out
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
Calculated column correct answer A column in an excel table in which a
calculation is created in any of the cells and then automatically applied
to all the cells in that column
Cell correct answer Small box that stores an individual piece of data or
a calculation in a worksheet
