| A | B |
|---|
| Active cell | The selected cell displayed with a bold outline. Data can only be entered into an active cell. |
| Adjacent cells | Cells that are next to each other. |
| Argument | Data required by a function to perform calculations. |
| Arrow keys | Enters data and then selects the next cell in the direction of the arrow key. |
| AVERAGE | Function that adds the values of the cells in a range and divides the result by the number of cells in the range. |
| Boundary | The bar separating the column letters at the top of the worksheet. |
| Cell | The intersection of a row and column. Each cell can store a single item of data. |
| Cell reference | The column letter and row number used to identify a cell, such as B3. |
| Circular reference | An error that occurs when a formula references the cell it is stored in. |
| Column letter | Letter at the top of the worksheet used to identify individual columns. |
| Date | Data in the form of a calendar date. |
| Enter key | Enters data and then selects the next cell in the column. |
| Esc key | Cancels data entry and restores the original contents of the cell. |
| Excel | The spreadsheet application in Microsoft Office. |
| Fill handle | The solid square in the lower-right corner of a selected cell that is used to copy the contents of a cell to adjacent cells. |
| Formula | Mathematical statement used to calculate a value. A formula must always begin with an equal sign. For example, =C5+D7+E8 is a formula. |
| Formula bar | Area near the top of the worksheet window that displays the contents of the active cell. |
| Function | Performs a calculation that results in a single value. The formula =SUM(B3:B8) contains the SUM function. |
| Gridlines | Solid lines that mark off the rows and columns in a worksheet. |
| Insertion Point | A blinking vertical line that indicates where the next character typed will be placed. |
| Label | Text stored in a cell that cannot be used in calculations. |
| Name box | Located near the top of the worksheet window. Displays the cell reference of the active cell. |
| Order of operations | The rules Excel uses to evaluate a mathematical expression. |
| Pointing | Clicking a cell to place its reference in a formula. |
| Range | Selection of two or more cells. |
| Relative cell reference | A cell reference that when copied reflects the row or column it has been copied to. |
| ROUND | Function that changes a value by rounding it to a specific number of decimal places. |
| Row number | The number down the left side of the worksheet used to identify individual rows. |
| Scroll bars | Used to display rows and columns not currently visible in the worksheet. |
| Sheet tabs | Used to display the three worksheets in the workbook. |
| Spreadsheet | Data displayed in rows and columns. |
| SUM | Function that adds the values in a range of cells. |
| Tab key | Enters data and then selects the next cell in the row. |
| Time | Data in the form of a time (i.e., 12:30 PM). |
| Value | Numeric data that is stored in a cell that can be used in calculations. |
| Workbook | An Excel spreadsheet file. |
| Worksheet | Sheets in an Excel workbook used to present data in an organized format. |
| Align Left button | Formats the active cell as left aligned. Found on the toolbar. |
| Align Right button | Formats the active cell as right aligned. Found on the toolbar. |
| Auto Fill Options button | Displayed when the Fill handle is used to copy cell contents. |
| Bold button | Formats the active cell as bold. Found on the toolbar. |
| Cancel button | Cancels data entry and restores the original contents of the cell. Found on the Formula bar. |
| Cells command | Displays a dialog box with alignment, font, and number formatting options. Found in the Format menu. |
| Center button | Formats the active cell as center aligned. Found on the toolbar. |
| Close command | Closes a workbook. Found in the File menu. The Close button in the upper-right corner of the workbook can be used instead of the command. |
| Currency Style button | Applies the Accounting format to the active cell. Found on the toolbar. |
| Down command | Copies the cell contents into the selected cells of a column. Found in the Fill submenu in the Edit menu. |
| Edit in Formula Bar command | Places a formula on the Formula bar where it can be edited. Found in the list displayed by clicking the Trace Error button. |
| Enter button | Enters data in the active cell. Found on the Formula bar. |
| Exit command | Quits Excel. Found in the File menu. The Close button in the upper-right corner of the application window can be used instead of the command. |
| Font box | Displays a list of fonts to choose from. Found on the toolbar. |
| Font Size box | Displays a list of font sizes to choose from. Found on the toolbar. |
| Format Painter button | Copies cell formatting. Found on the toolbar. |
| Ignore Error command | Removes the Trace Error button and the triangle from the worksheet. Found in the list displayed by clicking the Trace Error button. |
| Italic button | Formats the active cell as italic. Found on the toolbar. |
| New Office Document command | Displays the New Office Document dialog box. Found in the Start menu. |
| Open Office Document command | Displays the Open Office Document dialog box. Found in the Start menu. |
| Open command | Displays a dialog box used to open an existing workbook. Found in the File menu. The Open button on the toolbar can be used instead of the command. |
| Page Setup command | Displays a dialog box with options for printing gridlines and row and column headings and creating a header or footer. Found in the File menu. |
| Percent Style button | Formats the active cell as percentage with no decimal places. Found on the toolbar. |
| Print command | Displays a dialog box used to print a worksheet. Found in the File menu. The Print button on the toolbar can be used instead of the command. |
| Print Preview command | Displays a worksheet as it will appear when printed. Found in the File menu. The Print Preview button on the toolbar can be used instead of the command. |
| Right command | Copies the cell contents into the selected cells of a row. Found in the Fill submenu in the Edit menu. |
| Save command | Saves a workbook. Found in the File menu. The Save button on the toolbar can be used instead of the command. |
| Trace Error button | Displays a list of options for correcting an error. Displayed when clicking a cell that contains an error. |
| Undo command | Restores the previous action. Found in the Edit menu. The Undo button on the toolbar can be used instead of the command. |
| Underline button | Formats the active cell as underlined. Found on the toolbar. |
