click below
click below
Normal Size Small Size show me how
Excel Lesson 1-3
Excel 2013 Lesson 1-3 Vocabulary
| Term | Definition |
|---|---|
| active cell | A cell that is highlighted or outlined by a bold black rectangle. This is also called the current or highlighted cell. |
| Backstage view | A view that shows you behind-the-scenes options for managing files such as opening, saving, printing, and documenting files. |
| cell | A box on the grid identified by the intersection of a column and a row.. |
| column | Cells that run from top to bottom in a worksheet and are identified by letters. |
| 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. |
| 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. |
| FILE tab | In Office 2016, the tab that takes you to Backstage view to access Save, Print, Options, and other commands. |
| 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. |
| Quick Access Toolbar | A toolbar that gives you fast and easy access to the tools you use most often in Excel. |
| 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. |
| ScreenTips | A small, onscreen rectangle that displays descriptive text when you rest the pointer on a command or control. |
| workbook | A collection of worksheets in a single file. |
| 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. |
| Auto Fill | An Excel feature that automatically fill cells with data, formatting, or both. |
| copy pointer | An arrow with a plus sign that appears when you select the cell or range of cells you want to copy and hold down Ctrl while you point to the border of the selection. When this pointer appears you can drag the cell or range of cells to the new location. |
| copy | To duplicate data from a worksheet to the Clipboard. |
| cut | To remove data from a worksheet. Cut data may be pasted into a new location or locations in a worksheet. |
| 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 tool identified with symbols such as dotted, dashed, or solid lines that fill the space before tabs. |
| formula bar | A bar located between the ribbon and the worksheet in which users can edit the contents of a cell. |
| 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. |
| 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. |
| Office Clipboard | A location that collects and stores up to 24 copied or cut items that are then available to be used in the active workbook, in other workbooks, and in other Office programs. |
| paste | To insert data from the Clipboard to a new location in a worksheet. |
| range | A group of adjacent cells you select to perform operations on all of the selected cells. |
| selecting text | Highlighting text that is to be changed. |
| workbook properties | Items you directly change, such as keywords. |
| default settings | Pre-set settings that determine how Excel behaves when performing an action. |
| group | Commands on the default ribbon tabs that are related in functionality. |
| navigation pane | A pane found on the left side of Backstage view. It provides you access to workbook and file-related commands through a series of tabs. |
| print options | Several settings that enable you to change how a document prints. |
| tab | (1) An area on the ribbon that contains groups of related commands. See command tab. (2) 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. |
| natural series | A formatted series of text or numbers that are in a normal sequence such as months, weekdays, numbers, or times. |