| A | B |
|---|
| cut | the command used to remove data from a cell or range of cells and place it on the clipboard |
| paste | command used to place data from the clipboard to a location on the worksheet |
| clipboard | storage location in the computer's memory to hold cut or copied data until it is pasted in the worksheet |
| drag-and-drop feature | method to move or copy a range of cells by dragging the border of a selection from one location in a worksheet and dropping it in another |
| copy | command used to duplicate data from a cell or range of cells and place it on the clipboard in order to repeat it in another location |
| undo | command used to reverse one or a series of editing actions |
| paste special | editing feature used to control how data is inserted from the clipboard to the current file |
| paste options | attributes of the data that can be pasted |
| operation options | mathematical functions that can be applied to copied data |
| skip blanks | option that avoids replacing values in the paste area with blank cells from the copy area |
| transpose | option that pastes a column of data to a row or a row of data to a column in the current file |
| freeze | method to keep titles in view when scrolling through a worksheet |
| panes | worksheet sections that allow you to see different parts of the worksheet at one time |
| source | workbook that contains the data to be copied |
| destination | workbook that receives the copied data |
| extract | to copy formulas, values, or labels and paste them to a new location on the current worksheet, another worksheet, or another workbook |
| sheet tab | labels that appear at the bottom of the workbook window and display the names of the worksheets |
| tab split box | box that appears between the sheet tabs and horizontal scroll bar to control the number of sheet tabs displayed |
| tab scrolling buttons | buttons that appear next to the sheet tabs and scroll hidden sheet tabs into view |
| grouping | several selected worksheets |
| active sheet tab | selected workbook sheet name the appears in bold |
| range name | identification label assigned to a cell or group of cells |
| name box | text box located to the left of the formula bar |
| natural language labels | row and column titles on your worksheet that are automatically recognized as range names |
| operation | mathematical commands used when combining data with the Paste Special command |
| extract | to copy formulas, values, or labels and paste them to a new location on the current worksheet |
| copied cells | data copied to the clipboard |
| destination cells | new location to receive the pasted data |
| arrange | to display open windows in a preset pattern |
| link | reference in a dependent workbook to a cell or cells in the source workbook |
| source | workbook that contains the data being referenced |
| dependent | workbook that references the data source |
| external references | references to cells in other workbooks |
| 3D formula | an equation that references values across worksheets |
| 3D reference | reference to a value from any sheet or range of sheets used in a formula |
| copy sheet | to copy the entire worksheet, including the arrangement of the data |
| duplicate workbook window | an option that allows you to view an exact copy of the active workbook |
| OLE | object linking and embedding enables many Windows applications to share data |
| embed | method of inserting an object in a file that has no link to the source |
| Office links | Office links create a new embedded worksheet in a Word document |
