Excel Chap 3

A ____ is a value that originates in a worksheet cell and is represented in a chart.

A ____ shows the relationship of each part of the data to the whole.

A cell address used in a formula using a(n) ____ will be adjusted appropriately when the formula is copied to another cell.

A pie chart can only be based on one data series.

A pie chart must have a legend.

A pie chart must be limited to no more than seven categories.

A relative cell reference refers to a cell by its fixed position in the worksheet.

A workbook sheet that contains only a chart is called a(n):

A(n) ____ is a line that borders the chart plot area and serves as a frame of reference for measurement.

A(n) ____ refers to a cell by its fixed position in the worksheet.

Absolute cell references are indicated by placing the dollar sign ($) in front of the row and column indicators.

An image that appears to have length, width, and depth is said to be:

Applying the shape effect ____ causes the edges of a shape to appear to be curved or angled.

Each pie slice displayed on a pie chart is an example of a:

Excel displays various ____ on the right to enable you to format different chart elements.

Excel's ____ finds the input needed in one cell for another cell to have a desired value.

Goal seek is an example of a ____ tool.

If you want to chart trends over time, you should use a ____ chart.

In Excel, the ____ is made up of the chart and all its elements.

On a line chart, the y-axis is also known as the:

On a line chart, the range of numbers for the data points are displayed on the:

On a line chart, the area that identifies the categories of data is called the:

On a line chart, the x-axis is also know as the:

On a pie chart, the ____ determines the size of each pie slice.

One way to determine which slice of pie on a pie chart goes with which set of data is to look at the:

Percent for new value is calculated using this formula:

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.

The ____ identifies patterns and colors assigned to categories in the chart.

The ____ is the percent by which one number increases over another during a specified time frame.

The percentage rate of increase is calculated by using this formula:

The two background elements of an Excel chart are:

To ____ one or more slices on a pie chart means to pull the slice(s) away from the rest of the chart.

To gain a different view of a pie chart, you can ____ the chart within the 360 degrees of the circle.

To identify which slice of pie corresponds to which set of data points, look at the value axis.

Use the ____ button to add, remove, or change chart elements such as the chart title, the legend, and the data labels.

Value after increase is calculated by using this formula:

When a chart is selected, three buttons display to the right, the first of which is the ____ button.

When calculating the amount of increase, the ____ is the starting point for the data.

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?

Why would you explode a slice on a pie chart?