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 |