Excel Chapter 3: End-of-Chapter Quiz
Already Graded A
Pie Chart ✔✔A chart that shows the relationship of each part to a whole
Goal Seek ✔✔A what-if analysis tool that finds the input needed in one cell to arrive at th
...
Excel Chapter 3: End-of-Chapter Quiz
Already Graded A
Pie Chart ✔✔A chart that shows the relationship of each part to a whole
Goal Seek ✔✔A what-if analysis tool that finds the input needed in one cell to arrive at the
desired result in another cell
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
Data Marker ✔✔A column, bar, area, dot, pie slice, or other symbol in a chart that represents a
single data point
Chart sheet ✔✔A workbook sheet that contains only a chart
Bevel ✔✔A shape effect that uses shading and shadows to make the edges of a shape appear to
be curved or angled
Chart area ✔✔The entire chart and all of its elements
What-if analysis ✔✔The process of changing the values in cells to see how those changes affect
the outcome of formulas in a worksheet
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
Formula AutoComplete ✔✔The Excel feature which, after typing = and the first letter of a
function, displays a list of function names
Axis ✔✔A line that serves as a frame of reference for measurement and that borders the chart
plot area
Category axis ✔✔The area along the bottom of a chart that identifies the categories of data; also
referred to as the x-axis
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
Value after increase ✔✔The formula for calculating the value after an increase by multiplying
the original value-the base-by the percent for new value
An 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 or services
Absolute ✔✔A cell reference that refers to a cell by its fixed position in a worksheet is
Point ✔✔A value that originates in a worksheet cell and that is represented in a chart by a data
marker is a..
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 pie chart
Major unit ✔✔The value in a chart's value axis that determines the spacing between the gridlines
in the plot area is the..
Increase ✔✔The percent by which one number increases over another number is the percentage
rate of..
Line chart ✔✔A chart type that displays trends over time is a...
Plot area ✔✔The area bounded by the axes of a chart, including all the data series, is the..
Category axis (2) ✔✔The x-axis is also known as the..
3-D ✔✔The term that refers to an image that appears to have all three spatial dimensions is..
Value axis (2) ✔✔The y-axis is also known as the..
Color or pattern ✔✔In a chart, each data point-bar, slice, and so on- has a unique..
Base ✔✔The starting point when you divide the amount of increase by it to calculate the rate of
increase is the..
A data marker ✔✔A pie slice is an example of..
[Show More]
