BUS 1350 (SOFTWARE) EXAM
QUESTIONS & ACCURATE CORRECT
ANSWERS
compares values from different categories. Values are indicated by the height of the
columns or the length of a bar - Correct Answer ✔✔ column or bar
display data that is organized into a hierarchy of categories where the size of the groups
is based on a number - Correct Answer ✔✔ hierarchy
displays financial cash flow values or stock market data - Correct Answer ✔✔ waterfall
or stock
compares values from different categories. Values are indicated by the height of the
lines. Often used to show trends and changes over time. - Correct Answer ✔✔ line or
area
displays a chart summarizing the distribution of values from a sample population -
Correct Answer ✔✔ statistic
Compares relative values of different categories to the whole. Values are indicated by
the areas of the pie slices - Correct Answer ✔✔ pie
Shows the patterns or relationship between two or more sets of values. Often used in
scientific studies and statistical analyses - Correct Answer ✔✔ X Y (scatter) or bubble
compares three sets of values in a three-dimensional chart - Correct Answer ✔✔
surface or radar
combines two or more chart types to make the data easy to visualize, especially when
the data is widely varied - Correct Answer ✔✔ combo
compares data values across geographical regions - Correct Answer ✔✔ map
creates a chart summarizing data from a PivotTable - Correct Answer ✔✔ PivotChart
chart that displays the data series in separate columns side by side so that you can
compare the relative heights of the columns - Correct Answer ✔✔ clustered column
chart that places the data series values within combined columns showing how much is
contributed by each series - Correct Answer ✔✔ stacked column chart
, when are line charts used? - Correct Answer ✔✔ when the data consists of values
drawn from categories that follow a sequential order at evenly spaced intervals
what does a combination chart do? - Correct Answer ✔✔ it combines two chart types
within a single chart
what does a scatter chart do? - Correct Answer ✔✔ it plots two data series of numeric
values against each other
when are scatter charts used? - Correct Answer ✔✔ they are widely used on science
and engineering applications when investigators want to discover how two numeric
variables are related
a label that appears as a text bubble attached to a data marker - Correct Answer ✔✔
data callout
similar to pie charts; they show the relative contribution of groups to a whole
unlike pie charts; they also show the organizational structure of the data with
subcategories displayed within main categories - Correct Answer ✔✔ hierarchal charts
a special type of chart that combines a column chart and a line chart to indicate which
factors are the largest contributors to the whole - Correct Answer ✔✔ Pareto Chart
a column chart displaying the distribution of values from a single data series - Correct
Answer ✔✔ histogram chart
chart that tracks the addition and subtraction of values within a sum - Correct Answer
✔✔ waterfall chart
a chart that is displayed entirely within a worksheet cell - Correct Answer ✔✔ sparkline
what is the goal of a sparkline? - Correct Answer ✔✔ to convey the maximum amount
of information within a very small space
when are sparklines useful? - Correct Answer ✔✔ when you don't want charts to
overwhelm the rest of your worksheet or take up valuable page space
what is a line sparkline used for? - Correct Answer ✔✔ highlighting trends
what is a column sparkline used for? - Correct Answer ✔✔ column charts
what is a win/loss sparkline used for? - Correct Answer ✔✔ highlighting positive and
negative values
QUESTIONS & ACCURATE CORRECT
ANSWERS
compares values from different categories. Values are indicated by the height of the
columns or the length of a bar - Correct Answer ✔✔ column or bar
display data that is organized into a hierarchy of categories where the size of the groups
is based on a number - Correct Answer ✔✔ hierarchy
displays financial cash flow values or stock market data - Correct Answer ✔✔ waterfall
or stock
compares values from different categories. Values are indicated by the height of the
lines. Often used to show trends and changes over time. - Correct Answer ✔✔ line or
area
displays a chart summarizing the distribution of values from a sample population -
Correct Answer ✔✔ statistic
Compares relative values of different categories to the whole. Values are indicated by
the areas of the pie slices - Correct Answer ✔✔ pie
Shows the patterns or relationship between two or more sets of values. Often used in
scientific studies and statistical analyses - Correct Answer ✔✔ X Y (scatter) or bubble
compares three sets of values in a three-dimensional chart - Correct Answer ✔✔
surface or radar
combines two or more chart types to make the data easy to visualize, especially when
the data is widely varied - Correct Answer ✔✔ combo
compares data values across geographical regions - Correct Answer ✔✔ map
creates a chart summarizing data from a PivotTable - Correct Answer ✔✔ PivotChart
chart that displays the data series in separate columns side by side so that you can
compare the relative heights of the columns - Correct Answer ✔✔ clustered column
chart that places the data series values within combined columns showing how much is
contributed by each series - Correct Answer ✔✔ stacked column chart
, when are line charts used? - Correct Answer ✔✔ when the data consists of values
drawn from categories that follow a sequential order at evenly spaced intervals
what does a combination chart do? - Correct Answer ✔✔ it combines two chart types
within a single chart
what does a scatter chart do? - Correct Answer ✔✔ it plots two data series of numeric
values against each other
when are scatter charts used? - Correct Answer ✔✔ they are widely used on science
and engineering applications when investigators want to discover how two numeric
variables are related
a label that appears as a text bubble attached to a data marker - Correct Answer ✔✔
data callout
similar to pie charts; they show the relative contribution of groups to a whole
unlike pie charts; they also show the organizational structure of the data with
subcategories displayed within main categories - Correct Answer ✔✔ hierarchal charts
a special type of chart that combines a column chart and a line chart to indicate which
factors are the largest contributors to the whole - Correct Answer ✔✔ Pareto Chart
a column chart displaying the distribution of values from a single data series - Correct
Answer ✔✔ histogram chart
chart that tracks the addition and subtraction of values within a sum - Correct Answer
✔✔ waterfall chart
a chart that is displayed entirely within a worksheet cell - Correct Answer ✔✔ sparkline
what is the goal of a sparkline? - Correct Answer ✔✔ to convey the maximum amount
of information within a very small space
when are sparklines useful? - Correct Answer ✔✔ when you don't want charts to
overwhelm the rest of your worksheet or take up valuable page space
what is a line sparkline used for? - Correct Answer ✔✔ highlighting trends
what is a column sparkline used for? - Correct Answer ✔✔ column charts
what is a win/loss sparkline used for? - Correct Answer ✔✔ highlighting positive and
negative values
