Excel Chapter 3

Ace your homework & exams now with Quizwiz!

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


Related study sets

Ch. 15 How Humans Evolved Physical Anthropology

View Set

Texas Government - Chapter 7 : The Legislature

View Set

The Civil Constitution of the Clergy

View Set

Series vs Parallel Circuit Formulas

View Set