BA 205 Ch. 3
This Excel bar chart displays the demographics of a BusinessAnalysisclass. Approximately howmanystudentsarein the class? 175 150 105 130
130
Never use a _____ chart when a _____ chart will suffice. 3-D; 2-D 2-D; 3-D color; black and white bar; pie
3-D; 2-D
This bar chart displays the demographics of a BusinessAnalysisclass.Howmanymale studentsareintheclass? 30 50 80 130
50
_____ are visual methods of displaying data. Tables Charts PivotTables Crosstabs
Charts
Natalie needs to compare the number of employees by job title for the last five years. Which of the following charts should Natalie use? Scatter chart Bubble chart Clustered-column (bar) chart Line chart
Clustered-column (bar) chart
To generate a scatter chart matrix, we use _____. native Excel functionality Excel Add-In XLMiner Excel Add-In MegaStat all of these
Excel Add-In XLMiner
The software package most commonly used for creating simple charts is _____. Excel. XLMiner. SAS. R.
Excel.
DJ needs to display data over time. Which of the following charts should he use? Scatter chart Pie chart Bar chart Line chart
Line chart
To summarize and analyze data with both a crosstabulation and charting, Excel typically pairs _____. PivotCharts with PivotTables stacked column charts with PivotTables heat maps with trendlines bubble charts with trendlines
PivotCharts with PivotTables
Which one of the following statements is not true concerning PivotTables in Excel? PivotTables are also known as crosstabulation tables. PivotTables summarize data for two variables. PivotTables are interactive . PivotTables can be built using data arrayed in rows.
PivotTables can be built using data arrayed in rows.
Which of the following graphs cannot be used to display categorical data? Stacked-column chart Scatter chart Pie chart Clustered-column chart
Scatter chart
_____ merges maps and statistics to present data collected over different geographies. The heat map The geographic information system A geographical map The statistical information system
The geographic information system
A data visualization tool that updates in real time and gives multiple outputs is called _____. a data table a metrics table the GIS a data dashboard
a data dashboard
A chart that is recommended as an alternative to a pie chart is a _____. bar chart line chart stacked column chart box plot
bar chart
The charts that are helpful in making comparisons between categorical variables are _____. bar charts and scatter charts scatter charts and line charts bar charts and column charts column charts and line charts
bar charts and column charts
In order to visualize three variables in a two-dimensional graph, we use a _____. 2-D chart 3-D chart bubble chart column chart
bubble chart
An alternative for a stacked column chart when comparing more than a couple of quantitative variables in each category is a _____. stacked bar chart clustered column chart pie chart clustered bar chart
clustered column chart
A PivotChart, in few instances, is the same as a _____. clustered-column chart bubble chart stacked-column chart bar chart
clustered-column chart
A graphical presentation that uses vertical bars to display the magnitude of quantitative data is known as a _____. scatter chart bubble chart clustered column chart column chart
column chart
The data dashboard for a marketing manager may have KPIs related to _____. current sales measures and sales by region current financial standing of the company data on the company's call center overall performance of the company's stock over the previous 52 weeks
current sales measures and sales by region
Fields may be chosen to represent all of the following except _____ in the body of a PivotTable. rows columns values filters
filters
A two-dimensional graph representing the data using different shades of color to indicate magnitude is called a _____. heat map bubble chart column chart pie chart
heat map
An effective display of trend and magnitude is achieved by using a combination of a _____. time series plot and sparklines line chart and trendlines heat map and sparklines bubble chart and trendlines
heat map and sparklines
Bar charts use _____. horizontal bars to display the magnitude of the quantitative variable vertical bars to display the magnitude of the quantitative variable horizontal and vertical bars to display the magnitude of the quantitative variable vertical bars to display the magnitude of the categorical variable
horizontal bars to display the magnitude of the quantitative variable
Deleting the grid lines in a table and the horizontal lines in a chart ______. increases the data-ink ratio decreases the data-ink ratio increases the non-data-ink ratio does not affect the data-ink ratio
increases the data-ink ratio
Data-ink is the ink used in a table or chart that _____. does not help in conveying the data to the audience helps in presenting data when the audience need not know exact values is necessary to convey the meaning of the data to the audience increases the non-data-ink ratio
is necessary to convey the meaning of the data to the audience
A disadvantage of stacked - column charts and stacked- bar charts is that _____. they do not include all the values of the variable they cannot be used to compare relative values of quantitative variables for the same category it can be difficult to perceive small differences in areas they are only used when many quantitative variables need to be displayed
it can be difficult to perceive small differences in areas
In a business, the values indicating the business's current operating characteristics, such as its financial position, the inventory on hand, and customer service metrics, are typically known as _____. company performance indicators performance indicators key performance indicators business performance indicators
key performance indicators
The best way to differentiate chart elements is by using _____. colors labels bubbles chart titles
labels
A time series plot is also known as a _____. boxplot frequency graph dot plot line chart
line chart
A _____ is used for examining data with more than two variables, and it includes a different vertical axis for each variable. scatter plot PivotChart column chart parallel-coordinates plot
parallel-coordinates plot
Making visual comparisons between categorical variables may be difficult in a _____. scatter chart pie chart line chart column chart
pie chart
A _____ is a graphical presentation of the relationship between two quantitative variables. histogram bar chart pie chart scatter chart
scatter chart
We create multiple dashboards _____. to help the user scroll vertically and horizontally to see the entire dashboard so that each dashboard can be viewed on a single screen to make sure the KPIs are not displayed in the data dashboard so that all dashboards can be viewed on a single screen
so that each dashboard can be viewed on a single screen
A line chart that has no axes but is used to provide information on overall trends for time series data is called a _____. time series plot sparkline trendline bubble chart
sparkline
To avoid problems in interpreting the differences in color in a heat map, _____ can be added. a bubble chart a pie chart a scatter chart sparklines
sparklines
Tables should be used instead of charts when _____. the reader needs relative comparisons of data there are more than two columns of data the values being displayed have different units or very different magnitudes the reader need not differentiate the columns and rows
the values being displayed have different units or very different magnitudes
Using multiple lines on a line chart or employing multiple charts is an alternative to a _____. column chart line chart two-dimensional graph three-dimensional chart
three-dimensional chart
A _____ is useful for visualizing hierarchical data along multiple dimensions. heat map hierarchical map treemap map of multiple hierarchy
treemap
A _____ is a line that provides an approximation of the relationship between the variables. line chart sparkline trendline gridline
trendline
