Excel - Ch 3

Question 1

Visual representation of numerical data that compares data and reveals trends/patterns to help make informed decisions

Answer 1

Chart

Question 2

Cell containing a value

Answer 2

Data Point

Question 3

Group of related data points that display in rows/columns in the worksheet

Answer 3

Data Series

Question 4

Container for the entire chart and its elements

Answer 4

Chart Area

Question 5

Region containing the graphical representation of the values in the data series; two axes form a border around it

Answer 5

Plot Area

Question 6

Horizontal border for measuring data left to right

Answer 6

X-Axis

Question 7

Vertical border that provides reference for data up and down

Answer 7

Y-Axis

Question 8

Key that identifies colour/gradient/picture/texture/pattern designated to each data series in a chart

Answer 8

Legend

Question 9

Displays descriptive labels for data points

Answer 9

Category Axis

Question 10

Displays incremental numbers to identify approximate values

Answer 10

Value Axis

Question 11

Displays values in vertical columns where height represents value

Answer 11

Column Chart

Question 12

Displays values horizontally where length represents value

Answer 12

Bar Chart

Question 13

Displays data on horizontal axis and value on vertical axis

Answer 13

Line Chart

Question 14

Shows proportion of individual data points to the whole/total of all data points

Answer 14

Pie Chart

Question 15

Combines two chart types to plot different types of data

Answer 15

Combo Chart

Question 16

Contains commands for creating a variety of charts

Answer 16

Insert Tab

Question 17

Compares groups side by side (Column)

Answer 17

Clustered Column Chart

Question 18

Shows relationship of individual data points to the whole category; each is colour coded; comparing totals (Column)

Answer 18

Stacked Column Chart

Question 19

Shows relationship between 2 numerical variables using their X & Y coordinates; used for scientific experiments

Answer 19

XY Scatter Chart

Question 20

Created from moving a chart to a new sheet

Answer 20

Chart Sheet

Question 21

Component that completes / helps clarify the chart

Answer 21

Chart Element

Question 22

Describes the category / value axis (not displayed by default)

Answer 22

Axis Title

Question 23

Describes entire chart ; should reflect purpose of the chart

Answer 23

Chart Title

Question 24

Shows exact value or name of data point (not displayed by default)

Answer 24

Data Label

Question 25

Grid that contains data source values & labels (only add on a chart sheet)

Answer 25

Data Table

Question 26

Indicate standard error amount %, or standard deviation for data point or marker

Answer 26

Error Bars

Question 27

Horizontal or Vertical lines that display in the plot area to help identify values

Answer 27

Gridlines

Question 28

Depicts trends or helps forecast future data (estimation)

Answer 28

Trendline

Question 29

Window options to format & customize chart elements

Answer 29

Task Pane

Question 30

Slice of a Pie Chart that is moved away to stand out

Answer 30

Exploded Pie Chart

Question 31

Collection of formatting that controls colour of the chart area, plot area, data series

Answer 31

Chart Style

Question 32

Controls which data series & categories are visible in the chart

Answer 32

Chart Filter

Question 33

Small Line / Column / Win/Loss contained in a single cell; purpose is to present condensed, simple, succinct visual illustration of data; helps to understand data quickly without a full chart

Answer 33

Sparkline

Question 34

Types of Sparklines

Answer 34

Line
Column
Win/Loss