D388 Excel Questions With
Accurate Answers
A cell reference that stays fixed when a formula is copied from one cell
to another is an absolute reference. correct answer A cell reference
that stays fixed when a formula is copied from one cell to another is an
___________
Accounting (data type) correct answer Used to define a number as
money; the accounting data type has fewer options than the currency
type. The accounting data type displays data with a currency symbol
and two decimal places.
argument correct answer The information that a function requires to
perform the intended calculation.
is the information that a function requires to perform the intended
calculation
COUNT correct answer The ________function is used to calculate the
number of cells in a specified set of cells that contain a number. The
______ function does not include blank cells or cells with non-numeric
values in calculating the number of items in a range of cells.
COUNTA correct answer By contrast, the ______function differentiates
between blank cells and those with any type of data. The
, ________function returns the number of cells in a set of cells that are
not blank.
Currency (data type) correct answer Used to define a number as
money; currency values will be displayed with a monetary symbol (such
as a dollar sign) appropriate for the currency described and two
decimal places. Currency data can be configured to highlight negative
numbers in specific ways (such as using a red font).
data series correct answer a collection of data rendered on a chart
Date (data type) correct answer Used to display the number in a cell as
a date; the date data type has several display options, such as
"12/18/1973" or "Tuesday, December 18, 1973."
default data type in excel correct answer general
delimiter correct answer A character that demonstrates where data
should be split is called a
Dynamic formulas correct answer respond to changes in other cells in
the worksheet
expression correct answer calculation prescribed by the formula
Accurate Answers
A cell reference that stays fixed when a formula is copied from one cell
to another is an absolute reference. correct answer A cell reference
that stays fixed when a formula is copied from one cell to another is an
___________
Accounting (data type) correct answer Used to define a number as
money; the accounting data type has fewer options than the currency
type. The accounting data type displays data with a currency symbol
and two decimal places.
argument correct answer The information that a function requires to
perform the intended calculation.
is the information that a function requires to perform the intended
calculation
COUNT correct answer The ________function is used to calculate the
number of cells in a specified set of cells that contain a number. The
______ function does not include blank cells or cells with non-numeric
values in calculating the number of items in a range of cells.
COUNTA correct answer By contrast, the ______function differentiates
between blank cells and those with any type of data. The
, ________function returns the number of cells in a set of cells that are
not blank.
Currency (data type) correct answer Used to define a number as
money; currency values will be displayed with a monetary symbol (such
as a dollar sign) appropriate for the currency described and two
decimal places. Currency data can be configured to highlight negative
numbers in specific ways (such as using a red font).
data series correct answer a collection of data rendered on a chart
Date (data type) correct answer Used to display the number in a cell as
a date; the date data type has several display options, such as
"12/18/1973" or "Tuesday, December 18, 1973."
default data type in excel correct answer general
delimiter correct answer A character that demonstrates where data
should be split is called a
Dynamic formulas correct answer respond to changes in other cells in
the worksheet
expression correct answer calculation prescribed by the formula
