| A | B |
|---|
| chart | graphical representation and comparison of data found in a spreadsheet. |
| graphs | another name for charts. |
| pie chart | shows the relationship of a part to a whole by dividing a circle into several slices. |
| chart labels | words or phrases that identify parts of a chart. |
| slice | pie chart section. |
| legend | identifies patterns or symbols in spreadsheet |
| embedded chart | chart exists as an object in the worksheet. |
| chart sheet | chart exists on a separate sheet in workbook |
| bar chart | uses rectangles to illustrate values |
| column chart | same as vertical bar chart |
| axes | lines of reference in charts or graphs |
| X-axis | refers to horizontal scale in chart |
| Y-axis | represents vertical scale |
| line chart | ideal for illustrating trends over time |
| data point | its placement indicates a quantity or level measured on the y-axis |
| stacked bar chart | bars are divided into segments |
| data series | values the chart represents |
| series label | identifies the charted values and appear in the chart legend |
| category label | identify each data series shown on the horizontal or X-axis. |
| spreadsheet labels | generally text; left aligns by default |
| numeric labels | a number that is preceded by an apostrophe |
| values | numbers entered into spreadsheet; right aligned |
| math operators | symbols used in math operations (+,-,/,*) |
| PEMDAS | the order in which Excel performs calculations specified in a formula |
| =SUM | adds the values in a range of cells |
| =AVERAGE | returns the arithmetic mean of the values in a range of cells |
| =count | counts the cells containing numbers in a range of cells |
| =max | finds the highest value in a range of cells |
| =min | finds the lowest value in a range of cells |
| source | the workbook that contains the data to be copied or used |
| destination | the workbook that receives the copied data |
| IF statements | logical function which sets up a condition to test data. |
| Paste Function Button | used to view the list of function formulas available in Excel. |
