Comp 242 Excel Chapter 6

locked cells

Cells in a worksheet that cannot be edited

value axis

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

protection

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

Scale

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

Sparklines

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

.xltx

When you create a template, Excel adds this file extension

Legend

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

Embedded chart

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

organization chart

A diagram that shows hierarchical relationships

WordArt

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

trendline

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

Data series

A group of related data points.

Chart sheet

A seperate worksheet used to display an entire chart.

Data point

A single value in a worksheet represented by a data marker in a chart.

Column chart

A type of chart that shows comparisons among related data.

Line chart

A type of chart that uses lines to show a trend over time.

chart

A visual representation of numeric data in a worksheet

SmartArt Graphic

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

text pane

An optional area in which you can type the text for a SmartArt graphic in a list format.

password

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

Gridlines

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

Chart elements

Objects that make up a chart.

category axis

The data along the bottom of a chart displays on the:

Chart area

The entire chart and all of its elements.

data marker

The graphic element that represents a single data point