Question 1

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

Accepted Answer

Filter the data set by Region Puitoria). Sort the Order Date by Oldest to Newest. Select the columns A and F of the data set and choose the type of chart Area Chart) from the Charts group under the Insert tab. Change the title and make data and formatting changes where necessary.

Question 2

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.

Accepted Answer

A) True 
 B)False  False

Question 3

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

Accepted Answer

A) True 
 B)False  False

Question 4

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

Accepted Answer

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

Question 5

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

Accepted Answer

Identify all the outcomes for the variab

Question 6

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

Accepted Answer

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

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

Identify all the outcomes for the variab

Question 9

Complete the following sentence: a Dashboard…

Accepted Answer

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. 
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 10

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.

Accepted Answer

Filter the data set by Item Ceramic Plat

Question 11

How many types of Sparklines are available?

Accepted Answer

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

Question 12

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

Accepted Answer

Many applications of business analytics

Question 13

Which of the following charts shows three-dimensional data?

Accepted Answer

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

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.

Accepted Answer

Filter the data set by Item Steel Fork).

Question 15

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?

Accepted Answer

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

Question 16

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?

Accepted Answer

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. 
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 17

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

Accepted Answer

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

Question 18

What is a Key Performance Indicator?

Accepted Answer

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. 
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 19

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$
-Describe how to and construct a line chart exhibiting the purchase order of ceramic plates over the three months.

Accepted Answer

Filter the data set by Item Ceramic Plat

Question 20

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

Accepted Answer

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

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

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

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

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

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

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

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

Complete the following sentence: a Dashboard…

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.

How many types of Sparklines are available?

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

Which of the following charts shows three-dimensional data?

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.

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?

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?

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

What is a Key Performance Indicator?

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

Introduction to Labour Market Economics

Database Analytics

Descriptive Statistics

Probability Distributions and Data Modeling

Sampling and Estimation

Statistical Inference

Trendlines and Regression Analysis

Forecasting Techniques

Introduction to Data Mining

Spreadsheet Modeling and Analysis

Simulation and Risk Analysis

Linear Optimization

Integer and Nonlinear Optimization Models

Optimization Analytics

Decision Analysis

Filters

Exam 3: Data Visualization

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

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

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

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

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

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

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

Complete the following sentence: a Dashboard…

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.

How many types of Sparklines are available?

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

Which of the following charts shows three-dimensional data?

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.

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?

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?

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

What is a Key Performance Indicator?

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

Introduction to Labour Market Economics

Database Analytics

Descriptive Statistics

Probability Distributions and Data Modeling

Sampling and Estimation

Statistical Inference

Trendlines and Regression Analysis

Forecasting Techniques

Introduction to Data Mining

Spreadsheet Modeling and Analysis

Simulation and Risk Analysis

Linear Optimization

Integer and Nonlinear Optimization Models

Optimization Analytics

Decision Analysis

Filters