| A | B |
|---|
| Spreadsheet | Tool used in business for budgeting, inventory management, and decision making for analyzing and reporting information. |
| Active workbook | Workbook currently in use |
| Sheets | A page on excel |
| Worksheet | Sheet containing formulas, functions, values, texts, and graphics |
| Chart sheet | New sheet that is automatically inserted into the workbook, occupies the entire document window, and provides more space and details for the chart |
| Sheet tabs | The area at the bottom of a worksheet that identifies the worksheet, clicking it makes the sheet active |
| Active sheet | Worksheet currently displayed in workbook window |
| Row heading | In Excel, the part of a worksheet that identifies each row by a different number. |
| Column heading | Part of a worksheet that identifies each column by a different letter |
| Cell | Intersection of a row and column in a table or worksheet |
| Excel | Spreadsheet program used to display, organize, and analyze numerical data. |
| Cell reference | Address of a cell indicating column and row location. |
| Active cell | Selected cell in the worksheet, indicated with a dark border |
| Name box | Box located on the far left of a formula bar in which the cell reference to the active cell is also displayed |
| Formula bar | Bar above the workbook window in which the contents of a cell are displayed |
| Text data | Combination of letters, numbers, and some symbols |
| Number data | Numerical value that can be used a mathematical calculation |
| Autofitting | To eliminate empty space by matching the column width to the longest cell entry or row height to the tallest cell entry. |
| Cell range | Group of worksheet cells which can be adjacent or nonadjacent |
| Adjacent range | Single rectangular block that include a group of contiguous cells |
| Nonadjacent range | Cell range comprised of two or more separate adjacent ranges |
| Drag and drop | To move an item by selecting it and dragging it with the mouse |
| Formula | Mathematical expression that calculates a value, all Excel formulas always begin with an equal sign followed by an expression that describes the calculation to be done |
| Arithmetic operators | Symbol such as + - * or / used in a formula to perform an arithmetic calculations |
| Functions | Predefined formula that performs calculations using specific values called arguments. |
| AutoSum | Button that quickly inserts Excel functions that summarize all the values in a column or row using a single statstic |
| Page layout view | View that shows how the worksheet will be laid out on the pages sent to the printer |
| Page break preview | View that displays the worksheet as it is divided up into pages. Anything outside the print area is grayed out |
| Formula view | Excel view in which cell formulas are displayed, rather than values returned by formulas |
| Chart | Provides visual representation of workbook data |
| Workbook | File in which excel stores an electronic spreadsheet |
