Excel Chapter 4 MC Flashcards
For which of the following reasons would you choose to use a chart or graph?
To show trends or relationships across data
The ____ is not a component of a data series.
Category name
The ____ is the only one of the following charts to compare relative values from different categories to the whole.
pie
To work with a title or other individual element of a chart, select the ____ tab.
Layout
Placing a chart in a ____ displays only the chart and no worksheet cells.
chart sheet
Depending on the pie chart layout you choose, you can ____.
Hide or display the chart title
Display a chart legend
Add percentages to pie slices
A(n) ____ is text associated with a data value.
data label
If you do not want a chart to reflect new values in the data source, you should ____.
paste the chart as a picture
To display a large number of categories whose values are close to one another, you should create a ____ chart.
Column
Bar
A ____ acts like a line on a ruler, making it easier to read a chart’s scale.
major tick mark
The ____ axis displays the categories associated with each data value.
horizontal
In a column chart, you can ____.
Add a gradient fill to columns
Reduce gap width between columns
Insert minor tick marks to detail space
To display Mar 17, 2008 as a custom format, you would type ____ in the Format Code: box in Excel.
mmm-dd-yyyy
Which of the following are examples of shapes you could choose from the Excel design gallery?
?
After you insert a shape into a chart or worksheet, you can ____.
?
The most precise way to move an embedded shape from one position to another is to use ____.
?
All of the following are options for horizontally aligning a shape except ____.
?
A chart sheet can contain ____, enabling you to display several charts at once within a single sheet.
embedded charts
Rotation options for a chart allow you to rotate the ____.
x-axis
y-axis
perspective
Which of the following represents a range of data in Excel?
C2:F12
A(n) ____ chart is similar to a line chart, but uses a fill color to shade areas under the lines.
area
In Excel charts, the Legend Options dialog box allows you to change all the following except ____.
Font Size
If you have chosen Outside End, Percentage, and Show Leader Lines, you are setting options in the ____ box.
Label Options
Because of the visual distortion that can result with 3D charts, you should ____.
include data labels with all 3D charts
With 3-D rotation, you can change a chart’s ____.
Rotation
Perspective
Depth
To fill a column with a blend of colors in a column chart, you would choose ____ from the Fill options.
gradient fill
Which of the following is not an option in the Fill options in the Format Data Series dialog box?
All are options (preset colors, angles, direction)
In Excel, Axis Options allow you to specify ____.
The axis type
Where the vertical axis crosses
The axis position
The first step in creating a combination chart is to ____.
select a data series in an existing chart that you want to appear as another chart type
The ____ is a rectangular area that labels the markers or symbols used in a chart.
legend
