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