| A | B |
|---|
| absolute cell reference | A reference to a specific cell or range of cells regardless of where the formula is located in the worksheet. Uses a dollar sign in front of the column and row markers in a cell address. |
| active cell | A cell that is highlighted or outlined by a bold black rectangle. This is also called the current or highlighted cell. |
| align | Arrange in a line or bring into alignment. |
| attribute | A formatting characteristic, such as bold, italic, or underlined text. |
| Auto Fill | An Excel feature that automatically fill cells with data, formatting, or both. |
| AutoComplete | An Excel feature that automatically enters the remaining characters of an entry when the first few typed characters match an entry made previously. |
| AVERAGE function | A function that calculates the arithmetic mean of the specified cell range. |
| Backstage view | A view that shows you behind-the-scenes options for managing files such as opening, saving, printing, and documenting files. |
| calculation operator | Operators that specify the calculations to be performed. |
| cell | A box on the grid identified by the intersection of a column and a row. |
| cell reference | A reference that identifies a cell’s location in the worksheet based on its row number and column letter. |
| column | Cells that run from top to bottom in a worksheet and are identified by letters. |
| column heading | The identifying letter of a column. |
| column width | The left-to-right measurement of a column. |
| command group | Task-specific groups divided among the command tabs appropriate to the work a user currently performs. |
| command tabs | Task-oriented tabs that are organized on the ribbon. |
| constant | A number or text value entered directly into a formula. |
| copy | To duplicate data from a worksheet to the Clipboard. |
| copy pointer | A mouse pointer, resembling an arrow with a plus sign, that allows users to drag a cell or range of cells to a new location. |
| Cut | To remove data from a worksheet. Cut data may be pasted into a new location or locations in a worksheet. |
| default settings | Pre-set settings that determine how Excel behaves when performing an action. |
| Dialog Box Launcher | An arrow in the lower, right corner of some command groups on the ribbon that opens a dialog box related to the command group. |
| external reference | A cell or range in a worksheet in another Excel workbook, or a defined name in another workbook. |
| FILE tab | In Office 2013, the tab that takes you to Backstage view to access Save, Print, Options, and other commands. |
| fill handle | A small square in the lower, right corner of a selected cell or range of cells. Used mainly to copy data to adjacent cells. |
| Flash Fill | A new feature in Excel that is similar to AutoFill. When Excel recognizes a pattern based on other information in your workbook, it uses the pattern to enter data into several cells at once. |
| font | A set of text properties that affects the typeface, size, and similar aspects of text. |
| footer | Lines of text that appear at the bottom of each page. |
| Formula | An equation that performs calculations, such as addition, subtraction, multiplication, and division, on values in a |
| formula bar | A bar located between the ribbon and the worksheet in which users can edit the contents of a cell. |
| freeze | To prevent portions of a worksheet from moving on the screen. When you freeze panes, such as a row of column headings, the column headings remain visible as you scroll down the worksheet or change magnification. |
| function | A predefined formula that performs a calculation. |
| group | Commands on the default ribbon tabs that are related in functionality. |
| grouping | Organizing data so it can be viewed as a collapsible and expandable outline. |
| handle | A small box on the side and/or corner of the graphic that you click and pull to increase or decrease the size of a graphic. |
| header | A line of text that appears at the top of each page of a printed worksheet. |
| Help system | A system in Excel that is rich in information, illustrations, and tips that can help you complete any task as you create worksheets and workbooks. |
| hotkey | Another name for KeyTip. |
| KeyTip | Small “badges” displaying keyboard shortcuts for specific tabs and commands on the ribbon and Quick Access Toolbar. Also referred to as hotkeys. |
| keyword | A word assigned to a document’s properties that makes it easier to organize and find documents. |
| label | Text entered in a worksheet that identifies numeric data and is the most common type of text entered in a worksheet. Labels are also used to sort and group data. |
| MAX function | A function that returns the largest value in a set of values. |
| MIN function | A function that determines the minimum value in a range of cells. |
| mixed cell reference | A cell reference that uses an absolute column or row reference, but not both. |
| move pointer | A mouse pointer that enables users to drag a cell or range of cells to a new location, replacing any existing data in the destination cells. |
| Name Box | Located below the ribbon at the left end of the formula bar. When a user types a cell location into this box and presses Enter, the insertion point moves to that cell. |
| named range | A group of cells, and occasionally a single cell, with a designated name. |
| natural series | A formatted series of text or numbers that are in a normal sequence such as months, weekdays, numbers, or times. |
| navigation pane | A pane found on the left side of Backstageview. It provides you access to workbook and file-related commands through a series of tabs. |
| operand | An element that identifies the values to be used in a calculation. |
| order of operations | The rules Excel follows to calculate any formula that contains two or more operators. |
| orientation | The position of the content in a worksheet, so that it prints either vertically or horizontally on a page. |
| Page Break Preview | An Excel view in which you can quickly adjust automatic page breaks to achieve a more desirable printed document. |
| paste | To insert data from the Clipboard to a new location in a worksheet. |
| print options | Several settings that enable you to change how a document prints. |
| Print Preview | An Excel view that enables you to see what your document will look like before sending it to the printer. |
| Quick Access Toolbar | A toolbar that gives you fast and easy access to the tools you use most often in Excel. |
| range | A group of adjacent cells you select to perform operations on all of the selected cells. |
| relative cell reference | A cell reference that adjusts the cell identifier automatically if you insert or delete columns or rows, or if you copy the formula to another cell. |
| ribbon | A broad band that runs across the top of the Excel window that organizes commands and tools into an easy-to-use interface. The ribbon was introduced in Office 2007. |
| row | A line of cells that start at the left edge of a worksheet, continue to the right, and are identified by numbers. |
| row heading | The identifying letter of a row. |
| row height | The top-to-bottom measurement of a row. |
| ScreenTip | A small, onscreen rectangle that displays descriptive text when you rest the pointer on a command or control. |
| selecting text | Highlighting text that is to be changed. |
| SUM function | A function that totals all of the cells in a range. |
| tab | An area on the ribbon that contains groups of related commands. See command tab. Or an area of the Backstage navigation pane that contains groups of related commands. |
| template | A file that includes formatting and formulas complete with designs, tools, and specific data types. |
| value | A number, a cell address, a date, text, or Boolean data in Excel. Regarding formulas, it is usually a number or cell address. |
| variable | A symbol or name that represents something else; it can be a cell address, a range of cells, and so on. |
| workbook | A collection of worksheets in a single file. |
| workbook properties | Items you directly change, such as keywords. |
| worksheet | A page in a workbook that consists of a grid of rows and columns in which you can enter text, values, and formulas, and perform calculations. |
| wrap | To automatically display data on the next line when it is too long to display within the cell’s width. Wrapping automatically increases a cell’s height. |
