Information Processing Excel Study Guide--Lesson 6--Charts
Name:____________________________________________
Date of Test:______________________________

Study the following vocab words for an on-line test. Lesson 6-Charts.
1. CHARTS--present and compare data in a graphic format
2. NONADJACENT SELECTION�use when data is not contiguous
3. SERIES LABELS�identify the charted values and appear in the chart legend
4. LEGEND--shows the color and name of the charted values
5. Y=AXIS OR VALUE AXIS�typically represents the vertical scale which are entered automatically by Excel
6. X=AXIS OR CATEGORY AXIS--typically represents the horizontal scale and the data series categories
7. CATEGORY LABELS�identify each value in the data series as shown on the horizontal or x-axis
8. DATA SERIES�groups of values identified by a label
9. CHART WIZARD�makes charts easy by providing step-by-step instructions
10. EMBEDDED CHART�-an object on your worksheet
11. CHART SHEET�chart which exists on a separate sheet within the workbook
12. COLUMN CHART�compares individual or sets of values
13. LINE CHART--is like a column chart because it compares individual sets of values, but lines connect the points of data.
14. PIE CHART--a circular graph used to show the relationship of each value in a data range to the entire range
15. ORIENTATION--Excel automatically determines whether the chart plots the selected data range by row or by column layout
16. COMBINATION CHART--a custom chart that plots each data series as a different chart type
17. GRAPHICS--graphical images that can be either drawing objects or pictures
18. AUTOSHAPES--predefined graphical images that can be placed and sized
Hosted by www.Geocities.ws

1