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