Unit D

Question 1

1. Charts

Answer 1

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

Question 2

2. Guidelines for planning a chart

Answer 2

• determine purpose
• determine the results you want to see
• Identify worksheet data you want to illustrate
• Understand elements of a chart

Question 3

3. Pie chart

Answer 3

Compares parts to a whole.

Question 4

4. Line chart

Answer 4

Shows trends over time.

Question 5

5. Column

Answer 5

compares to distinct object levels using a vertical format.

Question 6

6. Bar

Answer 6

compares distinct object levels using horizontal format.

Question 7

7. Area

Answer 7

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

Question 8

8. Scatter

Answer 8

compares trends over uneven time or measurement intervals.

Question 9

9. X-Axis

Answer 9

horizontal axis.

Question 10

10. Y-axis

Answer 10

vertical axis

Question 11

11. Category axis

Answer 11

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

Question 12

12. Value axis

Answer 12

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

Question 13

13. Z-Axis

Answer 13

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

Question 14

14. Plot area

Answer 14

area inside the horizontal and vertical axis.

Question 15

15. Tick marks

Answer 15

left edge of the vertical axis.

Question 16

16. Gridlines

Answer 16

extend across the plot area.

Question 17

17. Data point

Answer 17

each value selected in a cell.

Question 18

18. Data marker

Answer 18

visually represents each data point.

Question 19

19. Data series

Answer 19

collection of related data points.

Question 20

20. Legend

Answer 20

identify the data series.

Question 21

21. to create a chart in excel

Answer 21

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

Question 22

22. Embedded

Answer 22

means it is inserted directly in a current worksheet.

Question 23

23. Sizing handles

Answer 23

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

Question 24

24. Chart sheet

Answer 24

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

Question 25

25. Object

Answer 25

independent element on a worksheet.

Question 26

26. Minor gridlines

Answer 26

shows the values between the tick marks.

Question 27

27. Text annotations

Answer 27

labels that further describe your data.

Question 28

28. Exploding

Answer 28

pulling a slide of pie away for emphasis.