A | B |
3-D | The shortened term for three-dimensional, which refers to an image that appears to have all three spatial dimensions- length, width, and depth. |
Absolute Cell Reference | A cell reference that refers to cells by their fixed position in a worksheet; this remains the same when the formula is copied. |
Axis | A line that serves as a frame of reference for measurement and which borders the chart plot area. |
Base | The starting point; used in calculating the rate of increase, which is the amount of increase divided by the base. |
Bevel | A shape effect that uses shading and shadows to make the edges of a shape appear to be curved or angled. |
Category Axis | The area along the bottom of a chart that identifies the categories of data; also referred to as the x-axis. |
Chart Area | The entire chart and all of its elements. |
Enterprise fund | A municipal government fund that reports income and expenditures related to municipal services for which a fee is charged in exchange for goods or services. |
Chart Sheet | A workbook sheet that contains only a chart. |
Data Marker | A column, bar, area, dot, pie slice, or other symbol in a chart that represents a single data point; related data points form a data series. |
Data Point | A value that originates in a worksheet cell and that is represented in a chart by a data marker. |
Data Series | Related data points represented by data markers; each data series has a unique color or pattern represented in the chart legend. |
Explode | The action of pulling out one or more pie slices from a pie chart for emphasis. |
Google Docs | Google’s free, web-based word processor, spreadsheet, slide show, and form service, that along with free data storage, is known as Google Drive. |
Formula AutoComplete | An Excel feature which, after typing an equal sign and the beginning letter or letters of a function name, displays a list of functions names that match the typed letters. |
Fund | A sum of money set aside for a specific purpose. |
General Fund | The term used to describe money set aside for the normal operating activities of a government entity such as a city. |
Goal Seek | One of Excel's What-If Analysis tools that provides a method to find a specific value for a cell by adjusting the value of one other cell- find the right input when you know the result you want. |
Legend | A chart element that identifies the patterns or colors that are assigned to the categories in the chart. |
Line Chart | A chart type that is useful to display trends over time; time displays along the bottom axis and the data point values are connected with a line. |
Major Unit | A number that determines the spacing between tick marks and between the gridlines in the plot area. |
Order of Operations | The mathematical rules for performing multiple calculations within a formula. |
Percent for New Value= Base Percent + Percent of Increase | The formula for calculating a percentage by which a value increases by adding the base percentage- usually 100%- to the percent increase. |
Percentage Rate of Increase | The percent by which one number increase over another number. |
Pie chart | A chart that shows the relationship of each part to a whole. |
Plot Area | The area bounded by the axes of a chart, including all the data series. |
Rate = Amount of Increase/Base | The mathematical formula to calculate a rate of increase. |
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. |
Value After Increase = Base x Percent for New Value | The formula for calculating the value after an increase by multiplying the original value- the base- by the percent for new value. |
Value Axis | A numerical scale on the left side of a chart that shows the range of numbers for data point; also referred to as the y-axis. |
What-if Analysis | The process of changing the values in cells to see how those changes affect the outcome of formulas in a worksheet. |
X-Axis | Another name for the horizontal axis. |
Y-Axis | Another name for the vertical axis. |
Google Drive | Google’s free web-based word processor, spreadsheet, slide show, and form service, that includes free data storage. |