Data-ink is the ink used in a table or chart that
A. does not help in conveying the data to the audience.
B. helps in presenting data when the audience need not know exact values.
C. is necessary to convey the meaning of the data to the audience.
D. incre
C. is necessary to convey the meaning of the data to the audience.
Deleting the grid lines in a table and the horizontal lines in a chart
A. increases the data-ink ratio.
B. decreases the data-ink ratio.
C. increases the non-data-ink ratio.
D. does not affect the data-ink ratio.
A. increases the data-ink ratio.
In many cases, white space in a chart can improve
a. complexity.
b. readability.
c. functionality.
d. stability.
b. readability.
Tables should be used instead of charts when
a. the reader needs relative comparisons of data.
b. there are more than two columns of data.
c. the values being displayed have different units or very different magnitudes.
d. the reader need not differentiat
c. the values being displayed have different units or very different magnitudes.
Which one of the following statements is not true concerning PivotTables in Excel?
a. PivotTables are also known as crosstabulation tables.
b. PivotTables summarize data for two variables.
c. PivotTables are interactive.
d. PivotTables can be built using
d. PivotTables can be built using data arrayed in rows.
Fields may be chosen to represent all of the following except ____________ in the body of a PivotTable.
a. rows
b. columns
c. values
d. filters
d. filters
A _____________ is a graphical presentation of the relationship between two quantitative variables.
a. histogram
b. bar chart
c. pie chart
d. scatter chart
d. scatter chart
A _____________ is a line that provides an approximation of the relationship between the variables.
a. line chart
b. sparkline
c. trendline
d. gridline
c. trendline
The following image is a (See PDF for chart image)
a. sparkline.
b. trendline.
c. gridline.
d. line chart.
d. line chart.
DJ needs to display data over time. Which of the following charts should he use?
a. Scatter chart
b. Pie chart
c. Bar chart
d. Line chart
d. Line chart
A line chart that has no axes but is used to provide information on overall trends for time series data is called a
a. time series plot.
b. sparkline.
c. trendline.
d. bubble chart.
b. sparkline.
The charts that are helpful in making comparisons between categorical variables are
a. bar charts and scatter charts.
b. scatter charts and line charts.
c. bar charts and column charts.
d. column charts and line charts.
c. bar charts and column charts.
Bar charts use
a. horizontal bars to display the magnitude of the quantitative variable.
b. vertical bars to display the magnitude of the quantitative variable.
c. horizontal and vertical bars to display the magnitude of the quantitative variable.
d. vert
a. horizontal bars to display the magnitude of the quantitative variable.
Making visual comparisons between categorical variables may be difficult in a
a. scatter chart.
b. pie chart.
c. line chart.
d. column chart.
b. pie chart.
A chart that is recommended as an alternative to a pie chart is a
a. bar chart.
b. line chart.
c. stacked column chart.
d. box plot.
a. bar chart.
In order to visualize three variables in a two-dimensional graph, we use a
a. 2-D chart.
b. 3-D chart.
c. bubble chart.
d. column chart.
c. bubble chart.
A two-dimensional graph representing the data using different shades of color to indicate magnitude is called a
a. heat map.
b. bubble chart.
c. column chart.
d. pie chart.
a. heat map.
To avoid problems in interpreting the differences in color in a heat map, ____________ can be added.
a. a bubble chart
b. a pie chart
c. a scatter chart
d. sparklines
d. sparklines
A disadvantage of stacked-column charts and stacked-bar charts is that
a. they do not include all the values of the variable.
b. they cannot be used to compare relative values of quantitative variables for the same category.
c. it can be difficult to perc
c. it can be difficult to perceive small differences in areas
An alternative for a stacked column chart when comparing more than a couple of quantitative variables in each category is a
a. stacked bar chart.
b. clustered column chart.
c. pie chart.
d. clustered bar chart.
b. clustered column chart.
A useful chart for displaying multiple variables is the
a. stacked column and bar chart.
b. scatter chart.
c. scatter chart matrix.
d. two-dimensional graph.
c. scatter chart matrix.
To summarize and analyze data with both a crosstabulation and charting, Excel typically pairs
a. PivotCharts with PivotTables.
b. stacked column charts with PivotTables.
c. heat maps with trendlines.
d. bubble charts with trendlines.
a. PivotCharts with PivotTables.
A PivotChart, in few instances, is the same as a
a. clustered-column chart.
b. bubble chart.
c. stacked-column chart.
d. bar chart.
a. clustered-column chart.
The best way to differentiate chart elements is using
a. colors.
b. labels.
c. bubbles.
d. chart titles.
b. labels.
A __________ is used for examining data with more than two variables, and it includes a different vertical axis for each variable.
a. scatter plot
b. PivotChart
c. column chart
d. parallel-coordinates plot
d. parallel-coordinates plot
A __________ is useful for visualizing hierarchical data along multiple dimensions.
a. heat map
b. hierarchical map
c. treemap
d. map of multiple hierarchy
c. treemap
A data visualization tool that updates in real time and gives multiple outputs is called
a. a data table.
b. a metrics table.
c. the GIS.
d. a data dashboard.
d. a data dashboard.
In a business, the values indicating the business's current operating characteristics, such as its financial position, the inventory on hand, and customer service metrics, are typically known as
a. company performance indicators.
b. performance indicators
c. key performance indicators.
Consider the clustered bar chart of the dashboard developed to monitor the performance of a call center: (See PDF for image)
This chart allows the IT manager to
a. identify how often a problem is related to hardware.
b. identify the frequency of a particu
b. identify the frequency of a particular type of problem by location.
This Excel bar chart displays the demographics of a Business Analysis class. Approximately how many students are in the class? (See PDF for image)
a. 175
b. 150
c. 105
d. 130
d. 130
This bar chart displays the demographics of a Business Analysis class. How many male students are in the class? (See PDF for image)
a. 30
b. 50
c. 80
d. 130
b. 50
A graphical presentation that uses vertical bars to display the magnitude of quantitative data is known as a
a. scatter chart.
b. bubble chart.
c. clustered column chart.
d. column chart.
d. column chart.
Never use a __________ chart when a __________ chart will suffice.
a. 3-D; 2-D
b. 2-D; 3-D
c. color; black and white
d. bar; pie
a. 3-D; 2-D
Which of the following graphs cannot be used to display categorical data?
a. Stacked-column chart
b. Scatter chart
c. Pie chart
d. Clustered-column chart
b. Scatter chart
Susan would like to create a graph to display the number of males and females in her class who got an A, B, C, D, and F on the last test. Which of the following graphs could she use?
a. Stacked-column chart
b. Scatter chart
c. Pie chart
d. Heat map
a. Stacked-column chart