| A | B |
|---|
| Format | To apply attributes to cell data change the appearance of the worksheet. |
| Live View | A format that shows you how a gallery formatting choice will appear in the worksheet when you move the mouse pointer over that choice. |
| Merge and Center | A feature that enables you to automatically combine cells and center the contents of the original far left cell in the new cell. |
| 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 points. |
| Percent Format | A style that displays decimal numbers as a percentage. |
| Theme | A collection of coordinated fonts, colors, and effects for graphic elements, such as charts and image that can be quickly applied to all sheets in a workbook. |
| 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 Excel. |
| 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 Alt. |
| 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 acts as a block, but are not necessary adjacent to each other. |
| Collapse Dialog Button | A button that you click to restore a dialog box to it’s normal size after using the Collapse Dialog Button to make a selection on the sheet. |
| Range | A block of cells in an Excel worksheet. |
| Arithmetic (mathematical) Operator | 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 performs the mathematical operations specified in a formula, based on the 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 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 is expressed in relation to the cell containing the copied formula. For example if you copy a relative reference to A5 one row down, it becomes A6. |
| Cut | The command used to remove data from a cell or range of cells and place it on the clipboard. |
| Drag-and-Drop | A method used to move or copy the contents of s range of cells by dragging the border of a selection from one location in a worksheet and dropping it in another location. |
| Transpose | A method to rearrange data by switching the positions of columns and rows. |
| Orientation | The position for displaying and printing text either horizontally across the shorter side of the page, the default Portrait orientation, or along the wider side of the page, Landscape orientation. |
| Print Titles | Row and column labels that reprint on each page of a print out. |
| Scale | Adjust the size properly. |
| Show Formulas | A command that enables you to display the formulas in a worksheet so that you can check them. |
