Quiz 8 - Excel Chapter 3

If you edit data in a worksheet that is associated with a pie chart ________.

the pie slices will be automatically updated

In a line chart, which of the following resides along the bottom of the chart?

x-axis

Only one piece of a pie can be exploded.

False

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

absolute cell reference

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

chart sheet

A ________ in a pie chart identifies the pie slices.

data label

A(n) ________ is a value in a worksheet cell that is represented in a chart by a data marker.

data point

A(n) ________ is a group of related data points represented by data markers.

data series

In a formula, a % sign designates that a cell in a formula is an absolute.

false

When you select the data range for a pie chart, you should be sure to include the total cell on the worksheet.

false

________ is an Excel tool that finds the input needed to arrive at a desired result.

goal seek

Which of the following displays trends over time?

line chart

In Goal Seek, you enter the specific value that you want to achieve in the ________ box.

to value

A pie chart should be considered when you have just one data series to plot.

true

The Chart Elements button allows you to add, remove, or change chart elements.

true

The order of data in the worksheet determines how the pie slices are ordered in a pie chart.

true

To what extent can a pie chart be rotated?

up to 360 degrees

The process of changing cells in a worksheet to see how those changes affect the outcome of formulas is known as ________.

what-if-analysis

Use the ________ key to select A5:A8 and D5:D8.

Ctrl

Which of the following is the first order of operations?

Expressions within parentheses

Which of the following is TRUE about a pie chart?

IT SHOWS THE RELATIONSHIP OF EACH PART TO A WHOLE.

How can you identify the Chart Elements button when you select a chart?

It is a green plus sign.

Where is the Format Painter button located?

ON THE MINI TOOLBAR AND THE HOME TAB

When you copy a formula to another cell and the cells in the formula change, the cells are known as relative cell references.

True

When you select two ranges on a worksheet to create a pie chart, there must be the same number of cells selected in each of the two ranges.

True