Excel: Chapter 3
Text box
A movable resizable container for text or graphics
Value axis
A numerical scale on the left side of a chart that shows the range of numbers for the data points
Chart sheet
A workbook sheet that contains only a chart
Pie chart
A chart that shows the relationship of each part to a whole
Line chart
A chart type that is useful to display trends over time
Data marker
A column, bar, area, dot, pie slice, or other symbol in a chart that represents a single data point
WordArt
A gallery of text styles with which you can create decorative effects, such as shadowed or mirrored text
Axis
A line that serves as a frame of reference for measurement and which borders the chart plot area
Absolute cell reference
A cell reference that refers to cells by their fixed position in a worksheet
Bevel
A shape effect that uses shading and shadows to make the edges of a shape appear to be curved or angled
Fund
A sum of money set aside for a specific purpose
Data point
A value that originates in a worksheet cell and that is represented in a chart by a data marker
Goal Seek
A what-if analysis tool that finds the input needed in one cell to arrive at the desired result in another cell
Plot area
The area bounded by the axes of a chart, including all the data series
Chart Elements box
The box in the Chart Tools tabs from which you can select a chart element so that you can format it
Chart area
The entire chart and all of its elements
Order of operations
The mathematical rules for performing multiple calculations within a formula
What-if analysis
The process of changing the values in cells to see how those changes affect the outcome of formulas in a worksheet
Tick marks
The short lines that display on an axis at regular intervals
General fund
The term used to describe money set aside for the normal operating activities of a government entity such as a city
Major unit
The value in a chart's value axis that determines the spacing between tick marks and between gridlines in the plot area
Relative cell reference
the address of a cell based on the relative position of the cell that contains the formula and the cell referred to
Formula AutoComplete
An Excel feature which displays a list of function names that match the typed letters
Data series
Related data points represented by data markers
Format as you type
The Excel feature by which a cell takes on the formatting of the number typed into the cell
Explode
The action of pulling out one or more pie slices from a pie chart for emphasis
Category axis
The area along the bottom of a chart that identifies the categories of data
Legend
A chart element that identifies the patterns or colors that are assigned to the categories in the chart
