Excel Unit D Flashcards
Often contains numerical values that help you interpret the size of chart elements
Data market
Visually represents each data point
Chart
An independent element on a worksheet
Object
What type of chart is shown in the accompanying figure
Column
In the accompanying figure item ___ represents the vertical axis
3
To show how individual volume changes over time in a relationship to total volume use an
Area chart
Which chart type do you use to compare distinct objects over time using horizontal bars
Bar
Which chart type is the best candidate for spotting trends and extrapolating information based on research data
Scatter
You can ___ title text to select it
Triple click
An example of a(n) ___ chart is a column chart with a line chart
Combination
A combination chart can add an ___ axis to chat related data
Secondary
The default border color around a chart title is
Blue
In the accompanying figure item 1 points to a
Vertical axis title
In the accompanying figure item 2 points to a
Vertical axis label
In the accompanying figure item 5 points to a
Horizontal axis label
Which of the following is not an option that the Data Labels can produce
Legend name
Shape ___ make it possible to apply multiple formats to a data series’s such as on outline fill color all with a single click
Styles
You can add text box using the Chart Tools
Format
___ lets you create diagram types including List Process Cycle Hierarchy Relationship Matrix and Pyramid
Smart art
In a pie chart slices that are pulled away are said to be
Exploded
Text annotations are ___ that you can add to further describe the data in your chart
Labels
In the accompanying figure item 3 points to ___
Horizontal axis title
You can change a column chart to a clustered bar chart using the ___ dialog box
Change Chart Type
Which of the following will NOT be affected or rearrange by choosing a new layout on the Chart Tools Design tab
Data
A scatter chart
Compares trends over uneven time or measurements intervals
A chart that is inserted directly in the current worksheet is called a(n)
Embedded chart
Which chart type is the best candidate for emphasizing sales trends over a period of six months
Line
Which to chats compare trends over time
Line and scatter
Compares sizes of pieces as parts of a whole
A pie chart
A(n) ___ chart compares distinct object levels using vertical bars it is the exel default
Column
In the accompanying figure item 5 represents
The legend
In the accompanying figure item ___ represents the horizontal axis
2
Often contains the names of data groups such as locations months or years
Value axis
