CH 3: Charts
Quiz yourself by thinking what should be in
each of the black spaces below before clicking
on it to display the answer.
Help!
|
|
||||
|---|---|---|---|---|---|
| 100% stacked column chart | show 🗑
|
||||
| show | A chart type that emphasizes magnitude of changes over time by filling in the space between lines with a color.
🗑
|
||||
| Axis | show 🗑
|
||||
| show | A label that describes either the category axis or the value axis. Provides clarity, particularly in describing the value axis.
🗑
|
||||
| show | A chart type that compares values across categories using horizontal bars. In a bar chart, the horizontal axis displays values and the vertical axis displays categories.
🗑
|
||||
| show | A chart type that shows relationships among three values by using bubbles to show a third dimension. The third dimension is indicated by the size of the bubble; the larger the bubble, the larger the value.
🗑
|
||||
| show | The chart element that displays descriptive group names or labels, such as city names or departments, to identify data.
🗑
|
||||
| show | Text that describes a collection of data points in a chart.
🗑
|
||||
| show | A visual representation of numerical data and helps reveal trends or patterns to help people make informed decisions.
🗑
|
||||
| Chart area | show 🗑
|
||||
| show | A component of a chart that helps complete or clarify the chart.
🗑
|
||||
| Chart filter | show 🗑
|
||||
| show | A sheet within a workbook that contains a single chart and no spreadsheet data.
🗑
|
||||
| show | A collection of formatting that controls the color of the chart area, plot area, and data series.
🗑
|
||||
| Chart title | show 🗑
|
||||
| Clustered column chart | show 🗑
|
||||
| Column chart | show 🗑
|
||||
| show | A type of chart that displays data vertically in columns to compare values across different categories.
🗑
|
||||
| show | A chart that combines two chart types, such as column and line, to plot different types of data, such as quantities and percentages.
🗑
|
||||
| Data label | show 🗑
|
||||
| show | A numeric value that describes a single value in a chart or worksheet.
🗑
|
||||
| Data series | show 🗑
|
||||
| show | A grid that contains the data source values and labels to plot data in a chart. A data table may be placed below a chart or hidden from view.
🗑
|
||||
| show | A chart type that displays values values as percentages of the whole but may contain more than one data series.
🗑
|
||||
| Error bar | show 🗑
|
||||
| Exploded pie chart | show 🗑
|
||||
| show | A horizontal or vertical line that extends from the horizontal or vertical axis through the plot area to guide the reader's eyes across the chart to identify values.
🗑
|
||||
| show | A key that identifies the color, gradient, picture, texture, or pattern assigned to each data series in a chart.
🗑
|
||||
| Line chart | show 🗑
|
||||
| show | A chart type that shows each data point in proportion to the whole data series as a slice in a circle. A pie chart depicts only one data series.
🗑
|
||||
| show | The region of a chart containing the graphical representation of the values in the data series.
🗑
|
||||
| Radar chart | show 🗑
|
||||
| show | A series of faint dots on the outside border of a selected chart or object; enables the user to adjust the height and width of the chart or object.
🗑
|
||||
| show | A small line, column, or win/loss chart contained in a single cell to provide a simple visual illustrating one data series.
🗑
|
||||
| show | A chart type that places stacks of data in segments on top of each other in one column, with each category in the data series represented by a different color.
🗑
|
||||
| show | A chart type that shows fluctuations in stock changes, such as the high, low, and closing stock prices for a given company on a given day.
🗑
|
||||
| Surface chart | show 🗑
|
||||
| show | A line that depicts trends or helps forecast future data in a chart. For example, if the plotted data includes 2005, 2010, and 2015, a trendline can help forecast values for 2020 and beyond.
🗑
|
||||
| show | The chart element that displays incremental numbers to identify approximate values, such as dollars or units, of data points in a chart.
🗑
|
||||
| show | A chart type that shows a relationship between two variables using their X and Y coordinates. Excel plots one coordinate on the horizontal X-axis and the other variable on the vertical Y-axis. Used in educational, scientific, and medical experiments.
🗑
|
||||
| X-axis | show 🗑
|
||||
| Y-axis | show 🗑
|
||||
| Which type of chart is the least appropriate for depicting yearly rainfall totals fro five cities for four years? | show 🗑
|
||||
| What is the typical sequence fro creating a chart? | show 🗑
|
||||
| Which of the following applies to a sparkline? | show 🗑
|
||||
| If you want to show exact values for a data series in a bar chart, which chart element should you display? | show 🗑
|
||||
| The value axis currently shows increments such as 50,000 and 100,000. What do you select to display increments of 50 and 100? | show 🗑
|
||||
| show | 100% stacked column chart.
🗑
|
||||
| show | Click Switch Row/Column in the Data group on the Design tab.
🗑
|
||||
| Which tab contains commands to apply a predefined chart layout that controls which elements are included, where, and their color scheme? | show 🗑
|
||||
| Which icon does not display to the right of a selected chart? | show 🗑
|
||||
| show | A rectangle with a white fill color.
🗑
|
||||
| show | Clustered column chart
🗑
|
||||
| Miniature chart contained in a single cell. | show 🗑
|
||||
| Chart type that shows trends over time in which the value axis indicates quantities and the horizontal axis indicates time. | show 🗑
|
||||
| show | Chart title
🗑
|
||||
| Label that describes either the category axis or the value axis. | show 🗑
|
||||
| show | Legend
🗑
|
||||
| show | Bar chart
🗑
|
||||
| Chart that shows each data point in proportion to the whole data series. | show 🗑
|
||||
| Numeric value that describes a single value on a chart. | show 🗑
|
||||
| Chart that shows the high, low, and close prices for individual stocks over time. | show 🗑
|
||||
| Indicators that enable you to adjust the height and width of a selected chart. | show 🗑
|
||||
| Horizontal or vertical line that extends from the horizontal or vertical axis through the plot area. | show 🗑
|
||||
| show | X Y (scatter) chart
🗑
|
||||
| Group of related data points that display in row(s) or column(s) in a worksheet. | show 🗑
|
||||
| show | Task pane
🗑
|
||||
| show | Category axis
🗑
|
||||
| show | Plot area
🗑
|
||||
| show | Chart area
🗑
|
||||
| Descriptive label that shows the exact value of the data points on the value axis. | show 🗑
|
||||
| Displays incremental numbers to identify approximate values, such as dollars or units, of data points in a chart. | show 🗑
|
||||
| show | compares values for one set of data.
🗑
|
||||
| show | compares two or more sets of data in one chart
🗑
|
||||
| 3-D chart | show 🗑
|
||||
| Trendline | show 🗑
|
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:
TroyIS2241
Popular Computers sets