WGU D388 FUNDAMENTALS OF
SPREADSHEETS AND DATA
PRESENTATIONS EXAM PREP TEST BANK
VERIFIED QUESTIONS AND CORRECT
ANSWERS
●● Accounting
Answer: An option in the Number Format drop-down menu that defines
a number as money with the appropriate monetary symbol and two
decimal places. The user does not have as many ways to format negative
numbers as the Currency option.
●● Algorithm
Answer: The part of a calculation that is applied to the measure.
Example: average revenue.
●● Alignment
Answer: The way values in a cell are positioned.
●● Area Chart
Answer: A type of chart that combines a line chart and a bar chart to
show changes in quantities over time. Area charts display the height of
each category in relation to the height of the other categories.
,●● Argument
Answer: The information that a function requires to perform the
intended calculation.
●● AVERAGE
Answer: A function that calculates the simple average of a dataset.
●● Average
Answer: A function or PivotTable Value Field setting that displays the
average of the values.
●● Bar Chart
Answer: A type of chart that presents data with horizontal bars.
●● Bold
Answer: A feature in the Font group that thickens and darkens the font
face, making it stand out.
●● Borders
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
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.
●● Category
Answer: An element within a dataset that is used to classify non-
numerical values.
●● Cell
Answer: A small box that stores an individual piece of data or a
calculation in a worksheet.
●● Centering
Answer: Aligning values in the center of a cell.
●● Chart
Answer: A visual depiction of a dataset.
●● Chart Data Range
Answer: An element in the Chart dialog window that defines the range
of values of a worksheet that contain data for a chart.
SPREADSHEETS AND DATA
PRESENTATIONS EXAM PREP TEST BANK
VERIFIED QUESTIONS AND CORRECT
ANSWERS
●● Accounting
Answer: An option in the Number Format drop-down menu that defines
a number as money with the appropriate monetary symbol and two
decimal places. The user does not have as many ways to format negative
numbers as the Currency option.
●● Algorithm
Answer: The part of a calculation that is applied to the measure.
Example: average revenue.
●● Alignment
Answer: The way values in a cell are positioned.
●● Area Chart
Answer: A type of chart that combines a line chart and a bar chart to
show changes in quantities over time. Area charts display the height of
each category in relation to the height of the other categories.
,●● Argument
Answer: The information that a function requires to perform the
intended calculation.
●● AVERAGE
Answer: A function that calculates the simple average of a dataset.
●● Average
Answer: A function or PivotTable Value Field setting that displays the
average of the values.
●● Bar Chart
Answer: A type of chart that presents data with horizontal bars.
●● Bold
Answer: A feature in the Font group that thickens and darkens the font
face, making it stand out.
●● Borders
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
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.
●● Category
Answer: An element within a dataset that is used to classify non-
numerical values.
●● Cell
Answer: A small box that stores an individual piece of data or a
calculation in a worksheet.
●● Centering
Answer: Aligning values in the center of a cell.
●● Chart
Answer: A visual depiction of a dataset.
●● Chart Data Range
Answer: An element in the Chart dialog window that defines the range
of values of a worksheet that contain data for a chart.
