Excel 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

Guidlines for planing chart

Answer 2

Determine purposed, Determine results you want to see, Identify worksheet data you want to illustrate, Understands elements of a chart

Question 3

Pie chart

Answer 3

compares parts to the whole

Question 4

Line cart

Answer 4

shows trends over time

Question 5

Column

Answer 5

Compares distinct object levels using a vertical format

Question 6

Bar chart

Answer 6

Compared 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 measurements 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 locations dates and 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

inside of the 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 - wich is linked to the workbook

Question 25

Object

Answer 25

independent element on a worksheet

Question 26

Minor gridlines

Answer 26

show the values between the tick marks

Question 27

Text annotations

Answer 27

labels tat further describe your data

Question 28

Exploding

Answer 28

pulling a slice if pie away for emphasis