Advertisement

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