Deck 10: Share the Story

Question 1

__________ can be useful for showing proportion and visualizing categorical data.

A) Bar charts
B) Line charts
C) Pie charts
D) Histograms

Answer 1

C

Question 2

The easiest way to change the order in a chart is in the __________.

A) chart options
B) underlying spreadsheet
C) chart itself
D) slicer

Answer 2

B

Question 3

The horizontal axis is typically used for values.

Answer 3

False

Question 4

Pie charts are rarely preferred if there are more than ten categories (or "slices" of pie).

Question 5

The increments of the scale listed on the vertical axis are called __________.

A) tick marks
B) data series
C) data points
D) markers

Question 6

PivotCharts are dynamic so once the source data is changed the PivotChart will automatically update.

Question 7

__________ charts are preferable to __________ charts when the trend is the most important item to communicate.

A) Bar; line
B) Line; bar
C) Bar; pie
D) Pie; line

Question 8

In a data visualization, the vertical axis typically shows __________.

A) values
B) labels
C) categories
D) titles

Question 9

Within Excel, PivotCharts generally accompany PivotTables.

Question 10

Dashboards typically have filters available, so decision makers can easily inspect a particular time period, category, product, or geographic area.

Question 11

The data series is the underlying data populating the data visualization.

Question 12

Unlike histograms, box plots pack a lot of descriptive/diagnostic statistics into one graph.

Question 13

Charts are more effective than graphs when there are multiple bits of information to communicate.

Question 14

The vertical axis in a histogram is usually associated with the count of observations in each particular bin.

Question 15

While __________ could represent counts of categorical data, __________ are only used for numerical data.

A) bar charts; histograms
B) histograms; bar charts
C) line charts; bar charts
D) bar charts; pie charts

Question 16

The individual data observations in a data series are called __________.

A) tick marks
B) data series
C) data points
D) markers

Question 17

Ratio data should be visualized with __________ as the starting point, especially in a bar chart.

A) zero
B) the minimum value
C) the maximum value
D) the median

Question 18

Charts in Excel default to sorting in the order of the data presented in the spreadsheet.

Question 19

Pie charts, bar charts and histograms are generally associated with __________ analytics.

A) predictive
B) prescriptive
C) diagnostic
D) descriptive

Question 20

Scatter plots are used to exhibit potential __________.

A) trends
B) correlation
C) co-occurrences
D) statistical inferences

Question 21

An observation, or data point that is expected on a box plot will typically appear __________ the maximum or minimum value within the expected range.

A) outside
B) inside
C) within
D) around

Question 22

Line charts should only be shown __________ in order to emphasize __________.

A) chronologically; the overall trend rather than specific data points
B) chronologically; specific data points rather than the overall trend
C) categorically; the overall trend rather than specific data points
D) categorically; specific data points rather than the overall trend

Question 23

Regardless of the type of data between in a chart, it should be in __________ order.

A) chronological
B) alphabetical
C) logical
D) ascending

Question 24

Which of the following is typically excluded in an executive report?

A) Executive summary
B) Summary of the results
C) Brief recommendation
D) These are all included in an executive report.

Question 25

Displaying net income over the past 10 years should be shown in __________ order.

A) chronological
B) alphabetical
C) logical
D) ascending

Question 26

Visualizations are part of which component of the AMPS model?

A) Share the Story
B) Ask the Question
C) Master the Data
D) Perform the Analysis

Question 27

Inventory costs are most likely to be shown as __________.

A) ordinal data
B) interval data
C) ratio data
D) nominal data

Question 28

A __________ is a tool which can be added to a PivotChart in Excel to make it easier for an end-user to filter the data.

A) cutter
B) slicer
C) calculated field
D) sparkline

Question 29

A __________ is the most effective way to show sensitivity analysis.

A) table
B) scatter chart
C) line chart
D) bar chart

Question 30

In order to change a PivotChart in Excel, you must first __________.

A) change the source data
B) change the source data and refresh the PivotChart
C) right click the PivotChart to edit
D) do nothing. PivotCharts are dynamic so once the source data is changed it automatically updates

Question 31

Aged receivables in a pivot chart is actually a modified __________.

A) histogram
B) box plot
C) scatter plot
D) bar chart

Question 32

What type(s) of analytics are useful when Sharing the Story in the AMPS model?

A) Predictive analytics only
B) Prescriptive analytics only
C) Both predictive and prescriptive analytics
D) Descriptive, diagnostic, predictive, and prescriptive analytics