Excel ch. 3
absolute
a cell reference that refers to a cell by its fixed position in a worksheet
line chart
a chart that displays rends over time
pie chart
a chart that shows the relationshp of each part to a whole
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
axis
a line that serves as a frame of reference for measurement and that borders the chart plot area.
value axis
a numerical scale on the left side of a chart that shows the range of numbers for the data points; y-axis
Bevel
a shape effect that uses shading and shadwos to make the edges of a shape appear to be curved or angled
fund
a sum of money set aside for a specific purpose
point
a value that originates ina worksheet cell and that is represented ina chart by a data marker
chart sheet
a workbook sheet that contains only a chartt
the x-axis is also known as:
category axis
relative cell reference
in a formula, the address of a cell based on the relative position of the cell that contains the formula and the cell referred to.
what-if analysis
process of changing the values in cells to see how those changes affect the outcome of formulas in a worksheet
series
related data poitns represendted by data markers
explode
the action of pulling our a pie slice
category axis
the area along the bottom of a chart that identifies the categories of data; x-axis
plot area
the area bounded by the axes of a chart, including all the data series
chart area
the entire chart and all of tis elements.
format as you type
the excel feature by which a cell takes on the formatting of the number typed into the cell
rate= amount of increase/base
the mathematical formula to calculate a rate of increase
order of operations
the mathemeatical rules for performing multiple calculations within a formula
increase
the percenty by which one number increases over another is the percentage rate of _____.
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