click below
click below
Normal Size Small Size show me how
semester test
computers
| Question | Answer |
|---|---|
| Auto Fill | The feature that enables Excel to create a series automatically. |
| Date | A cell entry that indicates a date or time and is stored as a date code in Excell |
| Default column width | The default number of characters that display in a column based on the default font |
| Fill handle | A green box on the lower-right corner of the selected cell or range that you can use to fill (copy) a series of formula |
| Key Tips | Keyboard shortcuts for choosing ribbon commands that you display by pressing |
| Keyboard shortcuts | Specific keyboard keys that you press together or in sequence to execute commands or apply settings |
| Series | A list of sequential numbers, dates, times, or text |
| Wrap text | A feature that causes long cell entries to appear on multiple lines |
| 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 |
| Collapse Dialog button | A button in a dialog box that you click to downsize a dialog box to make a selection on the sheet. |
| Expand Dialog button | A button that you click to restore a dialog box to its normal size after using the collapse dialog button to make a selection on the sheet. |
| Range | A block of cells in an Excell worksheet |
| Arithmetic (mathematical) operators | symbols used in mathematical operations: + for addition, - for subtraction, *for multiplication, / for division, and ^ for exponentiation. |
| Formula | An instruction Excel uses to calculate a result. |
| Order of precedence | The order in which Excel preforms the mathematical operations specified in a formula, based on types of mathematical operators used. |
| SUM function | A built-in calculation used to add a range of values together. |
| Absolute reference | A cell address in a formula that will not change when you copy the formula to another location. Dollar signs indicate an absolute cell reference. |
| Clipboard | – A windows feature that holds data or graphics you cut or copy prior to pasting to another location. |
| Copy | The command used to place a copy of the data from the selected cell or range on the Clipboard. |
| Format Painter | a tool that enables you to copy formatting from a cell and apply it to another cell or range. |
| Paste | the command used to place data from the Clipboard to a location on the worksheet. |
| Relative reference | a cell address that can change in a copied formula, so the new address in expressed in relation to the cell containing the copied formula. For example, if you copied formula. For example, if you copy a relative reference to A5 one row down, it becomes A6 |