Excel Chapter 3

Base

The starting point when you divide the amount of increase by it to calculate the rate of increase

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 and services

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, also referred to as the y-axis

Data Marker

A pie slice is an example of

Data Marker

A column, bar, area, dot, pie slice, or other symbol in a chart that represents a single data point

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

Chart Sheet

A workbook sheet that contains only a chart

Relative Reference Cell

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 in the formula

Category Axis

The area along the bottom of a chart the identifies the categories of data, also referred to as the x-axis

Plot Area

The area bounded by the axis of a chart, including all the data series

Absolute Reference

A cell reference that refers to a cell by its fixed position in a worksheet

3-D

The term that refers to an image that appears to have all three spatial dimensions

Pie Chart

A chart that shows the relationship of each part to a whole

Line chart

A chart type that displays trends over time Chart used to illustrate changes in data over time

Formula AutoComplete

The excel feature which, after typing - and the first letter of a function, displays a list of function names

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 the new value

Rate= Amount of Increase / Base

The mathematical formula to calculate a rate of increase

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

Major Unit

The value in a chart's value axis that determines the spacing between the guidelines in the plot area

Color of Pattern

In a chart, each data point- bar, slice, and so on- has a unique color or pattern

Series

Related data points represented by data markers are referred to as the data

Explode

The action of pulling out a pie slice from a pice chart for emphasis