click below
click below
Normal Size Small Size show me how
Rutiri-Sprdsht Les 8
Working with Charts
Term | Definition |
---|---|
Axis: | A line that establishes a relationship between data in a chart; most charts have a horizontal x-axis and a vertical y-axis (EX 190). |
Chart: | A graphical representation of data (EX 182). |
Chart area: | The entire chart and all other chart elements (EX 190). |
Chart layout: | Specifies which elements are included in a chart and where they are placed (EX 190). |
Chart sheet: | A separate sheet in the workbook that stores a chart (EX 186). |
Chart style: | Formats the chart based on the colors, fonts, and effects associated with the workbook’s theme (EX 191). |
Column chart: | Chart that uses bars of varying heights to illustrate values in a worksheet (EX 183). |
Data series: | A group of related information in a column or row of a worksheet that is plotted on the chart (EX 185). |
Data table: | A grid that displays the data plotted in the chart (EX 190) |
Embedded chart: | After you select a chart type and style, t he chart is inserted as an embedded chart in the center of the worksheet (EX 186). |
Exploded pie chart: | When you pull one or more slices away from the pie in a pie chart to distinguish them. (EX 193). |
Legend: | A list that identifies patterns, symbols, or colors used in a chart (EX 190). |
Line chart: | Chart that is similar to a column chart, but where columns are replaced by points connected by a line (EX 183). |
Pie chart: | Chart that shows the relationship of a part to a whole (EX 184). |
Sizing handles: | You resize a chart by dragging one of these (EX 186). |
False | The active cell reference appears in the Name Box. |
False | To select a group of cells, you must click each cell individually until all cells in the range are selected. |
False | The Save As dialog box appears every time you save a worksheet. |
True | After you edit the data source in the worksheet, the chart is also updated to reflect the changes. |
Merge and Center | Combines several cells into one and places the contents in the middle of the cell. |