Module 4 Excel Definitions

Question 1

100% stacked column chart

Answer 1

A column chart that places the data series values within combined columns showing what percentage is contributed by each series.

Question 2

axis title

Answer 2

Descriptive text that appears next to an axis

Question 3

bar chart

Answer 3

A column chart turned on its side so that the length of each bar is based on its value.

Question 4

category values

Answer 4

The groups or categories to which series values belong.

Question 5

chart

Answer 5

A visual representation of a set of data values; also called a graph.

Question 6

chart area

Answer 6

The chart and all of the other chart elements.

Question 7

chart design theory

Answer 7

Edward Tufte

Question 8

chart element

Answer 8

An individual part of a chart, such as the title or the legend.

Question 9

chart junk

Answer 9

a proliferation of chart elements—chosen because they look “nice”—confuse and distract the reader.

Question 10

chart legend

Answer 10

A box that identifies the data markers associated with each data series.

Question 11

chart subtype

Answer 11

A variation of a chart type

Question 12

chart title

Answer 12

A descriptive label or name for the chart.

Question 13

clustered column chart

Answer 13

A column chart that displays the data values in separate columns side by side.

Question 14

column chart

Answer 14

A chart that displays data values as columns with the height of each column based on its value.

Question 15

combination chart

Answer 15

A chart that combines two or more Excel chart types into a single graph.

Question 16

data bar

Answer 16

A conditional format that adds a horizontal bar to the background of a cell proportional in length to the cell’s value.

Question 17

data callout

Answer 17

A data label that appears as a callout bubble pointing to a data marker.

Question 18

data label

Answer 18

Text associated with an individual data marker.

Question 19

data marker

Answer 19

A graphical representation of a value in a chart, such as a column or pie slice.

Question 20

data series

Answer 20

The range that contains the values plotted on a chart.

Question 21

data source

Answer 21

The range that contains the data to display in a chart.

Question 22

data-ink ratio

Answer 22

the amount of “ink” used to display quantitative information compared to the total ink required by the chart. A high data-ink ratio with a minimum of extraneous elements and graphics is preferred.

Question 23

embedded chart

Answer 23

A chart object placed in a worksheet.

Question 24

Format pane

Answer 24

An area that provides a collection of commands to format the selected chart element.

Question 25

gap width

Answer 25

width between one category value and the next.

Question 26

graph

Answer 26

A visual representation of a set of data values; also called a chart.

Question 27

gridline

Answer 27

In a chart, a line that extends the value of a major or minor tick mark across the plot area.

Question 28

hierarchy chart

Answer 28

A chart that show the relative contribution of groups to a whole.

Question 29

honesty in charting

Answer 29

1. Improper Scaling; 2. Scaling data values differently; 3. Truncating the vertical axis; 4. 3-D distortions.

Question 30

horizontal axis

Answer 30

The axis that displays the category values from each data series.

Question 31

leader line

Answer 31

A line that connects a data label to its corresponding data marker.

Question 32

line chart

Answer 32

A chart that displays data values using a connected line rather than columns or bars.

Question 33

major tick marks

Answer 33

Lines that identify the main units on a chart axis.

Question 34

minor tick marks

Answer 34

Lines that identify the smaller intervals between major tick marks on a chart axis.

Question 35

pie chart

Answer 35

A chart in the shape of a circle divided into slices like a pie; shows data values as a percentage of the whole.

Question 36

plot area

Answer 36

The part of a chart that contains the graphical representation of the data series.

Question 37

PMT function

Answer 37

The financial function that calculates the payment schedule required to repay a loan.

Question 38

primary axis

Answer 38

The axis against which data series in a chart is plotted; usually appears along the left side of a chart.

Question 39

scale

Answer 39

In a chart, the range of values displayed on a chart axis.

Question 40

secondary axis

Answer 40

An alternate axis in a chart against which other data series with a different scale is plotted; usually appears on the right side of a chart.

Question 41

selection box

Answer 41

A box surrounding an object such as a chart that is used to move or resize the object.

Question 42

Series Overlap

Answer 42

overlap between two charts

Question 43

sizing handle

Answer 43

A square or dot on the edge of a selection box that is used to change the object’s width and height.

Question 44

sparkline

Answer 44

A chart that is displayed within a worksheet cell.

Question 45

stacked column chart

Answer 45

A column chart that places the data series values within combined columns showing how much is contributed by each series.

Question 46

tick marks

Answer 46

A line that divides the scale into regular intervals on a chart axis.

Question 47

vertical axis (value axis)

Answer 47

The axis that displays the values from the data series.