click below
click below
Normal Size Small Size show me how
Lesson 2 Excel Vocab
Vocab
Term | Definition |
---|---|
Range | a block of cells in an Excel worksheet. |
Fill | a color that fills a cell, appearing behind the data |
Cell Styles | A combination of a font, text color, a cell color, and other font attributes applied to a single cell. Cell styles are called Quick styles in other office programs. |
Format | to apply attributes to cell data to change the appearance of the worksheet. |
number format | a format that controls how numerical data is displayed, including the use of commas, dollar signs (or other symbols), and the number of decimal places. |
account format | a style that vertically aligns with dollar signs thousand separators (,), and decimal points |
currency format | a style that displays dollar signs immediately preceding the number and includes a thousands separator |
percent format | a style that displays decimal numbers as a percentage. |
comma format | a style that displays numbers with a thousands separator (,) |
Fill Handle | Dragging this handle, located in the lower-right corner of the active cell, will copy cell contents, formatting, or a formula to adjacent cels. |
Relative cell reference | A cell address expressed in relation to the cell containing the formula. For example, rather than naming a specific cell in a formula, a relative cell reference might identify a cell three columns to the left of the cell containing the formula. |
absolute cell reference | a cell address, such as $E$14, reference in a formula that does not change based on the location of the cell that contains the formula. |
Clipboard | a feature of windows that holds data or graphics that you have cut or copied and are ready to be pasted into any document. |
Drag and drop feature | a method used to move or copy the contents of a range of cells by dragging the border of a selection from one location in a worksheet and dropping it in another location. |
Active sheet tab | the selected worksheet; the tab name of an active sheet is bold. |
contiguous range | a block of adjacent cells in a worksheet. |
noncontiguous range | cells in a worksheet that act as a block, but are not necessarily adjacent to each other |
print preview | a feature used to display a document as it will appear when printed. |