Excel chap 3
true
A pie chart can only be based on one data series.
true
A pie chart must be limited to no more than seven categories.
false
A pie chart must have a legend.
absolute cell reference
A(n) ____ refers to a cell by its fixed position in the worksheet.
true
Absolute cell references are indicated by placing the dollar sign ($) in front of the row and column indicators.
Goal Seek
Excel's ____ finds the input needed in one cell for another cell to have a desired value.
category axis
On a line chart, the x-axis is also know as the:
legend
One way to determine which slice of pie on a pie chart goes with which set of data is to look at the:
base + percent of increase
Percent for new value is calculated using this formula:
what-if-analysis
Performing a ____ involves changing the value in a cell to see what effect it has on values in other cells that are calculated using that value.
plot area and chart area
The two background elements of an Excel chart are:
explode
To ____ one or more slices on a pie chart means to pull the slice(s) away from the rest of the chart.
rotate
To gain a different view of a pie chart, you can ____ the chart within the 360 degrees of the circle.
False
To identify which slice of pie corresponds to which set of data points, look at the value axis.
chart elements
Use the ____ button to add, remove, or change chart elements such as the chart title, the legend, and the data labels.
base * percent for new value
Value after increase is calculated by using this formula:
data point
A ____ is a value that originates in a worksheet cell and is represented in a chart.
pie chart
A ____ shows the relationship of each part of the data to the whole.
chart sheet
A workbook sheet that contains only a chart is called a(n):
axis
A(n) ____ is a line that borders the chart plot area and serves as a frame of reference for measurement.
bevel
Applying the shape effect ____ causes the edges of a shape to appear to be curved or angled.
data marker
Each pie slice displayed on a pie chart is an example of a:
panes
Excel displays various ____ on the right to enable you to format different chart elements.
what-if-analysis
Goal seek is an example of a ____ tool.
line
If you want to chart trends over time, you should use a ____ chart.
chart area
In Excel, the ____ is made up of the chart and all its elements.
x-axis
On a line chart, the area that identifies the categories of data is called the:
y-axis
On a line chart, the range of numbers for the data points are displayed on the:
chart elements
When a chart is selected, three buttons display to the right, the first of which is the ____ button.
base
When calculating the amount of increase, the ____ is the starting point for the data.
legend
The ____ identifies patterns and colors assigned to categories in the chart.
relative cell reference
A cell address used in a formula using a(n) ____ will be adjusted appropriately when the formula is copied to another cell.
false
A relative cell reference refers to a cell by its fixed position in the worksheet.
3-D
An image that appears to have length, width, and depth is said to be:
value axis
On a line chart, the y-axis is also known as the:
data series
On a pie chart, the ____ determines the size of each pie slice.
pie chart
Which type of chart would be the best to chart the number of votes each candidate received compared to the total number of votes cast?
To emphasize the slice to the person viewing the chart
Why would you explode a slice on a pie chart?
percentage of rate increase
The ____ is the percent by which one number increases over another during a specified time frame.
amount of increase/base
The percentage rate of increase is calculated by using this formula: