Deck 3: Data Visualization

Question 1

To select a chart type in Excel from the Charts group, which tab has to be accessed?

A) Design tab
B) Layout tab
C) Insert tab
D) Format tab

Answer 1

Insert tab

Question 2

Philip wishes to understand the relative proportion of each data source to the total. Which of the following charts must Philip use?

A) Pie chart
B) Bar chart
C) Scatter chart
D) Column chart

Answer 2

Pie chart

Question 3

Describe how to and construct a pie chart exhibiting the count of purchase orders by item.

Answer 3

Identify all the outcomes for the variable Item. Create a frequency table of the counts of purchase orders by each outcome of the variable Item using the Excel formula COUNTIF$B$2:$B$44, criteria), where criteria represents each outcome of the variable Item. Select the entire table and choose the type of chart Pie Chart) from the Charts group under the Insert tab. Change the title and make data and formatting changes where necessary.

Question 4

Elaborate on the use of geographic data mapping in business analytics.

Question 5

To select data bars in Excel from the Home tab, which command would have to be accessed?

A) Find & Select under Editing group
B) Conditional Formatting under Styles group
C) Format under Cell group
D) None of the above

Question 6

After choosing the PivotTable, the PivotChart can be found on the tab.

A) Design
B) View
C) Analyze
D) Layout

Question 7

Observations consisting of pairs of variable data are required to construct a chart.

A) doughnut
B) scatter
C) radar
D) line

Question 8

Roger wants to compare values across categories using vertical rectangles. Which of the following charts must Roger use?

A) Line chart
B) Clustered column chart
C) Pie chart
D) Stacked column chart

Question 9

Which of the following charts provides a useful means for displaying data over time?

A) Scatter chart
B) A doughnut chart
C) Pie chart
D) Line chart

Question 10

Use the data given below to answer the following questions).
Following is the purchase order database of 'The Chef Says So', a restaurant in New York, over the last quarter April-June).
Describe how to and construct a line chart exhibiting the purchase order of ceramic plates over the three months.

Question 11

Which of the following charts shows three-dimensional data?

A) Surface chart
B) Column chart
C) Stock chart
D) Doughnut chart

Question 12

Use the data given below to answer the following questions).
Following is the purchase order database of 'The Chef Says So', a restaurant in New York, over the last quarter April-June). $\begin{array}{|r|r|l|l|c|r|r|} \hline& \text { A } &{\text { B }} & \text { C } & \text { D } & \text { E } &{\text { F }} \\\hline 1 & \text { Order Date } & \text { Item } & \text { Region } & \text { Supplier } & \text { Unit Cost } & \text { Units } \\\hline 2 & 5 / 6 / 2012 & \text { Steel Fork } & \text { Antasia } & \text { Peter } & 5.44 & 98 \\\hline 3 & 4 / 7 / 2012 & \text { Ceramic Plate } & \text { Puitoria } & \text { Kane } & 23.44 & 53 \\\hline 4 & 5 / 13 / 2012 & \text { Steel Fork } & \text { Puitoria } & \text { Jones } & 8.44 & 39 \\\hline 5 & 6 / 10 / 2012 & \text { Silver Spoon } & \text { Puitoria } & \text { Gerry } & 23.44 & 30 \\\hline 6 & 6 / 22 / 2012 & \text { Steel Fork } & \text { Almeco } & \text { Sarah } & 6.44 & 59 \\\hline 7 & 5 / 17 / 2012 & \text { Ceramic Plate } & \text { Antasia } & \text { Peter } & 8.44 & 63\\\hline 8 & 4 / 25 / 2012 & \text { Steel Fork } & \text { Puitoria } & \text { Audrey } & 5.44 & 78 \\\hline 9 & 6 / 1 / 2012 & \text { Steel Fork } & \text { Puitoria } & \text { Jones } & 8.44 & 93 \\\hline 10 & 4 / 2 / 2012 & \text { Steel Fork } & \text { Almeco } & \text { Thomas } & 5.44 & 35 \\\hline 11 & 5 / 27 / 2012 & \text { Ceramic Plate } & \text { Antasia } & \text { Peter } & 12.44 & 63 \\\hline 12 & 6 / 13 / 2012 & \text { Steel Fork } & \text { Puitoria } & \text { Mary } & 8.44 & 93 \\\hline 13 & 4 / 30 / 2012 & \text { Ceramic Plate } & \text { Antasia } & \text { Henry } & 5.44 & 32 \\\hline 14 & 5 / 11 / 2012 & \text { Ceramic Plate } & \text { Antasia } & \text { Philip } & 23.44 & 84 \\\hline 15 & 6 / 18 / 2012 & \text { Steel Fork } & \text { Antasia } & \text { Peter } & 8.44 & 38 \\\hline 16 & 5 / 9 / 2012 & \text { Glass Bottle } & \text { Putoria } & \text { Simson } & 128.45 & 5 \\\hline 17 & 5 / 30 / 2012 & \text { Ceramic Bowl } & \text { Antasia } & \text { Peter } & 19.44 & 19 \\\hline 18 & 6 / 6 / 2012 & \text { Ceramic Plate } & \text { Puitoria } & \text { Mary } & 12.44 & 31\\\hline 19 & 4 / 3 / 2012 & \text { Silver Spoon } & \text { Antasia } & \text { Peter } & 12.44 & 67 \\\hline 20 & 6 / 26 / 2012 & \text { Silver Spoon } & \text { Antasia } & \text { Philip } & 23.44 & 18 \\\hline 21 & 4 / 23 / 2012 & \text { Ceramic Bowl } & \text { Puitoria } & \text { Kane } & 8.44 & 99 \\\hline 22 & 4 / 29 / 2012 & \text { Steel Fork } & \text { Puitoria } & \text { Simson } & 4.74 & 70 \\\hline 23 & 4 / 4 / 2012 & \text { Ceramic Bowl } & \text { Antasia } & \text { Philip } & 19.44 & 77 \\\hline 24 & 6 / 15 / 2012 & \text { Ceramic Plate } & \text { Puitoria } & \text { Gerry } & 12.44 & 49 \\\hline\end{array}$
$\quad$

-Changes to the type of chart, data included in the chart, and chart layout and styles can be made from the Layout tab.

Question 13

Describe how to and construct an area chart exhibiting the units ordered by the region of Puitoria over the three months.

Question 14

Describe how to and construct a scatter chart exhibiting the relationship between the unit cost and the number of units for the purchase of steel forks.

Question 15

Describe how to and construct a column chart exhibiting the total units purchased by region.

Question 16

Peige, a stock broker, has data consisting of price, price/earnings ratio, and market capitalization for seven different stocks on one particular day. She wishes to plot these three variables in two dimensions. Which of the following charts must Peige use?

A) Stock chart
B) Surface chart
C) Bubble chart
D) Line chart

Question 17

Describe how to and construct a combination chart exhibiting the purchase order of ceramic plates as a line, and the unit cost as columns on the secondary axis over the three months.

Question 18

Construct a PivotChart to visualize the purchase order total units for steel forks and ceramic bowls within each region.

Question 19

How does Excel distinguish between vertical and horizontal bar charts?

Question 20

Which of the following charts allows plotting of multiple dimensions of several data series?

A) Doughnut chart
B) Bubble chart
C) Radar chart
D) Area chart

Question 21

What is a Key Performance Indicator?

A) A chart located in the bottom right of a dashboard.
B) An unnecessarily cluttered chart or table.
C) An important business metric.
D) None of the above.

Question 22

Let's suppose you have a data set reporting the sales of five different product categories across the columns, and for each of the past four quarters, listed across the rows. Which of the following use of Sparklines would be the most appropriate?

A) Column Sparklines to compare quarterly sales across product categories and time series for each product category.
B) Line Sparklines to visualize quarterly sales across product categories and time series for each product category.
C) Line Sparklines to visualize quarterly sales across product categories, and Column Sparklines to compare time series for each product category.
D) Column Sparklines to compare quarterly sales across product categories, and Line Sparklines to visualize time series for each product category.

Question 23

How many types of Sparklines are available?

A) 2
B) 3
C) 4
D) 5

Question 24

Icon Sets can provide more information than Color Scales because they allow you to combine shapes and arrows.

Question 25

Dashboards may include tabular as well as visual data to help a manager to quickly locate key information.

Question 26

Win/Loss Sparklines can only be used on quantitative data.

Question 27

Complete the following sentence: a Dashboard…

A) is a visual representation of a set of key business measures.
B) is derived from the analogy of an automobile's control panel.
C) provides important summaries of key business information.
D) is all of the above.

Question 28

You may not display data bars without the data in the cells.

Question 29

How is the color-coding of quantitative data commonly called?

A) Heatmap
B) Rainbow
C) Scaling
D) Hot & Cold

Question 30

Color Scales are one of the options under Conditional Formatting.