Excel Chapter 3
a
The starting point when you divide the amount of increase by it to calculate the rate of increase is the: a) base b) rate c) new value
c
The y-axis is also known as the: a) category axis b) base axis c) value axis
axis
A line that serves as a frame of reference for measurements and that borders that chart plot area.
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.
what-if analysis
The process of changing the values in cells to see how those changes affect the outcome of formulas in a worksheet.
a
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: a) an enterprise fund b) a general fund c) an accounting fund
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.
bevel
A shape effect that uses shading and shadows to make the edges of a shape appear to be curved or angled.
a
A value originates in a worksheet cell and that is represented in a chart by a data marker is a date: a) point b) cell c) axis
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.
a
The area bounded by the axes of a chart, including all the data series, is the: a) plot area b) axis area c) chart area
order of operations
The mathematical rules for performing multiple calculations within a formula.
c
The term that refers to an image that appears to have all three spatial dimensions is: a) explode b) bevel c) 3-D
a
A cell reference that refers to a cell by its fixed position in a worksheet is referred to as being: a) absolute b) relative c) mixed
pie chart
A chart that shows that relationship of each part to a whole.
c
A chart type that displays trends over time is a: a) column chart b) pie chart c) line chart
data marker
A column bar, area, dot, pie slice, or other symbol in a chart that represents a single data point.
c
A pie slice is an example of: a) a data point b) an axis c) a data marker
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.
b
Related data points represented by data markers are referred to as the data: a) slices b) series c) set
formula auto complete
The Excel feature which after typing = and the first letter of a function, displays a list of function names.
b
The action of pulling out a pie slice from a pie chart for emphasis is called: a) plot b) explode c) extract
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.
rate= amount of increase/base
The mathematical formula to calculate a rate of increase.
b
The percent by which one number increases over another number is the percentage rate of: a) decrease b) increase c) change
b
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: a) legend b) major unit c) fund value
c
The x-axis is also known as the: a) value axis b) data axis c) category axis
c
In a chart, each data point-bar, slice, and so on- has a unique: a) height b) axis c) color or pattern