# Shared Flashcard Set

## Details

Excel Vocab
Vocabulary terms for Excel
29
Computer Science
10/05/2010

Term
 Absolute reference –
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
 AutoFill –
Definition
 generates a series of values into adjacent cells, based on the value of other cells
Term
 AutoSum –
Definition
 a button that activates the SUM function automatically
Term
 Bar chart –
Definition
 looks like a column chart on its side (Category axis is vertical and Value axis is horizontal)
Term
 Category axis –
Definition
 chart labels that identify the category of data
Term
 Cell –
Definition
 a box that is the intersection of a column and row
Term
Definition
 the cell “name”, created by the intersection of the row number and the column letter
Term
 Chart –
Definition
 a graphic representation of data in a worksheet
Term
 Column –
Definition
 a vertical group of cells in a worksheet
Term
 Column chart –
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
 Conditional formatting –
Definition
 changes the appearance of a cell range based on a criteria
Term
 Fill handle –
Definition
 small, black square at the lower right corner of a selected cell
Term
 Formula –
Definition
 an equation that performs mathematical calculations on values
Term
 Function –
Definition
 Excel’s prewritten formulas, usually using abbreviations as the function name
Term
 Landscape orientation –
Definition
 a page layout that is wider than it is tall
Term
 Legend –
Definition
 identifies the patterns or colors that are displayed on a chart
Term
 Line chart –
Definition
 displays trends over time
Term
Definition
 ranges, or groups of cells, that are not next to each other
Term
 Pie chart –
Definition
 shows the relationship of each part to a whole. Usually shows data in percentages.
Term
 Relative reference –
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
 Row –
Definition
 a horizontal group of cells in a worksheet
Term
Definition
 a text label at the left of a row of data
Term
 Sheet tab –
Definition
 found at the bottom of the workbook that shows the name of the sheet
Term
 Value axis –
Definition
 chart labels that identify the numerical scale on which the data is based
Term
 Workbook –
Definition
 spreadsheet file that contains multiple worksheets
Term
 Worksheet –
Definition
 a primary document of uniformly spaced horizontal and vertical lines
Supporting users have an ad free experience!