Cis Chapter 4

Front 1

Active chart

Back 1

Created by Chart Wizard and indicated by selection handles,. The embedded chart is ready for additional formatting.

Front 2

Attached text

Back 2

Text that is attached to other elements of a chart, such as the chart title or axes titles, and is not linked to any cells in the worksheet.

Front 3

AutoShape

Back 3

Indicates the list of predefines shapes, such as squares, circles, flow chart objects, and block arrows, on the Drawing toolbar.

Front 4

Category values

Back 4

Data series’ x values, such as the names of items to be sold or in an inventory, on the horizontal axis, or x-axis.

Front 5

Chart

Back 5

Graphs that provide a visual representation of the workbook data

Front 6

Chart area

Back 6

The entire chart and all the elements contained in the chart or graph, such as the title and legend.

Front 7

Chart sheet

Back 7

A new sheet that is automatically inserted into the workbook, occupies the entire document window, and provides more space and details for the chart.

Front 8

Chart title

Back 8

Term that appears above the plot area and describes the contents of the plot area and the data series.

Front 9

Chart Wizard

Back 9

A series of dialog boxes that prompt you for information about the chart you want to create, such as the chart type, the cell range on which the chart is based, and features that the chart will contain.

Front 10

Data marker

Back 10

The graphical representation of the values in the data series of a chart, including items such as each column in a column chart, the pie slices in pie charts, and the points used in XY (scatter) charts.

Front 11

Data series

Back 11

Chart Wizard organizes data sources into a collection, where each data series is a range of data values that is plotted as a unit of the chart.

Front 12

Data source

Back 12

A stored set of information, often placed in a data base, a text file, or another Excel workbook, that you want to retrieve and use in a workbook.

Front 13

Data value

Back 13

Elements of a data series that are plotted on the chart’s vertical axis, or y-axis.

Front 14

Elevation

Back 14

The illusion that you’re looking at the 3-D chart from either above or below the chart.

Front 15

Embedded chart

Back 15

A chart that is displayed within a worksheet and one that you can place alongside the data source, giving context to the chart.

Front 16

Exploded pie chart

Back 16

A pie chart with one or more pie slices separated from the whole.

Front 17

Gridline

Back 17

A line that extends across the plot area indicating the location of tick marks on the chart’s horizontal or vertical axis.

Front 18

Horizontal axis

Back 18

On the horizontal axis, or x-axis, are the data series’ category values, or x values.

Front 19

Label text

Back 19

One of the three categories of chart text that includes the category names, the tick mark labels, and the legend text.

Front 20

Legend

Back 20

Used to identifying the format of the data marker used for each series in a chart. Used if the chart contains more than one data series.

Front 21

Major gridline

Back 21

Lines that extend the tick marks across the plot area.

Front 22

Major tick mark

Back 22

The indication on the major units of increment on the x- or y-axis.

Front 23

Minor gridline

Back 23

The lines that divide the space between the major gridlines.

Front 24

Minor tick mark

Back 24

The indication of the minor units of increment on the x- or y-axis.

Front 25

Object

Back 25

An element of a custom application, such as a worksheet, macro, or workbook.

Front 26

Perspective

Back 26

The illusion that some parts of the 3-D chart are farther away from you than others.

Front 27

Plot area

Back 27

A rectangular area containing a graphical representation of the values in the data series.

Front 28

Scale

Back 28

The range of values that spans along an axis.

Front 29

Tick mark

Back 29

Next to the values on the scales, it acts like the division line on a ruler.

Front 30

Unattached text

Back 30

Unattached text is additional text that is unassociated with any particular element of the chart.

Front 31

X-axis

Back 31

The horizontal axis, where for example the data series’ category values or x values, such as the names of the different telescope models, are plotted.

Front 32

X value

Back 32

The data series’ values, such as the sale values, are plotted on the horizontal axis, or x-axis.

Front 33

Y-axis

Back 33

The vertical axis, where, for example, data values, such as the sales values, are plotted.