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