click below
click below
Normal Size Small Size show me how
MHS BITA Lesson 3
Lesson 3 and 4 Excel Vocabulary
| Question | Answer |
|---|---|
| Automatic page break | a page break excel inserts whenever it runs out of room on a page |
| Copy | to place a copy of selected text on the clipboard |
| Cut | to remove selected text and place it on the clipboard |
| Fill | to copy a cell’s contents and/or formatting into an adjacent cell or range |
| Fill handle | the black square in the lower-right corner of the active cell or range that you drag over the cells you want to fill |
| Footer | text that is printed at the bottom of each page |
| Freeze pane | to keep selected rows and/or columns of the worksheet visible on the screen as the rest of the worksheet scrolls |
| Header | text that is printed at the top of each page |
| Landscape orientation | a page or worksheet rotated so it is wider than it is long |
| Manual page break | a page break you insert to start a new page |
| Margins | blank spaces around the top, bottom, and sides of page |
| Normal view | the worksheet view best for entering and formatting data in a worksheet |
| Office Clipboard | a temporary storage area for up to 24 selections you copy or cut |
| Page Break Preview | the worksheet view for adjusting page breaks in a worksheet |
| Page Layout view | the worksheet view for adjusting page breaks in a worksheet |
| Paste | to copy an item stored on the clipboard to a location in a file |
| Portrait orientation | a page or worksheet rotated so it is longer than it is wide |
| Print area | the cells and ranges designated for printing |
| Print title | designated rows and/or columns in a worksheet that print on each page |
| Scale | to resize a worksheet to print on a specific number of pages |
| Split | to divide the work area into two or four panes that scroll independently |
| Absolute cell reference | a cell reference that does not change when copied or moved to a new cell. |
| Formula | an equation that calculates a new value from values currently in a worksheet. |
| Manual calculation | the option that lets you determine when Excel calculates formulas in the worksheet. |
| Mixed cell reference | a cell reference that contains both relative and absolute references. |
| Operand | a number or cell reference used in a formula. |
| Operator | a symbol that indicates what mathematical operation to perform on the operands. |
| Order of evaluation | the sequence used to calculate the value of a formula. |
| Sum button | a button on the Ribbon that inserts the SUM function to add long columns or rows of numbers. |
| Relative cell reference | a cell reference that adjusts to its new location when copied or moved. |
| Point-and-click method | in a formula, to click a cell rather than type its cell reference. |