excel 3

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

Amount of Increase/Base

Percent for new value is calculated using this formula: ________.

Base Percent + Percent of Increase

Excel's ________ allows you to select a chart element so that you can format it.

Chart Elements box

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

Chart Sheet

One way to tell 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

The spacing between tick marks is determined by the ________.

Major Unit Value

Changing a value in a cell to see what effect it has on values in other cells that are calculated using the value is said to be doing a

What-if Analysis

Why would you explode a slice on a pie chart?

To emphasize the slice to the person viewing the chart.

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

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

Deleting the contents of a cell also removes the format that has been applied to the cell.

false

Excel's Number format leaves a space at the right of the number for a closing parenthesis in case the value is negative.

false

Exploding a slice of a pie chart causes it to completely disappear from the chart.

false

Graphics cannot be placed in a text box.

false

Once a pie chart is created, it cannot be rotated.

false

Page Layout view is available for chart sheets.

false

The order of operations used in Excel says that consecutive operators with the same level of precedence are done from right to left.

false

Time is displayed along the y-axis on a line chart.

false

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

false

You can select an element of a chart to format by using the Chart Elements box.

true

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

x-axis.

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

percentage rate of increase

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

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

A movable, resizable container where text or graphics can be placed is called a

text box.

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

true

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

absolute cell reference

According to Excel's order of operations, addition and subtraction are done before exponentiation.

false

By default, the plot area and the chart area are filled with different colors.

false

The AutoFill feature will continue a series based on the values placed in two or more consecutive cells.

true

The plot area and the chart area are the two background elements of an Excel chart.

true

The sizes of pie slices are automatically adjusted when the underlying data values are changed.

true

Under Paste Options you have the choice to paste the calculated values instead of the formulas.

true

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

3-D

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

Explode

________ are short lines that appear on an axis at regular intervals.

Tick marks

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

axis

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

data marker.

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

data point

A dotted border around an object indicates that the entire object is selected.

false

A line chart emphasizes the distinct values of each data point.

false

A pie chart must have a legend.

false

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

line

Formula AutoComplete displays the names of functions that begin with the letter or letters you have typed in after the =.

true

Goal Seek is an example of a what-if analysis tool.

true

A 3-D image appears to have length, width, and depth.

true

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

value axis.