Which chart type is most appropriate to summarize data about categories?
a.
Bubble chart
b.
Bar chart
c.
Scatter chart
d.
Histogram
The following line chart would be more appropriate than the bar chart if __________.
Dnonr
oun
FM
N A
OO
Dnonr
oun
FM
N A
OO
a.
the minimums and maximums are important to display
b.
the x-variable data are older than the y-variable data
c.
the data collected have an important time series component denoted by the x-axis
d.
the variables are completely independent
Three months after the launch of five new products in the market, a consumer electronics company
arrived at the following results.
Products Profit (%) Market Share (%) Cost ($)
A 19 18 4,500
B 28 12 3,000
C 15 25 8,750
D 22 35 6,250
E 16 10 2,500
An analyst has created a scatter chart of profit and market share variables. After reviewing it, the analyst
also wants to include cost. Which type of chart should she create?
a.
Bubble chart
b.
Column chart
c.
2D chart
d.
3D chart
This clustered bar chart represents the performance of a call center.
The chart allows the IT manager to __________.
a.
identify the frequency of a particular type of problem by location
b.
identify which city contains the most customers
c.
identify the percent of customers who do not have one of the listed problems
d.
identify how often a problem is related to hardware
Which chart type is most appropriate to visualize the relationship between two quantitative variables?
a.
Scatter chart
b.
Pie chart
c.
Bar chart
d.
Column chart
Which editing option has been applied to a standard bar chart to create the following comparative bar
chart?
140
120
100
80
60
40
20
@
South
a.
Edit the bar chart and select Scatter with Straight Lines and Markers
b.
Edit the bar chart and select Series Bubble Size
c.
Edit the bar chart and select Clustered Column
d.
Edit the bar chart and select Stacked Column
Composition is _________.
a.
what makes up the whole of an entity under consideration
b.
how two variables are related to one another
c.
the relative order of items
d.
how items are dispersed
To achieve the colored and shading effect shown in this heat map, use the options in the ____________
menu.
a.
Chart Options
b.
Format Data Labels
c.
Insert Chart
d.
Conditional Formatting
n which year did South Sales surpass North Sales?
90
80
70
60
50
40
30
20
10
a.
During Year 7
b.
At the start of Year 8
c.
South Sales did not surpass North Sales
d.
During Year 6
What is the first step in creating a bar chart in Excel?
a.
Click the Insert Column or Bar Chart button.
b.
Select cells where data are contained.
c.
Click the Chart Elements button.
d.
Click the Insert tab on the Ribbon.
Approximately how much higher is the percent of part-time employed 18- to 24-year-olds compared to
full-time employed 35- to 44-year-olds?
80
70
60
50
40
30
20
10
m
Employed
Part-Time
(%)
HE
18-24 25-34
a.
10%
b.
30%
c.
60%
d.
50%
The following heat map shows the average monthly distance traveled(in billions of miles) by vehicles on
urban highways for five different years.
Which
months tend to have the highest average monthly distance traveled, regardless of the year?
a.
February, March, and April
b.
August, September, and October
c.
June, July, and August
d.
March, April, and May
What is the first step in creating a scatter chart in Excel?
a.
Click the Insert tab on the Ribbon.
b.
Click the Insert Scatter (X, Y) or Bubble Chart button.
c.
Click the Chart Elements button.
d.
Urban Highways - Average Monthly Distance Traveled by Vehicles (Billion Miles)
Years Jan Feb Ma
r
Apr May Jun Jul Au
g
Sep Oct Nov Dec
Year
1
4.2
2
5.3
2
5.12 5.12 4.92 4.4
9
4.5
5
4.49 4.44 4.39 4.37 4.35
Year
2
4.3
1
5.4
4
5.24 5.24 4.98 4.5
9
4.6
8
4.65 4.61 4.68 4.74 4.79
Year
3
4.3
8
5.5
1
5.36 5.36 4.98 4.6
3
4.7
1
4.78 4.82 4.88 4.85 4.89
Year
4
4.4
5
5.5
9
5.41 5.41 5.01 4.7
2
4.7
8
4.79 4.82 4.92 5.06 5.11
Year
5
4.5
1
5.6
5
5.49 5.49 5.12 4.8 4.8
8
4.82 4.95 5.12 5.22 5.44
Based on the following chart types, what is the most appropriate intended goal?
a.
Goal: To Show a Relationship
b.
Goal: To Show Composition
c.
Goal: To Show Distribution
d.
Goal: To Show Ranking
The following table shows the average monthly distance traveled(in billions of miles) by vehicles on
urban highways for five different years.
Year Jan. Feb. Mar. Apr. May June July Aug. Sept. Oct. Nov. Dec.
Year 1 4.22 5.32 5.21 5.12 4.92 4.49 4.55 4.49 4.44 4.39 4.37 4.35
Year 2 4.31 5.44 5.34 5.24 4.98 4.59 4.68 4.65 4.61 4.68 4.74 4.79
Year 3 4.38 5.51 5.41 5.36 4.98 4.63 4.71 4.78 4.82 4.88 4.85 4.89
Year 4 4.45 5.59 5.5 5.41 5.01 4.72 4.78 4.79 4.82 4.92 5.06 5.11
Year 5 4.51 5.65 5.62 5.49 5.12 4.8 4.88 4.82 4.95 5.12 5.22 5.44
Which chart would be suitable for gaining insight on the months and years that had the highest average
distance traveled?
a.
Bubble chart
b.
Pie chart
c.
Scatter chart
d.
Heat map
This bar chartdisplaysthedemographics of a business analysis class. How many malestudents are in the
class?
a.
130
b.
80
c.
50
d.
30
Sam needs to display data over time. Which of the following charts should he use?
a.
Bar chart
b.
Scatter chart
c.
Line chart
d.
Pie chart
In the line chart creation process, which chart editing option suggests continuity between the connection
points and makes it easier for the reader to see and interpret changes that have occurred over time?
a.
Series Bubble Size
b.
Monochrome Color Scheme
c.
Scatter with Straight Lines and Markers
d.
Clustered Column
In order to visualize three variables in a two-dimensional graph, we use a __________.
a.
2D chart
b.
column chart
c.
3D chart
d.
bubble chart
Based on the following chart types, what is the most appropriate intended goal?
a.
Goal: To Show Distribution
b.
Goal: To Show Ranking
c.
Goal: To Show Composition
d.
Goal: To Show a Relationship
