unit d excel

Question 1

charts

Answer 1

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 a part to a whole

Question 4

line chart

Answer 4

shows trends over time

Question 5

column chart

Answer 5

compares distinct objects levels using vertical format

Question 6

bar

Answer 6

compares distinct object levels using horizontal format

Question 7

area

Answer 7

shows how individual volume changes overtime 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

contains names of data groups such as locations, months or years

Question 12

value axis

Answer 12

contains numerical values that help interpret size or chart elements

Question 13

z axis

Answer 13

contained in 3d charts for comparing data

Question 14

tick marks

Answer 14

on the left edge of vertical axis

Question 15

plot area

Answer 15

area inside horizontal and vertical axis

Question 16

gridlines

Answer 16

will extend across the plot 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

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

an independent element on a worksheet

Question 26

minor gridlines

Answer 26

shows values in-between the tick marks

Question 27

text annotations

Answer 27

labels that further describe your data