Question 1

How does Excel distinguish between vertical and horizontal bar charts?

Accepted Answer

Excel distinguishes between vertical and

Question 2

Color Scales are one of the options under Conditional Formatting.

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

Choose the whole range of data

Question 4

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

Accepted Answer

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

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

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

Question 7

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

Accepted Answer

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

Question 8

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

Accepted Answer

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

Question 9

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

Accepted Answer

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

Question 10

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

Accepted Answer

A) True 
 B)False

How does Excel distinguish between vertical and horizontal bar charts?

Color Scales are one of the options under Conditional Formatting.

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

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

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

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

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

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

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

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

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

How does Excel distinguish between vertical and horizontal bar charts?

Color Scales are one of the options under Conditional Formatting.

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

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

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

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

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

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

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

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

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