unit d

Question 1

charts

Answer 1

(graphs) present information in a pictorial format, making it easier to see patterns, trends, and relationships.

Question 2

guidelines for planning a chart

Answer 2

*determine purpose
*determine results you want to see
*identify worksheet data you want to illustrate
*understand elements of a chart

Question 3

pie chart

Answer 3

compares parts to the whole

Question 4

line chart

Answer 4

shows trends over time

Question 5

column

Answer 5

compares distinct object levels using a vertical format

Question 6

bar

Answer 6

compares distinct object levels using a horizontal format

Question 7

area

Answer 7

shows how individual volume changes over time in relation to total volume

Question 8

scatter

Answer 8

compares trends over uneven time or measurement intervals

Question 9

x-axis

Answer 9

horizontal axis

Question 10

Y axis

Answer 10

vertical axis

Question 11

category axis

Answer 11

(horizontal axis) contains names of data groups such as locations, months or years

Question 12

value axis

Answer 12

(vertical) contains numerical values that help interpret size of chart elements

Question 13

z-axis

Answer 13

contained in 3-D charts for comparing data across both categories and values

Question 14

plot area

Answer 14

are inside the horizontal and vertical axis

Question 15

tick marks

Answer 15

left edge of the vertical axis

Question 16

gridlines

Answer 16

extend across the plot area

Question 17

data point

Answer 17

each value selected in a cell

Question 18

data marker

Answer 18

visually represents each data point

Question 19

data series

Answer 19

collection of related data points

Question 20

legend

Answer 20

identifies the data series

Question 21

**to create a chart in excel

Answer 21

you must first make a spreadsheet – then click insert, chart**

Question 22

embedded

Answer 22

means it is inserted directly in a current worksheet

Question 23

sizing handles

Answer 23

small series of dots at the corners and sides of the chart’s border –

Question 24

chart sheet

Answer 24

sheet in a workbook that contains only a chart – which is linked to the workbook data

Question 25

object

Answer 25

independent element on a worksheet

Question 26

minor gridlines

Answer 26

show the value between the tick marks

Question 27

text annotations

Answer 27

labels that further describe your data

Question 28

exploding

Answer 28

pulling a slice of pie away for emphasis