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 |