Excel Chapter 6 Quiz

A feature with which you can insert decorative text into your worksheet is:

WordArt

The area of a chart bounded by the axes.

plot area

Lines in the plot area of a chart that aid the eye in determining plotted values.

gridlines

A line that borders the chart plot area and serves as a frame of reference for measurement.

Axis

Lines in the plot area that aid in the eye in determining the plotted values.

Axis

A visual representation of numeric data in a worksheet is a:

Chart

Objects that make up a chart.

Chart elements

A separate worksheet used to display an entire chart.

Chart sheet

A workbook sheet that contains only a chart.

Chart sheet

A type of chart that shows comparisons among related data.

Column chart

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

Data point

A chart that is inserted into the same worksheet that contains the data used to create the chart.

Embedded Chart

A chart that is inserted into the same worksheet that contains the data used to create the chart.

Embedded chart

Column and row headings that describe the values and help the reader understand the chart.

Labels

This prevents anyone from altering the formulas or changing other template components.

Protection

An Excel feature that helps you choose a chart type by previewing suggested charts based on patterns in your data.

Recommended Charts

The Excel feature that suggests charts based upon your data.

Recommended Charts

A circle that displays on the top side of a selected object used to rotate the object up to 360 degrees.

Rotation handle

An Excel feature that provides a visual representation of your information and ideas.

SmartArt graphic

Tiny charts that fit within a cell and give a visual trend summary alongside data.

Sparklines

Tiny charts that fit within a cell and give a visual trend summary alongside your data.

Sparklines

A policy within an organization that all forms created within the organization will have a uniform appearance; the data will always be organized in the same manner.

Standardization

A special workbook that may include formatting, formulas, and other elements and is used as a pattern for creating other workbooks.

Template

A diagram that shows a continual process.

cycle

The graphic element that represents a single data point is a:

data marker

A group of related data points that are plotted in a chart.

data series

A diagram used to create an organization chart is a:

hierarchy

The column and row headings selected that describe the values in a chart.

labels

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

legend

Cells in a worksheet that cannot be edited are:

locked cells

The value that determines the spacing between the gridlines in the plot area of a chart.

major unit value

An optional element added to a template to prevent someone from disabling a worksheet's protection is a:

password

The process of locking cells in a workbook so that users cannot make any changes is:

protection

The range of numbers in the data series that controls the minimum, maximum, and incremental values on the value axis.

scale

A workbook used as a pattern for creating other workbooks.

template

A graphic representation of trends in a data series, such as a line sloping upward to represent increased sales over a period of months.

trendline

The numbers along the left side of a chart display on the:

vertical value axis

When you create a template, Excel adds the file extension:

xltx