Shared Flashcard Set

Details

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

Additional Computer Science Flashcards

 


 

Cards

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
Adjacent ranges –
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
Cell address (cell reference) –
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
Column heading –
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
Nonadjacent ranges –
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
Row heading –
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!