| A | B |
|---|
| Active Cell | A cell that is highlighted or outlined by a bold black line. |
| Value | Cell data classification used for cells that contain data that has potential to be used in calculations. |
| Cell | A box on the grid identified by the intersection of a column and a row. |
| Column | Cells that run from top to bottom on the grid and are identified by letters. |
| Command Tab | Task-oriented tabs that are organized on the Ribbon. |
| Command Group | Task-specific groups appropriate to the type of work the user is currently performing. |
| Dialog Box Launcher | An arrow in the lower-right corner of some command group headers in the Ribbon tabs |
| File Tab | Displays a menu of basic commands for opening, saving, and printing files as well as more advanced options |
| Help System | A system in Excel 2010 that is rich in information, illustrations, and tips that can help users complete any task as they create a worksheet and workbook. |
| HotKey | Another name for a Keytip. |
| Keytip | Small “badges” revealed by pressing and releasing the Alt key, which displays keyboard shortcuts for specific tabs and commands on the Ribbon and Quick Access Toolbar. |
| Name Box | Located below the Ribbon at the left end of the formula bar. When the user keys a cell location in this box and presses Enter, the cursor moves to that cell. |
| Quick Access Toolbar | A toolbar that permits fast and easy access to the tools a user employs most often in any given Excel session. |
| Ribbon | A broad band that runs across the top of the window that organizes tools from the Menu toolbar into an easy-to-use interface. |
| Row | Cells that run from left to right on the grid and are identified by numbers. |
| Screen Tip | Small onscreen windows that display descriptive text when users rest the pointer on a command or control. |
| Workbook | A spreadsheet file |
| Worksheet | Sheets similar to pages in a document or a book in which you can enter information |
| Absolute Cell Reference | A cell reference that does not change when copied because a dollar sign has been placed in front of both the column letter and row number, such as $A$5. |
| Average | A function that adds the values of the cells in a range and divides the result by the number of cells in the range. |
| Cell Reference | The column letter and row number used to identify a cell, such as B3. |
| Max | A function that displays the maximum value in a range of cells. |
| Count | A function that will return the number of cells in a range that contain values. |
| Min | A function that displays the smallest value in a range of cells. |
| Order of Operations | The order in which calculations will be performed by the software. |
| Parentheses | Used to control the order of operations that will be performed by the software. |
| Embedding | Used to integrate spreadsheet data with other software applications when you do not want the target data to update when the spreadsheet data is edited. |
| Fill Series | Used to fill a row or column with consecutive data, such as the days of the week, months, etc. |
| Relative Cell Reference | A cell reference that when copied reflects the row or column it has been copied to. |
| Formula | Instructs the software to perform a calculation. |
| Spreadsheet | An arrangement of cells in columns and rows used to organize, analyze, calculate, and report information, usually in numerical format. |
| Sum | A function that adds the values in a range of cells. |
| Label | Cell data classification used for cells that contain text or for numbers that will not be used in calculations. |
| Linking | Used to integrate spreadsheet data with other software applications when you want the target data to update anytime the spreadsheet data is edited. |
| Backstage | A view that enables you to easily navigate and customize different features that you frequently use in Excel. |
