Term
|
Definition
| a block of cell in an Excel worksheet |
|
|
Term
|
Definition
| a block of adjacent cells in a worksheet |
|
|
Term
|
Definition
| cells in a worksheet that act as a block, but are not necessarily adjacent to each other |
|
|
Term
|
Definition
| to apply attributes to cell data to change the appearance of the worksheet |
|
|
Term
|
Definition
| a collection of coordinated fonts, colors, & effects for graphic elements such as charts & images that can be quickly applied to all sheets in a workbook |
|
|
Term
|
Definition
| the typeface or design of text |
|
|
Term
|
Definition
| a color that fills a cell, appearing behind the data |
|
|
Term
|
Definition
| a combination of a font, text color, cell color, & other font attributes applied to a single cell; are called Quick Styles in other Office programs |
|
|
Term
|
Definition
| the measurement of the typeface in points (1 point=1/72 of an inch) |
|
|
Term
|
Definition
| a format that controls how numerical data is displayed including the use of commas, dollar signs (or other symbols), & the number of decimals |
|
|
Term
|
Definition
| a style that vertically aligns with $'s, thousands separators, and decimal points |
|
|
Term
|
Definition
| a style that displays decimal numbers as a percentage |
|
|
Term
|
Definition
| a style that displays numbers with a thousands separator |
|
|
Term
|
Definition
| a style that displays $ immediately preceding the number & includes a thousands separator |
|
|
Term
|
Definition
| a feature of Windows that holds data or graphics that you have cut or copied & are ready to be pasted into any document |
|
|
Term
|
Definition
| dragging this handle, located in the lower-right corner of the active cell, will copy cell contents, formatting, or a formula to adjacent cells |
|
|
Term
|
Definition
| a button on the Home tab that allows you to copy formatting from a selected object or cell & apply it to another object or cell |
|
|
Term
|
Definition
| a cell address expressed in relation to the cell containing the formula; when such a formula is copied, this is adjusted to reflect the new location of the formula cell |
|
|
Term
|
Definition
| a cell address, such as E14 the relative cell references are adjusted to reflect the new location of the formula cell; such as $E$14, referenced in a formula that doesn't change based on the location of the cell containing the formula |
|
|
Term
|
Definition
| a feature used to display a document as it will appear when printed |
|
|
Term
|
Definition
| the command used to remove data from a cell or range of cells & place it on the clipboard |
|
|
Term
|
Definition
| the command used ot place data from the clipboard to a location on the worksheet |
|
|
Term
|
Definition
| a method used to move or copy the contents of a range of cells by dragging the border of a selection from 1 location in a worksheet & dropping it in another location |
|
|
Term
|
Definition
| worksheets that are selected as a unit; any action performed on this unit will affect all the worksheets in the group |
|
|
Term
|
Definition
| the selected worksheet; the tab name of this is bold |
|
|
