Chapter 3 Study Guide
Where does the primary axis display on a combo chart?
Left side
What font color does excel use by default for many of its elements
Black, text 1, lighter 35%
In the Insert Chart dialog box, after you pick a chart type where rare the subtypes listed?
Top Right
in a bar chart, which axis displays the categories
Vertical
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
3-D chart
adds an additional dimension to your chart
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
Which chart type displays the data horizontally?
bar
which chart type is preferable when the category names are long?
bar
which chart type cannot be displayed as a sparkline?
bar chart
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
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
Which of the following is NOT a chart element?
chart foreground
sparkline
chart resides in one cell
what is not found on the chart elements list?
chart type
what icon is not displayed when you select a chart?
chart types
which of the following is not a chart type?
circle
area chart
colors are used between the lines
which chart types displays the data vertically?
column
clustered column chart
columns are set side by side
combo chart
combines two chart types
what chart type can display two different chart types at the same time?
combo
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 data
which group on the design tab would you select if you wanted to change the source information in the chart?
data
which of the following is NOT a chart element?
data area
chart filter
decides what is hidden or displayed in a chart
chart title
describes the entire chart
data labels
easier to read than a legend
sparklines
examples include: line, column, win/loss
a parallel range is one that consists of the same starting point of another range, but can have a different end point.
false
a stacked column chart displays multiple columns for each category
false
as long as you pick the correct chart you can mix numeric value systems, such as dollars and number of units sold
false
in rare cases you can chart text entries
false
including the column and row labels in a chart makes the chart harder to understand
false
to switch to a different chart type after the chart has been created you use the switch chart type tool
false
when you create a chart Excel automatically creates the chart on its own sheet and labels it Chart1
false
what group is not found on the sparkline tools design tab?
format
Which chart element cannot be chosen from the chart elements dialog box?
format back wall
parallel range
has the same starting and ending point
chart filter
helps you to focus on particular data
quick layout
helps you use predefined layouts
chart area
holds the entire chart
X-axis
horizontal border
which tab displays the tools for creating charts?
insert
What is NOT true about an effective chart?
it always contains more than one series
line chart
line connect data points
arrange
moves an object backward or forward
in the take pane, what does a diagonal which triangle next to a chart category indicate?
none of the category's options are displayed
exploding pie chart
one or more pieces are separated from the other
X Y (scatter) chart
one variable is plotted on the horizontal axis and the other on the vertical axis
what chart type represents data as spokes going from the center to the outer edge of the chart?
radar
sizing handles
seen as 8 circles
what is a disadvantage of a stacked column chart?
segments do not start at the same point
chart style
sets the formatting of the chart
data label
shows the precise value of a data pint
histogram
similar to a column chart
area
similar to a line chart
which chart type is NOT listed in the All Charts window?
sparkline
which chart type is a visual "dashboard" of your data?
sparkline
which group on the sparkline tools design tab would you choose is you wanted to change the data source of the sparkline?
sparkline
radar
spokes radiate from the center to the outer edges
stock chart
subtypes include: High-Low-Close, Open-High-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
effective charts never overwhelm an audience
true
it is good practice to delete any blank rows or columns before creating a chart
true
it is important to select parallel ranges
true
pie charts can only display one data series
true
when you want to chart two related types of data, the combo chart is perfect
true
you cannot enter data or formulas on a chart sheet
true
you might want to avoid using 3-D charts because they can distort the appearance of the data
true
combo chart
used for two different but related data types
triangle with a white fill
used to show that all chart category options are not visible
diagonal black triangles
used to show that all chart category options are visible
legend
uses color or patterns to identify each data series
bar chart
uses horizontal bars
pie chart
uses slices to display data points
surface chart
uses two dimensions and a continuous curve
column chart
uses vertical bars
Which axis in a chart displays incremental numbers for the data points?
value
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
X Y (scatter) chart
Often used in educational, scientific, and medical experiments
a 100% stacked column chart is similar to what other chart in that it converts values to percentages?
Pie
what is NOT a purpose of using an effective chart?
Reveals even subtle errors in formulas
