CIS4 Excel Chapter 3

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.

A value that originates in a worksheet cell and that is represented in a chart by a data marker is a data:

point

Pie chart

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

Axis

A line that serves as a frame of reference for measurement and that borders the chart plot area.

Chart sheet

A workbook sheet that contains only a chart.

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

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 is:

an enterprise fund

Value after increase = base × 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.

What-if analysis

The process of changing the values in cells to see how those changes affect the outcome of formulas in a worksheet.

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

base

The value in a chart's value axis that determines the spacing between tick marks and between the gridlines in the plot area is the:

major unit

Chart area

The entire chart and all of its elements.

A cell reference that refers to a cell by its fixed position in a worksheet is referred to as being:

absolute

Bevel

A shape effect that uses shading and shadows to make the edges of a shape appear to be curved or angled.

Formula AutoComplete

The Excel feature which, after typing = and the first letter of a function, displays a list of function names.

Category axis

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

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.

A pie slice is an example of:

a data marker

The action of pulling out a pie slice from a pie chart for emphasis is called:

explode

The percent by which one number increases over another number is the percentage rate of:

increase

A chart type that displays trends over time is a:

line chart

The y-axis is also known as the:

value axis

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

3-D

Goal Seek

A what-if analysis tool that finds the input needed in one cell to arrive at the desired result in another cell.

The x-axis is also known as the:

category axis

In a chart, each data point—bar, slice, and so on—has a unique:

color or pattern

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

series

Data marker

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

The area bounded by the axes of a chart, including all the data series, is the:

plot area