Term
|
Definition
refers to a cell by a fixed position on the worksheet – this cell reference will remain constant, or absolute, when copying the formula
[image] |
|
|
Term
|
Definition
| ranges, or groups of cells, that are next to each other |
|
|
Term
|
Definition
| generates a series of values into adjacent cells, based on the value of other cells |
|
|
Term
|
Definition
| a button that activates the SUM function automatically |
|
|
Term
|
Definition
| looks like a column chart on its side (Category axis is vertical and Value axis is horizontal) |
|
|
Term
|
Definition
| chart labels that identify the category of data |
|
|
Term
|
Definition
| a box that is the intersection of a column and row |
|
|
Term
| Cell address (cell reference) – |
|
Definition
| the cell “name”, created by the intersection of the row number and the column letter |
|
|
Term
|
Definition
| a graphic representation of data in a worksheet |
|
|
Term
|
Definition
| a vertical group of cells in a worksheet |
|
|
Term
|
Definition
| chart type that is useful for illustrating comparisons among related numbers |
|
|
Term
|
Definition
| a text label at the top of a column of data |
|
|
Term
|
Definition
| changes the appearance of a cell range based on a criteria |
|
|
Term
|
Definition
| small, black square at the lower right corner of a selected cell |
|
|
Term
|
Definition
| an equation that performs mathematical calculations on values |
|
|
Term
|
Definition
| Excel’s prewritten formulas, usually using abbreviations as the function name |
|
|
Term
|
Definition
| a page layout that is wider than it is tall |
|
|
Term
|
Definition
| identifies the patterns or colors that are displayed on a chart |
|
|
Term
|
Definition
| displays trends over time |
|
|
Term
|
Definition
| ranges, or groups of cells, that are not next to each other |
|
|
Term
|
Definition
| shows the relationship of each part to a whole. Usually shows data in percentages. |
|
|
Term
|
Definition
| refers to a cell by their position relation to other cells in a formula – this cell reference will change, or adjust, when copying a formula |
|
|
Term
|
Definition
| a horizontal group of cells in a worksheet |
|
|
Term
|
Definition
| a text label at the left of a row of data |
|
|
Term
|
Definition
| found at the bottom of the workbook that shows the name of the sheet |
|
|
Term
|
Definition
| chart labels that identify the numerical scale on which the data is based |
|
|
Term
|
Definition
| spreadsheet file that contains multiple worksheets |
|
|
Term
|
Definition
| a primary document of uniformly spaced horizontal and vertical lines |
|
|
