click below
click below
Normal Size Small Size show me how
Unit A Excel Vocab
| Term | Definition |
|---|---|
| Worksheet | A single sheet within a workbook file; also the entire area within an electronic spreadsheet that contains a grid of columns and rows |
| Workbook | Collection of related worksheets contained within a single file |
| Templates | A formatted document or sample file that contains placeholder text you can replace with your own text |
| Name Box | Box to the left of the formula bar that shows the cell reference or name of the active cell |
| Formula Bar | The area above the worksheet grid where you enter or edit data in the active cell |
| Cell | The intersection of a column and row in a worksheet, datasheet, or table |
| Cell Address | The location of a cell, expressed by cell coordinates; for example, the cell address of the cell in column A, row 1 is A1 |
| Cell Pointer | The dark rectangle that outlines the active cell |
| Active Cell | A selected cell in an Excel worksheet |
| Sheet Tabs | Identify the sheets in a workbook and let you switch between sheets; located below the worksheet grid |
| Status Bar | located at the bottom of the Excel window, provides a brief description of the active command or task in progress |
| Mode Indicator | An area on the left end of the status bar that indicates the program's status |
| Range | A selection of two or more cells, such as B5:B14 |
| Formula | A set of instructions used to perform one or more numeric calculations, such as adding, multiplying, or averging, on values |
| Labels | Entries that contain text and numerical information not used in calculations, such as ''2011 Sales'' or ''Travel Expenses'' |
| Values | Numbers, formulas, and functions that can be used in calculations |
| Function | Built-in formula; it includes the arguments as well as cell references and other unique information |
| Argument | The information necessary to calculate an answer |
| Formula Prefix | Formulas in an Excel worksheet with the equal sign |
| Calculation Operators | Indicate what type of calculation you want to perform on the cells, ranges, or values |
| Comparison Operators | Which compare values for the purpose of true/false results |
| Reference Operators | Enables you to use ranges in calculations |
| Enter Button | Check mark on formula bar |