click below
click below
Normal Size Small Size show me how
AR ADV SS UNIT 3
Arkansas Advanced Spreadsheets Unit 3-Working with Charts and Graphics
| Question | Answer |
|---|---|
| Bar chart | A column chart turned on its side so each bar length is based on its value |
| Category values | The group or category to which a series value belongs |
| Chart | graph that provides a visual representation for the workbook data |
| Chart area | The entire chart and all the elements contained in the chart or graph, such as the title and legend |
| Chart sheet | A new sheet that is automatically inserted into the workbook, occupies the entire document window, and provides more space and details for the chart |
| Chart title | Term that appears above the plot area and describes the contents of the plot area and the data series |
| Column chart | A type of chart that displays values in different categories as columns; the height of each column is based on its value |
| Combination chart | A chart that combines two or more chart types into a single graph |
| Data label | Text associated with a data value |
| Data marker | The graphical representation of the values in the data series of a chart, including items such as each column in a column chart, the pie slices in a pie chart, and the points used in a XY scatter chart |
| Data series | A range of data values that is plotted as a unit on the chart |
| Data source | Any file that contains the data you want to retrieve |
| Embedded chart | A chart that is displayed within a worksheet and one that you can place alongside the data source, giving context to the chart |
| Exploded pie chart | A chart with one slice moved away from the pie as if someone were taking the piece out of the pie |
| Graph | Another name for chart |
| Gridlines | A line that extends across the plot area indicating the location of tick marks on the chart's horizontal or vertical axes |
| Group | A collection of buttons for related commands; allows changes in one worksheet to affect other worksheets also; allows different shapes to be moved as one shape |
| Horizontal (category) axis | On this axis, or x-axis, are the data series' category values, or x values |
| Leader line | In a pie chart, a line that connects a data label outside of a pie slice to its corresponding label when space limitations force data labels far from its slice |
| Legend | A table on a chart listing and explaining the symbols used |
| Line chart | A chart that compares values from several categories with a sequential order, such as dates and times that occur at evenly-spaced intervals. The values are indicated by the height of the line. |
| Major tick mark | The indication of the major units of increment on the x- or y-axis |
| Perspective | The illusion that some parts of the 3-D chart are farther away from you than others |
| Pie chart | A chart in the shape of a circle that shows data values as percentage of the whole |
| Plot area | A rectangular area containing a graphical representation of the values in the data series |
| Primary value axis | The axis in a column chart that displays the primary values associated with the heights of each column |
| Resizing handle | A square or dot on a selecting box that lets you change an object's width and height |
| Scale | The range of values that spans along an axis |
| Secondary value axis | The axis in a column chart that displays the secondary values associated with the heights of each column |
| Series name | The name of the data series |
| Series values | The actual data displayed in a chart |
| Vertical (Value) Axis | The y-axis where, for example, data values, such as sales values, are plotted |
| XY scatter chart | A chart that shows the patterns or relationship between two or more sets of values |