(Galvan) EM4
Quiz yourself by thinking what should be in
each of the black spaces below before clicking
on it to display the answer.
Help!
|
|
||||
|---|---|---|---|---|---|
| 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
🗑
|
Review the information in the table. When you are ready to quiz yourself you can hide individual columns or the entire table. Then you can click on the empty cells to reveal the answer. Try to recall what will be displayed before clicking the empty cell.
To hide a column, click on the column name.
To hide the entire table, click on the "Hide All" button.
You may also shuffle the rows of the table by clicking on the "Shuffle" button.
Or sort by any of the columns using the down arrow next to any column heading.
If you know all the data on any row, you can temporarily remove it by tapping the trash can to the right of the row.
To hide a column, click on the column name.
To hide the entire table, click on the "Hide All" button.
You may also shuffle the rows of the table by clicking on the "Shuffle" button.
Or sort by any of the columns using the down arrow next to any column heading.
If you know all the data on any row, you can temporarily remove it by tapping the trash can to the right of the row.
Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.
Normal Size Small Size show me how
Normal Size Small Size show me how
Created by:
galvanl
Popular Computers sets