Chapter 3 Review Questions

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

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

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.

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. increases the non-data-ink ratio.

C. is necessary to convey the meaning of the data to the audience.

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

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.

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

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.

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.

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.

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. vertical bars to display the magnitude of the categorical variable

a. horizontal bars to display the magnitude of the quantitative variable.

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

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

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.

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 particular type of problem by location. c. identify which city contains the most customers. d. identify the percent of customers who do not have one of the listed problems.

b. identify the frequency of a particular type of problem by location.

The best way to differentiate chart elements is using a. colors. b. labels. c. bubbles. d. chart titles.

b. labels.

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.

In many cases, white space in a chart can improve a. complexity. b. readability. c. functionality. d. stability.

b. readability.

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.

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 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 perceive small differences in areas. d. they are only used when many quantitative variables need to be displayed.

c. it can be difficult to perceive small differences in areas

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. d. business performance indicators.

c. key performance indicators.

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.

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 differentiate the columns and rows.

c. the values being displayed have different units or very different magnitudes.

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 _____________ is a line that provides an approximation of the relationship between the variables. a. line chart b. sparkline c. trendline d. gridline

c. trendline

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 data arrayed in rows.

d. PivotTables can be built using data arrayed in rows.

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.

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.

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

The following image is a (See PDF for chart image) a. sparkline. b. trendline. c. gridline. d. line chart.

d. line chart.

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 a graphical presentation of the relationship between two quantitative variables. a. histogram b. bar chart c. pie chart d. scatter chart

d. scatter chart

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