Chapter 3 Quiz, 18/20

A workbook sheet that contains only a chart.

Chart sheet

A value that originates in a worksheet cell and that is represented in a chart by a data marker.

Data point

A what-if analysis tool that finds the input needed in one cell to arrive at the desired result in another cell.

Goal Seek

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

Goal Seek

Which of the following is NOT one of the three spatial dimensions of 3-D?

Height

When you print a chart sheet, how is it automatically formatted?

It is centered on the page.

A chart element that identifies patterns or colors that are assigned to the categories in the chart.

Legend

A type of chart that displays trends over time.

Line

The command that moves a chart to a worksheet that contains only a chart and no other worksheet data.

Move Chart

A type of chart that shows the relationship of each part to a whole.

Pie

The area bounded by the axes of a chart, include all the data series.

Plot area

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

The x-axis

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

True

The plot area of a chart is bounded by the axes, including all the data series.

True

Wrong---> A chart sheet contains only a chart and the data used to generate that chart.

True So, it will be false

The numerical scale on the left side of a chart that shows the range of numbers for the data points.

Value axis

Wrong -----> The Paste option used to paste calculated values that result from the calculation of formulas along with the formatting applied to the copied cells.

Values & Data Formatting

A chart and all of its elements is known as the ________.

chart area

You must select ________ on a worksheet to create a pie chart.

two ranges

Which symbol represents that a cell is an absolute cell reference in a function or formula?

$