Chapter 3 Quiz
Never use a _____ chart when a _____ chart will suffice.
3-D; 2-D
Natalie needs to compare the number of employees by job title for the last five years. Which of the following charts should Natalie use?
Clustered-column (bar) chart
Fields may be chosen to represent all of the following except ______ in the body of a PivotTable.
Filters
The ratio of the amount of ink used in a table or chart that is necessary to convey information to the total amount of ink used in the table and chart is known as data-ink ratio. Using additional ink that is not necessary to convey information has what effect on the data-ink ratio?
It reduces the data-ink ratio
To summarize and analyze data with both a crosstabulation and charting, Excel typically pairs
PivotCharts with PivotTables
Which one of the following statements is not true concerning PivotTables in Excel?
PivotTables can be built using data arrayed in rows
In many cases, white space in a chart can improve
Readability
Which of the following graphs cannot be used to display categorical data?
Scatter chart
A line chart that has no axes but is used to provide information on overall trends for time series data is called a
Sparkline
A data visualization tool that updates in real time and gives multiple outputs is called
a data dashboard
A chart that is recommended as an alternative to pie chart is a
bar chart
the charts that are helpful in making comparisons between categorical variables are
bar charts and column charts
In order to visualize three variables in a two-dimensional graph, we use a
bubble chart
_______ are visual methods of displaying data
charts
An alternative for a stacked column chart when comparing more than a couple of quantitative variables in each category is a
clustered column chart
A disadvantage of stacked-column charts and stacked-bar charts is that
it can be difficult to perceive small differences in areas
the best way to differentiate chart elements is using
labels
A _____ is a graphical presentation of the relationship between two quantitative variables
scatter chart
Table should be used instead of charts when
the values being displayed have different units or very different magnitudes
A ______ is useful for visualizing hierarchical data along multiple dimensions
treemap
A ______ is a line that provides an approximation of the relationship between the variables.
trendline