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

true

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

false

###
A pie chart must have a legend.

false

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

false

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

true

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

Base Percent + Percent of Increase

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

value axis.

###
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

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

Amount of Increase/Base

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

true

###
Graphics cannot be placed in a text box.

false

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

Chart Sheet

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

category axis.

###
The spacing between tick marks is determined by the ________.

Major Unit Value

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

percentage rate of increase

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

false

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

Tick marks

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

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

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

line

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

Legend

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

false

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

false

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

data point

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

chart area

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

axis

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

x-axis.

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

3-D

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

false

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

absolute cell reference

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

true

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

Chart Elements box

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

false

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

Explode

###
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 pie chart should be limited to no more than seven categories.

true

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

false

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

true

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

data marker.

###
Why would you explode a slice on a pie chart?

To emphasize the slice to the person viewing the chart.

###
Value after increase is calculated by using this formula: ________.

base * percent for new value

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

true

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

Legend

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

base

###
Page Layout view is available for chart sheets.

false

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

true

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

true

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

false

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

text box.

###
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

### Please allow access to your computer’s microphone to use Voice Recording.

## We can’t access your microphone!

### Click the icon above to update your browser permissions above and try again

Example:

### Reload the page to try again!

Reload

## Press Cmd-0 to reset your zoom

## Press Ctrl-0 to reset your zoom

### It looks like your browser might be zoomed in or out. Your browser needs to be zoomed to a normal size to record audio.

## Your microphone is muted

### For help fixing this issue, see this FAQ.