Excel Quiz Chapter 2

A graphic that compares and contrasts worksheet data in a visual format.

• Graph

• Table

• Smart Art

• Chart

Charts provide a way of presenting and comparing data in a graphical format.

You can create------

• Embedded Charts

• Chart Sheets

• Both

• Neither

A chart that occupies its own worksheet

• Embedded Chart

• Live Chart

• Chart Sheet

• Work Sheet

A chart placed as an object within a worksheet.

• Smart Chart

• Pivot Chart

• Embedded Chart

• Chart Sheet

The area that holds the data points on a chart

• Plot Area

• Hidden Properties Area

• Data Area

• Percent Area

All charts are linked to the charted data, which appears in the

• Data Chart

• Embedded Chart

• Plot Area

• Hidden Properties Area

A set of related data points to be charted.

• Data Series

• Percentage Series

• What If Analysis

• Pivot Table

On the chart shown here, each data series is represented on the chart by a different data marker. The legend at the right is a key that identifies the series by name.

Each kind of data for each item is a data point.

• True

• False

The horizontal scale of a chart on which categories are plotted, sometimes called the X axis.

• Horizontal Axis

• Vertical Axis

For each series in the example, there are three data points, as noted on the (X axis). These are the categories of data.

• Horizontal Axis

• Vertical Axis