click below
click below
Normal Size Small Size show me how
CTS 130 EM04
(Galvan) EM4
Question | Answer |
---|---|
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 |
The ____ Chart Tools contextual tabs appear on the Ribbon when you select a chart. | design, layout and format. |
The ____ dialog box provides options for moving charts between worksheets and chart sheets. | Move Chart |
Placing a chart in a ____ displays only the chart and no worksheet cells. | chartsheet |
To move or resize an embedded chart, ____. | select a chart and drag selection box, and drag size handles on the selection box. |
Depending on the pie chart layout you choose, you can ____. | hide or display chart title, display chart legend, add percentages to pie slices. |
To reposition the legend to the left-hand side of a chart, click the Legend button, and then click ____. | show legend at left. |
____ is not an available formatting category for legends. | shading |
____provide descriptive text for the individual data markers, such as pie slices. | data labels |
The Label Position option in the Format Data Labels dialog box includes ____. | center , inside end, or outside end |
Since each slice of a pie represents a different value in the series, you ____. | must formal each slice separately |
To move one slice of a pie chart away from the pie creates a(n) ____. | exploded pie chart. |
You already created a line chart, but now decide that you want to change this chart to a pie chart. To do this, you click ____ from the Type group in the Chart Tools Design tab. | change chart type. |
A 90° ____ value exaggerates the 3-D effect, making distant objects appear very small. | perspective |
You can use the 3-D Format options to add drop shadows, raised or beveled corners, and textured surfaces that give the illusion of ____ reflecting off the chart elements. | light |
If you do not want a chart to reflect new values in the data source, you should ____. | paste chart as a picture. |
To display a large number of categories whose values are close to one another, you should create a ____ chart. | column or bar |
A ____ acts like a line on a ruler, making it easier to read a chart’s scale. | major tick mark. |
One advantage of breaking up a sparkline group is that Excel can display each sparkline based on the ____ values associated with the individual sparkline’s data series. | maximum and minimum. |
In a column chart, you can ____. | add a gradient fill to columns, reduce gap width between columns, modify appearance of datamarkers. |
In Excel, typing ____ in the Format Code: box would result in that month’s full name being displayed on a chart. | MMMM |
To display Mar 17, 2008 as a custom format, you would type ____ in the Format Code: box in Excel. | MMM DD, YYYY |
To specify the name of a new data series and its range of data values, use the ____ dialog box. | edit series. |
=‘Trolley Schedule’!$A$2:$C$12 identifies a ____. | chart data range |
From the Format Data Series dialog box, you can ____ as a Marker Option. | select a built-in marker type, choose data marker type, select size of data marker |
On a 3-D chart, the ____ represents the object’s depth. | Z-axis |
If you select a chart’s series and look at the formula bar, the formula being displayed uses the ____ function. | series |
Edward Tufte was concerned with what he termed as “chart ____,” in which a proliferation of chart elements—chosen because they look “nice”—confuse and distract the reader. | junk |
Edward Tufte said that ____ ink is any part of the chart that does not convey information about the data. | non-data |
A column sparkline can be ____. | inserted anywhere within the workbook, can represent data from several rows or several columns. |
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 |
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 3-D charts, you should ____. | include data labels with all 3-D charts |
With 3-D rotation, you can change a chart’s ____ | rotation, perspective, depth |
In the Format Axis dialog box, selecting Fixed 0.10 for the Minor Unit will result in ____. | minor tick marks appear at 10% intervals. |
To fill a column with a blend of colors in a column chart, you would choose ____ from the Fill options. | gradient fill. |
In Excel, Axis Options allow you to specify ____. | axis type, where vertical axis crosses and axis position |
To format an individual sparkline, select the sparkline you want to format, and then click the Ungroup button in the Group group on the Sparkline Tools ____ tab. | design |
The first step in creating a combination chart is to ____. | select 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. |
To add an axis to a sparkline, click the Axis button in the ____ group on the Sparkline Tools Design tab, and then click Show Axis. | group |