| A | B |
|---|
| active cell | The cell currently selected in the active worksheet. |
| arithmetic operator | An operator that performs addition, subtraction, multiplication, division, or exponentiation. |
| AutoComplete | The feature that displays text that begins with the same letters as a previous entry in the same column to help make entering repetitive text easier. |
| AutoFit | The feature that changes the column width or row height to display longest or tallest entry within the column or row. |
| AutoSum | The button that inserts functions to sum, average, or count values in a range, or find the minimum or maximum value in a range. |
| Backstage view | The FILE tab of the ribbon, which provides access to various screens with commands that allow you to manage files and Excel options. |
| border | A line you can add along an edge of cell that prints. |
| cell | The intersection of a row and a column. |
| cell range (range) | A group of cells in a rectangular block. |
| cell reference | The column and row location that identifies a cell within a worksheet. |
| chart sheet | A sheet that contains only a chart that provides a visual representation of worksheet data. |
| clearing | To remove the data from a row or column but leaves the blank row or column in the worksheet. |
| column headings | The letters along the top of the worksheet window that identify the different columns in the worksheet. |
| delete | To remove the data from a row or column as well as the row or column itself. |
| Edit mode | The mode in which you can edit cell contents. |
| Flash Fill | The feature that enters text based on patterns it finds in the data. |
| formula | A mathematical expression that returns a value. |
| formula bar | The bar located below the ribbon that displays the value or formula entered in the active cell. |
| function | A named operation that replaces the action of an arithmetic expression in a formula. |
| Name box | The box located at the left side of the formula bar that displays the cell reference of the active cell. |
| nonadjacent range | A collection of separate ranges. |
| numeric data | Any number that can be used in a mathematical calculation. |
| operator | A mathematical symbol used in a formula to combine different values, resulting in a single value that is displayed within the cell. |
| order of operations | A set of predefined rules used to determine the sequence in which operators are applied in a calculation. |
| range reference | The cell reference of the upper-left cell in the range and the cell reference of the lower-right cell separated by a colon that identifies the range. |
| row headings | The numbers along the left side of the workbook window that identify the different rows of the worksheet. |
| scale | To change the size of the worksheet on the printed page. |
| sheet | A page included in a workbook; can be a worksheet or a chart sheet. |
| SUM | The function that adds values in a specified range. |
| syntax | A set of rules that specifies how a function should be written. |
| text data | Any combination of letters, numbers, and symbols. |
| workbook | An Excel file that stores a spreadsheet; contains a collection of worksheets and chart sheets. |
| worksheet | A grid of rows and columns in which content is entered. |
