D388 - Fundamentals of Spreadsheets
and Data Presentations Questions with
Accurate Answers
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
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
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
Cell correct answer Small box that stores an individual piece of data or
a calculation in a worksheet
Column correct answer A stack of cells arranged vertically from the top
to the bottom of a worksheet - labeled with a letter.
, 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
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
Data correct answer Group of menu items used to aid in importing and
working with data
Date correct answer Used to display the number in a cell as a date
Draw correct answer Group of menu items used to insert freehand
sketches into worksheets
Dynamic correct answer A formula that references and responds to
changes and values in other cells
Expression correct answer The calculation prescribed by a formula in a
spreadsheet.
and Data Presentations Questions with
Accurate Answers
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
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
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
Cell correct answer Small box that stores an individual piece of data or
a calculation in a worksheet
Column correct answer A stack of cells arranged vertically from the top
to the bottom of a worksheet - labeled with a letter.
, 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
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
Data correct answer Group of menu items used to aid in importing and
working with data
Date correct answer Used to display the number in a cell as a date
Draw correct answer Group of menu items used to insert freehand
sketches into worksheets
Dynamic correct answer A formula that references and responds to
changes and values in other cells
Expression correct answer The calculation prescribed by a formula in a
spreadsheet.
