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 vertical format

Question 6

Bar

Answer 6

distinct object levels using a horizontal format

Question 7

Area chart

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) contains names of data groups such as location, monthsm or years

Question 12

Value Axis

Answer 12

(vertical) contains numerical values intercept 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

area inside the horizontiak and vertical axis

Question 15

tick marks

Answer 15

left edge of the vertical axis

Question 16

grid lines

Answer 16

extend across the plot line area

Question 17

Data point

Answer 17

each value point 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 point

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

Embeded

Answer 22

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 charts border

Question 24

chart sheet

Answer 24

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

Question 25

Object

Answer 25

independent element in a wrksheet

Question 26

Monir Gridlines

Answer 26

shows the values between the tick marks

Question 27

text annotations

Answer 27

labels that further describe your data