Chapter 6 Excel Vocabulary
picture
A category of SmartArt graphics that is used to display pictures in a diagram.
relationship
A category of SmartArt graphics that is used to illustrate connections.
process
A category of SmartArt graphics that is used to show steps in a process or timeline.
list
A category of SmartArt graphics used to show non-sequential information
data marker
A column, bar, area, dot, pie slice, or other symbol in a chart that represents a single data point;
chart sheet
A workbook sheet that contains only a chart.
recommended charts
An Excel feature that helps you choose a chart type by previewing suggested charts based upon patterns in your data.
password
An optional element of a template added to prevent someone from disabling a worksheet's protection.
tick mark labels
Identifying information for a tick mark generated from the cells on the worksheet used to create the chart.
locked [cells]
In a protected worksheet, data cannot be inserted, modified, deleted, or formatted in these cells.
data series
Related data points represented by data markers
data labels
Series name, Category name, Value, or Percentage.
chart elements
Objects that make up a chart.
scale
The range of numbers in the data series
tick mark
The short lines that display on an axis at regular intervals.
sparklines
Tiny charts that fit within a cell and give a visual trend summary alongside data.
chart area
The entire chart and all of its elements
trendline
A graphic representation of trends in a data series, such as a line sloping upward to represent increased sales over a period of months.
organization chart
A type of graphic that is useful to depict reporting relationships within an organization.
plot area
The area bounded by the axes of a chart, including all the data series.
walls and floor
The areas surrounding a 3-D chart that give dimension and boundaries to the chart.
category labels
The labels that display along the bottom of a chart to identify the categories of data
text pane
The pane that displays to the left of the graphic, is populated with placeholder text, and is used to build a graphic by entering and editing text.
pyramid
A category of SmartArt graphics that uses a series of pictures to show relationships.
hierarchy
A category of SmartArt graphics used to create an organization chart or show a decision tree.
unlocked [cells]
Cells in a protected worksheet that may be filled in.
labels
Column and row headings that describe the values and help the reader understand the chart.
gridlines
Lines in the plot area that aid the eye in determining the plotted values.
matrix
A category of SmartArt graphics used to show how parts relate to a whole.
legend
A chart element that identifies the patterns or colors that are assigned to the categories in the chart.
column chart
A chart in which the data is arranged in columns
embedded chart
A chart that is inserted into the same worksheet that contains the data used to create the chart.
line charts
A chart type that is useful to display trends over time
rotation handle
A circle that displays on the top side of a selected object used to rotate the object up to 360 degrees.
wordart
A feature with which you can insert decorative text in your document.
axis
A line that serves as a frame of reference for measurement and that borders the chart plot area
major unit value
A number that determines the spacing between tick marks and between the gridlines in the plot area.
template
A special workbook which may include formatting, formulas, and other elements
data point
A value that originates in a worksheet cell and that is represented in a chart by a data marker.
smartart graphic
A visual representation of information and ideas.
standardization
All forms created within the organization will have a uniform appearance
protection
This prevents anyone from altering the formulas or changing other template components.
