Chapter 3

Which of the following graphs cannot be used to display categorical data? a. Scatter chart b. Stacked-column chart c. Clustered-column chart d. Pie chart

a. Scatter chart

A graphical presentation that uses vertical bars to display the magnitude of quantitative data is known as a _____. a. column chart b. clustered column chart c. bubble chart d. scatter chart

a. column 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. sparkline b. trendline c. bubble chart d. time series plot

a. sparkline

Data-ink is the ink used in a table or chart that _____. a.is necessary to convey the meaning of the data to the audience b. does not help in conveying the data to the audience c. increases the non-data-ink ratio d.helps in presenting data when the audience need not know exact values

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

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

b. key performance indicators

Natalie needs to compare the number of employees by job title for the last five years. Which of the following charts should Natalie use? a. Line chart b. Clustered-column (bar) chart c. Bubble chart d. Scatter chart

b. Clustered-column (bar) chart

Deleting the grid lines in a table and the horizontal lines in a chart ______. a. increases the non-data-ink ratio b. increases the data-ink ratio c. does not affect the data-ink ratio d. decreases the data-ink ratio

b. increases the data-ink ratio

A useful chart for displaying multiple variables is the _____. a. stacked column and bar chart b. scatter chart matrix c. two-dimensional graph d. scatter chart

b. scatter chart matrix

A _____ is a line that provides an approximation of the relationship between the variables. a. sparkline b. trendline c. gridline d. line chart

b. trendline

Consider the clustered bar chart of the dashboard developed to monitor the performance of a call center: term-7 This chart allows the IT manager to _____. a.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 c. identify how often a problem is related to hardware d. identify which city contains the most customers

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

Making visual comparisons between categorical variables may be difficult in a _____. a. line chart b. column chart c. pie chart d. scatter chart

c. pie chart

This bar chart displays the demographics of a Business Analysis class. Howmany male students are in the class? a. 80 b. 30 c. 50 d. 130

c. 50

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? a. It doesn't change the data-ink ratio. b. The data-ink ratio becomes zero. c. It reduces the data-ink ratio. d. It increases the data-ink ratio.

c. It reduces the data-ink ratio.

To summarize and analyze data with both a crosstabulation and charting, Excel typically pairs _____. a. stacked column charts with PivotTables b. heat maps with trendlines c. PivotCharts with PivotTables d. bubble charts with trendlines

c. PivotCharts with PivotTables

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

c. labels

A time series plot is also known as a _____. a. dot plot b. frequency graph c. line chart d. boxplot

c. line chart

Which one of the following statements is not true concerning PivotTables in Excel? a. PivotTables are interactive. b. PivotTables summarize data for two variables. c.PivotTables can be built using data arrayed in rows. d.PivotTables are also known as crosstabulation tables.

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

DJ needs to display data over time. Which of the following charts should he use? a. Scatter chart b. Bar chart c. Pie chart d. Line chart

d. Line chart

A data visualization tool that updates in real time and gives multiple outputs is called _____. a. a metrics table b. the GIS c. a data table d. a data dashboardd.

d. a data dashboardd.

In order to visualize three variables in a two-dimensional graph, we use a _____. a. 2-D chart b. 3-D chart c. column chart d. bubble chart

d. bubble chart

An alternative for a stacked column chart when comparing more than a couple of quantitative variables in each category is a _____. a. clustered bar chart b. pie chart c. stacked bar chart d. clustered column chart

d. clustered column chart

Fields may be chosen to represent all of the following except _____ in the body of a PivotTable. a. columns b. values c. rows d. filters

d. filters

Bar charts use _____. a.vertical bars to display the magnitude of the categorical variable b.horizontal and vertical bars to display the magnitude of the quantitative variable c.vertical bars to display the magnitude of the quantitative variable d.horizontal bars to display the magnitude of the quantitative variable

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

The following image is a _______. a. sparkline b. trendline c. gridline d. line chart

d. line chart

We create multiple dashboards _____. a.to make sure the KPIs are not displayed in the data dashboard b. so that all dashboards can be viewed on a single screen c.to help the user scroll vertically and horizontally to see the entire dashboard d. so that each dashboard can be viewed on a single screen

d. so that each dashboard can be viewed on a single screen