BUS 311: Excel Ch 3
What font color does Excel use by default for many of its elements?
Black, Text 1, Lighter 35%
T/F: A chart sheet can hold, at most, two charts.
False
T/F: A chart style effects the formatting of the chart itself, but not the chart data.
False
T/F: A parallel range is one that consists of the same starting point of another range, but can have a different end point.
False
T/F: A stacked column chart displays multiple columns for each category.
False
T/F: As long as you pick the correct chart you can mix numeric value systems, such as dollars and number of units sold.
False
T/F: In a rare cases you can chart text entries.
False
T/F: Including the column and row labels in a chart makes the chart harder to understand.
False
T/F: Once a data source is selected for a chart, the only way to change the data source is to start over creating the chart.
False
T/F: The range used for a sparkling cannot include more than one row.
False
T/F: To switch to a different chart type after the chart has been created you use the Switch Chart Type tool.
False
T/F: To understand a chart you need to include the chart data.
False
T/F: When you create a chart Excel automatically creates the chart on its own sheet and labels it Chart1.
False
T/F: Effective charts never overwhelm an audience.
True
T/F: Even after selecting a data source for a chart you can still apply various filters on one or more series.
True
T/F: Excel normally uses all the selected data in creating a chart.
True
T/F: It is good practice to delete any blank rows or columns before creating a chart.
True
T/F: It is important to select parallel ranges.
True
T/F: Pie charts can only display one data series.
True
T/F: Sparklines do not include the normal chart labels.
True
T/F: The Chart Styles gallery displays style options for the selected chart only.
True
T/F: When you want to chart two related types of data, the Combo chart is perfect.
True
T/F: You can link to a cell as the title of a chart.
True
T/F: You can switch the rows and columns in a chart to communicate a different perspective on your data.
True
T/F: You can't enter data or formulas on a chart sheet.
True
T/F: You might want to avoid using 3D charts because they can distort the appearance of the data.
True
The ___ axis helps measure data from left to right in a graph.
X
The __ axis helps measure data from top to bottom in a chart.
Y
The __ axis is the vertical axis.
Y
Data table
a grid used to plot data in a chart
Data series
a group of data points
Data point
a precise value in a chart
task pane
a window of options
In a stacked column chart the data must be ___.
additive
3D chart
adds an additional dimension to your chart
Do not use data ___ and individual values in a chart.
aggregates
including what, distorts the effectiveness of charting data points?
aggregates
In the task pane, what does a diagonal black triangle next to a chart category indicate?
all the category's options are displayed
accessibility compliance
applying features to make it easier on disabled users
What does Excel not determine about the value axis when you create a chart?
average value
What chart type is preferable when the category names are long?
bar
Which chart type displays the data horizontally?
bar
Which chart type can't be displayed as a sparkling?
bar chart
If your chart is intended for presentation, as opposed to printing, you should use a __ background.
black and dark
plot area
both axes form a border for this
Where does Excel display the Quick Analysis tool?
bottom-right corner
alt text
can be read by various devices
In a column chart the horizontal axis displays the ___.
categories
Which axis in a chart displays the descriptive labels for the data points?
category
What can you not do from the select data source dialog box?
change chart type
100% stacked column chart
changes individual data points to percentages
Excel uses ___ to determine what categories are visible in a chart.
chart filters and filters
What is not a chart element?
chart foreground
Sparklines
chart resides in one cell
What icon is not displayed when you select a chart?
chart styles
What is not found on the chart elements list?
chart title
What is not a chart type?
circle
In a ____ column chart data appears as side by side columns.
clustered
area chart
colors are used between the lines
Which chart type displays the data vertically?
column
clustered column chart
columns are set side by side
combo chart
combines two chart types
Which chart type is best when you want to chart two unrelated data types?
combo chart
stacked column chart
compares individual points to the whole category
column chart
compares values across categories
chart sheet
contains no spreadsheet
To select nonadjacent ranges press and hold the __ key while selecting the nonadjacent ranges.
control
Which group on the design tab would you select if you wanted to change the source information in the chart?
data
What is not a chart element?
data area
A Chart Filter Excel uses ___ to indicate which chart categories are displayed in a chart.
data point
A ___ is a cell that contains a value used in a chart.
data point
chart filter
decides what is hidden or displayed in a chart
chart title
describes the entire chart
data lables
easier to read than a legend
sparklines
examples include: line, column, win/loss
What group is not found on the Sparkling Tools Design tab?
format
Which chart element can't be chosen from the Chart elements dialog box?
format back wall
Parallel range
has the same starting and ending point
Legend
helps to distinguish between various data series
Chart filter
helps you to focus on particular data
chart area
holds the entire chart
A bar chart uses __ bars.
horizontal
x-axis
horizontal border
What tab displays the tools for creating charts?
insert
What is not true about an effective chart?
it always contains more than one series
Where does the primary axis display on a combo chart?
left side
The ___ is the visual key to a chart.
legend
If you wanted to show trends over set periods of time, you probably want to use ___ chart.
line
Line chart
line connect data points
What chart type can display 2 different chart types at the same time?
mixed
Arrange
moves an object backward or forward
In the task pane, what does a diagonal white triangle next to a chart category indicate?
none of the category's options are displayed
X Y (scatter) chart
often used in educational, scientific, and medical experiments
Exploded pie chart
one or more pieces are separated from the others
X Y (scatter) chart
one variable is plotted on the horizontal axis and the other on the vertical axis
A 100% stacked column chart is similar to what other chart in that it converts values to percentages?
pie
What chart type represents data as spokes going from the center to the outer edge of the chart?
radar
If you are not sure which chart type to pick, it may be helpful to click __ Charts in the Chart group.
recommended
What is not a purpose of using an effective chart?
reveals even subtle errors in formulas
sizing handles
seen as 8 circles
What is a disadvantage of a stacked column chart?
segments do not start at the same point
A data ____ is a group of related data points.
series
A group of data points used in a graph become a data ___.
series
chart style
sets the formatting of the chart
Column charts are the most effective when they have __ or fewer categories.
seven
Data label
shows the precise value of a data point
histogram
similar to a column chart
Area
similar to a line chart
When you want to create a chart you first need to select a data ___.
source
A ___ is a type of chart which fits in one cell.
sparkline
Which chart type is a visual "dashboard" of your data?
sparkline
Which chart type is not listed in the All Charts window?
sparkline
Which group on the Sparkline Tools Design tab would you choose if you wanted to change the data source of the sparkline?
sparkline
radar
spokes radiate from the center to the outer edges
A ___ column chart displays the relationship of data points to the whole category.
stacked
Picking a chart __ will allow you to change several formatting elements at the same time.
style
stock chart
subtypes inclue: high-low close, open-high-low-close, volume-high-low-close, and volume-open-high-low-close
Alt text
text based interpretation
chart font color
the default is black, text 1, lighter 35%
In a pie chart which of the following is a good reason for using category data labels rather than the legend?
they are easier to read
Chart element
this helps make a chart clearer
In the insert chart dialog box, after you pick a chart type where are the subtypes listed?
top right
triangle with white fill
use to show that all chart category options are not visible
combo chart
used for 2 different but related data types
diagonal black triangles
used to show that all chart category options are visible
surface chart
uses 2 dimensions and a continuous curve
legend
uses color or patterns to identify each data series
Bar charts
uses horizontal bars
Pie chart
uses slices to display the data points
Column chart
uses vertical bars
Which axis in a chart displays incremental numbers for the data points?
value
In a bar chart, which axis displays the categories?
vertical
y-axis
vertical border
What should you not select when selecting data for a chart?
worksheet titles
How many variations of the stock chart does Excel have?
4
As a general rule, pie charts should be limited to how many slices?
7
How many sizing handle are found on embedded charts?
8
____ charts are often used to represent data in educational, scientific, and medical experiments.
Scatter, X Y and XY Scatter
When you point to a chart element Excel displays ___ with the name of the element.
ScreenTip and Screen Tip